Apache OpenOffice (AOO) Bugzilla – Issue 58309
Add Measurement unit Feet Inches & Fractions
Last modified: 2013-02-07 22:37:18 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 measurements. 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. Jer
according to http://qa.openoffice.org/issue_handling/workflowcharts/RFE_issues_by_QA.sxd I reassign this issue to requirements
according to http://qa.openoffice.org/issue_handling/workflowcharts/RFE_issues_by_QA.sxd I reassign this issue to requirements and set the status to New
reporter adds: The base number is in INCHES ….. like 695.25 inches is 57’ 11- 1/4†or 57-11-04
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.
Issue 79924 (see http://www.openoffice.org/issues/show_bug.cgi?id=79924) 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 http://lists.oasis-open.org/archives/office-comment/200706/msg00036.html.