To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=109799
User rainerbielefeld changed the following:
What |Old value |New value
================================================================================
CC|'' |'rainerbielefeld'
--------------------------------------------------------------------------------
Keywords| |needhelp, needmoreinfo, oo
| |oqa
--------------------------------------------------------------------------------
Priority|P1 |P4
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Fri Mar 5
06:48:09 +0000 2010 -------
I checked with "Ooo 3.1.1 WIN XP DE[OOO310m19 (Build 9420)]"!
I tested a sample with entries:
Date 5.3.2010 =today()
Cell above as No (40242) Cell above as No (40242)
What I saved as .ods and .xls each with standard time base and starcalc 1 time
base.
And I saw reopening those documents:
OOo samplenormaldatesetting.ods:
05.03.10 05.03.10 (All as expected)
40242 40242
OOo samplenormaldatesetting.xls:
05.03.10 03.05.10 (why does formula show May?)
40242 40242
OOo samplesc10datesetting.ods:
07.03.10 05.03.10 (All as expected)
40242 40240
OOo samplesc10datesetting.xls:
05.03.10 03.05.10 (why does formula show May?)
40242 40242
Excel Viewer with samplenormaldatesetting.xls:
05.03.10 03.05.10 (why does formula show May?)
40242 40242
Excel Viewer with samplesc10datesetting.xls:
05.03.10 03.03.10 (why does formula show 3.3.?)
40242 40240
I'm a little worried, someone with more knowledge should check and explain.
@aryamanoj:
The Issue tracker is not a user help facility. Please read the FAQ and other
information linked in the left frame of this screen. You can get help from the
public users mailing list [email protected] or on the forum at
<http://user.services.openoffice.org/en/forum/>
If you want to report a bug, please be much more specific.
Don't write things like "all dates are changed". You have to check, whether the
effect appears when you save or when you open, it is interesting what "viewer"
with what settings you use, when you changed settings (before you opened a
document or afer you opened a document)...
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
