Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | When saving a spreadsheet the cells formatted as date are modified | ||
---|---|---|---|
Product: | Calc | Reporter: | gomeshenry <gomeshenry> |
Component: | save-export | Assignee: | AOO issues mailing list <issues> |
Status: | RESOLVED FIXED | QA Contact: | |
Severity: | Trivial | ||
Priority: | P2 | CC: | issues, misterDormie, oliver.brinzing, rainerbielefeld_ooo_qa, rajaram.srinath3214 |
Version: | OOO320m19 | Keywords: | needhelp, needmoreinfo, oooqa |
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | All | ||
Issue Type: | DEFECT | Latest Confirmation in: | --- |
Developer Difficulty: | --- | ||
Attachments: |
Description
gomeshenry
2010-08-26 20:10:01 UTC
Created attachment 71415 [details]
Spreadsheet with the dates in column 'D' on every sheet; when saved, closed and opened, the dates are not the same anymore
Reproducible with "Ooo 3.1.1 WIN XP DE[OOO310m19 (Build 9420)]" and with "Ooo-Dev 3.3.0 multilingual version English UI WIN XP: [OOo330m1 (Build 9514)]"! I saved under new name, closed and reopened several times, with each new reopen (see 1. ... 4.) date in column 'D' was reduced 1462 days: 1. 1 2010-07 SC Happy Kids Club 25.01.2002 2. 1 2010-07 SC Happy Kids Club 24.01.1998 3. 1 2010-07 SC Happy Kids Club 23.01.1994 4. 1 2010-07 SC Happy Kids Club 22.01.1990 The effect only appears with Menu "Tools -> Options -> Calc -> Caldulate -> Date' setting is "default", effect disappears with date base setting 01.01.1904 (difference between these 2 dates is exactly 1462 days) Effect disappears when I save document one time with date base 01.01.1904. After I switched back to default date base, date remained constant. Currently I will not modify issue status to NEW, may be the problem has been caused by an user error (incorrect document import). I can't decide whether this is an "open-import" or "save-export" issue. @gomeshenry: Please - do not use indifferent topics like "are different", use precise descriptions! - tell us your date base settings - tell us document history, with what spreadsheet program has it been created? I am happy that you could reproduce the problem on your system. Many thanks for the tip to use precise descriptions; I will do this in future issues. I can confirm that this spreadsheet was made in Calc from Openoffice, and with this version. There was no import from another format. The date base setting is the 'default' 12/30/1899. Created attachment 71423 [details]
Screenshot-Options to see the date base setting in my system
. Comment on attachment 71415 [details]
Spreadsheet with the dates in column 'D' on every sheet; when saved, closed and opened, the dates are not the same anymore
I have a similar problem, when tables are used in Writer.
1. Column's numeric date format defined as: mm/dd/yyyy
2. Valid date is entered into the field
3. File is saved and closed
4. Open file
5. In the date column, enter a valid date in an empty cell
NOTE: The numeric date format has been changed to: mm/dd/yy
Created attachment 79699 [details]
Snap Shot of the replicated document
This is the snap shot which I have mentioned as attached.
Commenter name and date Commenter Name : Srinath Rajaram Comment Date: 09/30/2012 Environment in which the bug has been replicated Successfully replicated the bug using the following environment: OS: Windows 7 Tool: Open Office Version: 3.4.1 Build: 1372282 Steps performed while replicating the bug Here are the steps that were followed to replicate the bug: (1) Create a new text document named date.odt. (2) Table Insert Table (With 2 rows and 2 columns) (3) Add the below date in the first row, first column (07/05/2012) and try to save the file, it will be saved as (07/05/12) (4) You can also try replicating the bug by adding some other dates (for eg: 09/08/2015) and you will find that the first two fields in the year will be missing after saving the document. (5) This issue doesn’t occur when I tried adding a date without a table. (6) I am attaching the screen shot of the same along with this comment. I suppose this is a bug, please have a look at the same. Why this bug would be important to customers (1) Date is one of a vital parameter, which people use to denote certain important events. In a table, date field is used as a factor to represent the occurrences of the event in that row and hence the representation of this has to be clear. (2) Representation of the date like the below may lead to many confusions, for instance the following date can be interpreted as below (07/05/05) o This could have been interpreted as (YY/MM/DD) or the year can also be interpreted as 1905 instead of 2005. Hence a communication lag occurs here and hence this issue has to be prioritized. This Issue requires more information ('needmoreinfo'), but has not been updated within the last year. Please provide feedback as requested and re-test with the the latest version of OpenOffice - the problem(s) may already be addressed. You can download Apache OpenOffice 3.4.1 from http://www.openoffice.org/download Please report back the outcome of your testing, so this Issue may be closed or progressed as necessary - otherwise the issue may be Resolved as Invalid in the future. Tested OK with Libre-Office Calc 3.5 running in Opensuse 12.2 (64bit) Gnome 3.4.2 |