incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 114132] When saving a spreadsheet the cells formatted as date are modified
Date Mon, 01 Oct 2012 04:09:22 GMT
https://issues.apache.org/ooo/show_bug.cgi?id=114132

Srinath <rajaram.srinath3214@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |rajaram.srinath3214@gmail.c
                   |                            |om

--- Comment #8 from Srinath <rajaram.srinath3214@gmail.com> ---
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.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
Mime
View raw message