![]() I'd love to see the use of Unicode for this stuff, as " and ' are used in bash/programming for very important things-things not inches and feet. I consider it mistaken to display a value that cannot likewise be entered verbatim. ![]() But if I put in 3'11" it takes it as a string. Yet when I put in 47", it displays it as 3'11" in the cell. In order for me to enter my original requirement I've had to use: =(29 + 3 / 8) * 25.4 which processes the units as mm which I adjust to reflect inches. Pre-post update: I've set the cell property units to in, which helps. What is the cell parsing rule set of freecad's spreadsheet? Do we have something like regular expressions, only for spreadsheet cell entries? I've been hurt by past habits of assumption, so I don't do that anymore, when possible. The displayed value verifies it, but I'd still like confirmation. Except I'm not assuming that, I'd like confirmation. IF I use =(29 + 3/8) * 25.4 then it reports a value, which I've assumed to be mm. ![]() They enter as strings when they are not understood as formulas. I need to enter fractional inches along with whole inches.Īnd other tries, but none of these are working. Multiplying by 25.4 give me those inches in mm, but that's not what I need. There doesn't seem to be a clear default unit of measure, though I'd assume mm were I to assume. It puts in a value-the value-but not in inches. I am having a full-stop time trying to use fractional inches in the spreadsheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |