Jump to content
  • 0

VW2024 Worksheet Bug/Problem - Inches display as Feet in worksheet calculations linked to a custom record.


cberg

Question

I was struggling with worksheets this morning, and discovered a VW Worksheet glitch. 

 

VW 2024 makes an error when calculating lengths in a worksheet that is generated from a custom record.  Document Units in both files are set to Feet and Inches.  When I back saved the same file to VW2023 the error went away.

 

  • In the first spreadsheet (VW2024) , a 4" Base Plate displays as 4'-0"  (Not good!)  You can see the record format shows the correct length, but the worksheet miscalculates the units. 
  • In the second spreadsheet (VW2023) the 4" Base Plate displays as 4" (Correct)
  • Screenshot of the custom Record Format and worksheet at the bottom of page. 

 

 

 

ScreenShot2024-05-24at9_27_36AM.thumb.png.0a7f3951cf11f1d4d835b8b649d76d8d.png

 

 

ScreenShot2024-05-24at9_28_36AM.thumb.png.100d8690b74496dc0238d2a39ab8e822.png

 

Some more information about the custom Record Formats

 

 

ScreenShot2024-05-24at9_43_23AM.thumb.png.da326e92d43b61b46840d747fdb8c70b.png

Edited by cberg
Link to comment

6 answers to this question

Recommended Posts

  • 0

I don't believe that VW stores the unit information for fields in custom records. So even though you have 4" listed all VW is seeing is 4.

 

Since this is a custom record you will have to manually do the conversion from decimal feet (which is the internal storage for Feet & Inches).  Feet in the integer portion, inches in the decimal portion.

Link to comment
  • 0

Hi Pat,

 

Thanks for looking at this. 

 

The same file backsaved into VW2023 generates a different worksheet result.  How is is this possible?

 

Assuming you are correct, entering .33 into my record field should result in 4"; however when I do this, the Record Format Length displays as 3/8".

 

ScreenShot2024-05-24at12_01_51PM.png.6acb27190ac1699414f5dbcf9dea2867.pngScreenShot2024-05-24at12_04_21PM.png.e0accde54a352aa7bdd14723c61db875.pngScreenShot2024-05-24at12_02_42PM.png.8fbd63713ffc0d273e6e2bd28ef80686.png

Screen Shot 2024-05-24 at 12.04.21 PM.png

Edited by cberg
Link to comment
  • 0

I am going to offer a correction to my first post.

 

Numbers is Record formats can be configured to be either Dimensions or Numbers.  

 

Fields formatted as Dimensions will automatically convert to whatever dimension settings you use in the document.

 

Fields formatted as Number will have to be manually converted using a formula.

 

If you have a column where you need both, your will probably end up with a very compiled IF statement to try and figure it out.

 

HTH

  • Like 2
Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...