Converting units in worksheet

[drelARCH]

We have window schedule (worksheet database type) reporting dimensions in feet and inches but would like to have it also in metric units as cm, m...Is there formula to do the convert? We have looked into worksheet functions and found 'ToUnit' but not luck so far to make it work.

Primary file units are feet and inches.

 

Thanks for any advice.

Pavol

[Pat Stanford]

If you only need the metric units for display and don't need to do calculations on them then the =txt() function should be able to do what you want.

 

Assuming your database header is in Row 3 and the value you want to convert is in column C, then

 

=txt(C3, 'Centimeters', '0.00', 'Units', 'ThousandsSeparator', 'TrailingZero', 'LeadingZeroes')

 

should return the value as a text string in centimeter, with two decimal places of accuracy, using the default thousands separator and using trailing and leading zeros'

 

 

The full reference for the txt function is on the Developer Site.

 

https://developer.vectorworks.net/index.php?title=Worksheet_Functions

[Pat Stanford]

Notice how column C is Right Aligned indicating that it is a number, while column D is Left Aligned indicating it is text.  So you won't be able to do math on the values in column D.

 

If you need to do math on the metric values, you should be able to wrap a version of the txt() function that does not include the units or leading/trailing zeros and no thousands separators in a Value function to get a number.

 

=Value(txt(C3,'0.0000','centimeters'))

 

HTH

[drelARCH]

Thanks a lot @Pat Stanford for both options. They work really great!

 

It took me some time to realise that I probably have to adjust some notation in order to make it work for me ...  but this second sentence from Worksheet Functions was there to help :-)
(In European notation, the decimal "." should be "," and the separator "," should become ";".)

 

Thanks!

Edited October 3, 2023 by drelARCH

[Pat Stanford]

Maybe I should add Location to my request for people to include OS and VW Version to their signatures.  Then I might remember more often to make the Comma/Semicolon speech for worksheet functions. 😉

 

Glad you figured it out.

[drelARCH]

4 minutes ago, Pat Stanford said:

Maybe I should add Location to my request for people to include OS and VW Version to their signatures.  Then I might remember more often to make the Comma/Semicolon speech for worksheet functions. 😉

 

Glad you figured it out.

 

😀