Issue 58309 - Add Measurement unit Feet Inches & Fractions
Summary: Add Measurement unit Feet Inches & Fractions
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.0
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on: 79924
  Show dependency tree
Reported: 2005-11-22 15:12 UTC by 865juniper
Modified: 2013-02-07 22:37 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description 865juniper 2005-11-22 15:12:00 UTC
Some nations (mainly These United States) are still using Feet and Inches for 
measuring.  As a Contractor and a Truss Manufacturer we have need of using such 

Need: To be able to format cells to both of these ways of displaying the data

1st: Feet (space) Inches (space) fractions   57' 11-1/4"  ... Note the rounding 
on the frations needs to be intelligent 64th, 32nd, 16th, 8th, quarter, 
half ....I see that the current rounding is such that one could end up with 4/9 
and 17/57 which isn't very useful to a contractor. The rounding needs to happen 
in the FORMAT of the cell.
2nd: In many wood truss designing software and other construction software we 
us the format of FEET-INCH-SIXTEENTH  FF-II-SS  like 57-11-04 it looks like a 
date format but read 57 feet 11 inches and 4 sixteenths.  We use this method 
most because it is easier to type and to format the date consistantly.  But 
both formats are needed.

Thank You.
Comment 1 lars 2005-11-23 17:31:11 UTC
according to I 
reassign this issue to requirements
Comment 2 lars 2005-11-23 17:31:59 UTC
according to I 
reassign this issue to requirements and set the status to New
Comment 3 lars 2005-11-25 16:23:46 UTC
reporter adds:

The base number is in INCHES   ….. like    695.25    inches is   57’ 11-
1/4†   or   57-11-04
Comment 4 renetta 2006-01-10 03:19:01 UTC
I am new to openoffice but have a lot of experience in Excel.  I also had the 
need to add in feet and inches for some designs I'm working on.  I've written 
a formula that can be inserted into the cells that will produce and add in 
feet and inches.  The formula doesn't currently work for 16th's.  However, if 
you do need a formula I would be glad to edit and make available.
Comment 5 discoleo 2007-08-07 21:14:28 UTC
Issue 79924 (see might
be interesting for this one, too. I focused there mainly on currency, but
length-units would be just an extension.

Units were discussed more broadly on the OASIS mailing list. See the links
posted for the issue mentioned earlier. For a thoughtful discussion on the OASIS
list, see