Issue 58309

Summary: Add Measurement unit Feet Inches & Fractions
Product: Calc Reporter: 865juniper <jer>
Component: formattingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, lars_o_hansen
Version: OOo 2.0Keywords: oooqa
Target Milestone: ---   
Hardware: All   
OS: All   
URL: http://www.oooforum.org/forum/viewtopic.phtml?t=14674&start=0&postdays=0&postorder=asc&highlight=
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Issue Depends on: 79924    
Issue Blocks:    

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 
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
Comment 1 lars 2005-11-23 17:31:11 UTC 
according to 
http://qa.openoffice.org/issue_handling/workflowcharts/RFE_issues_by_QA.sxd I 
reassign this issue to requirements
Comment 2 lars 2005-11-23 17:31:59 UTC 
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
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 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.