To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106244 Issue #|106244 Summary|cannot write 08-09 to a cell, interperts as a date Component|Spreadsheet Version|OOo 3.1.1 RC2 Platform|All URL| OS/Version|Windows Vista Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P1 Subcomponent|formatting Assigned to|spreadsheet Reported by|yomach
------- Additional comments from [email protected] Sat Oct 24 16:08:17 +0000 2009 ------- Hello, When i try to write 08-09 to a cell it automatically interprets that as a date and changes the format to 08/09/09, but since it is not a date i try to change the cell format to a general number, it then changes the value to 40064. when i try to write 08-09 again the same thing repeats itself! I'm currently building a schedule and the 08-09 should represent the time between 8am and 9am... I'm recently moved from MS Office but in my 2 last attempts to work with calc i've unfortunately found out 3 bugs in 10 minutes, those bugs were show-stoppers for me didn't allow me to continue working... I still have hope though and i want to support this project, so i am reporting it... In MS Office, as far as i can tell, the data that was entered into a cell was never changed and the "formatting" only changed the way it was represented, that helped avoid issues like the above. Every cell basically had 2 different parameters, one was the value written (and that was never changed) and one was the value shown (the result of formatting). --------------------------------------------------------------------- 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]
