Spreadsheet Units default to mm

[Rhinokeegan]

I'm using version 0.18 and I'm quite new.

I've changed the units in preferences to "imperial decimal (in/lb)"

When entering numbers into a spreadsheet the default to mm. Even when I change the cell preferences "Unit string" to "in".

Example: I enter 10 (meaning 10 inches) and it displays 0.394 in (meaning 10mm)

It only works if I enter "10in" into the cell. This is a workaround but half the time I forget to put the "in" after the value I enter.

Is there a way to set the default units in a spreadsheet to inches? My old American brain just doesn't want to work in metric

Thanks!

[Razmatazz#8594]

Bumping this thread because I'm having the same problem, too.

I've got my preferences set to use imperial units.

If I put a value into my spreadsheet (e.g. "10"), and then change the cell properties -> display units to "in" (no quotes), the cell value changes to "0.39 in".

How can I input "10" as my value, and actually have it interpreted as 10 inches?

OS: Windows 10 Version 2009
Word size of FreeCAD: 64-bit
Version: 0.20.25645 (Git)
Build type: Release
Branch: master
Hash: 37d9757399b4c2ec30318eb88d7cd7c508246345
Python version: 3.8.6+
Qt version: 5.15.2
Coin version: 4.0.1
OCC version: 7.5.0
Locale: English/United States (en_US)

[Roy_043]

Spreadsheet_Workbench#Units