Author Topic: Change number from measurement to just a decimal number  (Read 531 times)

0 Members and 1 Guest are viewing this topic.

Mouthpear

  • Jr. Member
  • **
  • Posts: 13
Change number from measurement to just a decimal number
« on: September 01, 2022, 10:33:57 PM »
How do you change a number that is a measurement in to a regular number.


How it comes out
Sheet.1!Width = 50.000 mm 

What is needed.
Sheet.1!Width = 50.000
« Last Edit: September 01, 2022, 10:36:31 PM by Mouthpear »

Surrogate

  • Hero Member
  • *****
  • Posts: 1730
    • ShapeSheet™ Knowledge Base
Re: Change number from measurement to just a decimal number
« Reply #1 on: September 01, 2022, 11:08:40 PM »
Where you need watch these numbers:
  • Size & position window
  • Shape's field

hidden layer

  • Full Member
  • ***
  • Posts: 118
Re: Change number from measurement to just a decimal number
« Reply #2 on: September 02, 2022, 03:22:16 AM »
It looks like a shapesheet's cell (Width)
This is already a number - it just looks like no number but it is.

If you have a look at the field LocPinX you can see that there's already a formula in it which uses the value of Width (if you take a simple rectangle).

For other cells you can check if these are numbers (to calculate with):

1. insert  the section "user defined cells" or a new line in it
2. insert the formula: (the cell you want to calculate with) * 2
3. If the calculation is correct, it's easy
4. If not you have to separate the "numbers" (mid(...)) *1 in order to have NUMBERS.

cheers
hl

Surrogate

  • Hero Member
  • *****
  • Posts: 1730
    • ShapeSheet™ Knowledge Base
Re: Change number from measurement to just a decimal number
« Reply #3 on: September 02, 2022, 04:01:07 AM »
4. If not you have to separate the "numbers" (mid(...)) *1 in order to have NUMBERS
  IMHO best way use formulas like
Quote
=width/1 mm