|
Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
| Summary: | The function 'autoincrement' should also consider common used textstrings added to numbers (like 1'st', 2'nd', 3'rd' , 4'th'...). MS Excel does this. | ||
|---|---|---|---|
| Product: | Calc | Reporter: | philmperry <philperry> |
| Component: | editing | Assignee: | AOO issues mailing list <issues> |
| Status: | CONFIRMED --- | QA Contact: | |
| Severity: | Trivial | ||
| Priority: | P3 | CC: | issues |
| Version: | 605 | Keywords: | ms_interoperability, rfe_eval_ok, usability |
| Target Milestone: | --- | ||
| Hardware: | All | ||
| OS: | All | ||
| Issue Type: | ENHANCEMENT | Latest Confirmation in: | --- |
| Developer Difficulty: | --- | ||
Besides quarters ("Qtr[s]" or "Quarter[s]"), the same problems (except
for the wrap around at 4) apply to autoincremented text like "1st
Street", "2st Street" [sic].
This is not a bug, but a missing feature. The autoincrement function doesn't know anythink about quaters and spelling. This function does only increment the number. For getting the wished result it would be nessesary to implement a special sortlist for quaters. Summary: The function 'autoincrement' should also consider common used
textstrings added to numbers (like 1'st', 2'sd',3'rd' , 4'th'...):
If you put "1st Qtr" into a cell, and copy-drag the cell, the text of the new
cells will be "2st Qtr", "3st Qtr", "4st Qtr", "5st Qtr", etc. Three problems
here: the "st" should be (language-dependent, of course) "nd", "rd", "th", etc.
Always having "<n>st" simply doesn't cut it. For English, anything ending in 1
(ex. ending in 11) should be "st", ending in 2 (ex. ending in 12) should be
"nd", ending in 3 (ex. ending in 13) should be "rd", and otherwise should be
"th". Second problem: Quarters ("Qtr" or "Quarter(s)") should wrap around after
4: 1st, 2nd, 3rd, 4th, 1st, etc. At least, that's how Excel does it (open to
debate: configure to allow 5th Qtr, etc., and to allow wrap around at 4 but
increment year (e.g. "4th Qtr 97", "1st Qtr 98", ...)). Third problem: "st" is
displayed as superscript, but only for "1st". I would leave it as regular text.
This issue is considered for OO.o later.
enhanced summary, set keywords and reassigned issue according to RFE process OpenOffice.org Issue Tracker - Feedback Request. The Issue you raised is currently assigned to 'Requirements' pending review, but has not been updated within the last 3 years. Please consider re-testing with one of the latest versions of OOo, as the problem(s) may have already been addressed. Either use the recent stable version: http://download.openoffice.org/index.html or consider trying the new OOo 3 BETA (still in testing): http://download.openoffice.org/3.0beta/ Please report back the outcome so this Issue may be Closed or Progressed as necessary - otherwise it may be Resolved as Invalid in the future. You may also wish to search for (and note) any duplicates of this Issue that may have advanced further by checking the Issue Tracker: http://www.openoffice.org/issues/query.cgi Many thanks, Andrew Cleaning-up and Closing old Issues as part of: ~ The Grand Bug Squash, pre v3 ~ http://marketing.openoffice.org/3.0/announcementbeta.html |
If you put "1st Qtr" into a cell, and copy-drag the cell, the text of the new cells will be "2st Qtr", "3st Qtr", "4st Qtr", "5st Qtr", etc. Three problems here: the "st" should be (language-dependent, of course) "nd", "rd", "th", etc. Always having "<n>st" simply doesn't cut it. For English, anything ending in 1 (ex. ending in 11) should be "st", ending in 2 (ex. ending in 12) should be "nd", ending in 3 (ex. ending in 13) should be "rd", and otherwise should be "th". Second problem: Quarters ("Qtr" or "Quarter(s)") should wrap around after 4: 1st, 2nd, 3rd, 4th, 1st, etc. At least, that's how Excel does it (open to debate: configure to allow 5th Qtr, etc., and to allow wrap around at 4 but increment year (e.g. "4th Qtr 97", "1st Qtr 98", ...)). Third problem: "st" is displayed as superscript, but only for "1st". I would leave it as regular text.