[sc-issues] [Issue 106244] cannot write 08-09 to a c ell, interperts as a date
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106244 --- Additional comments from rainerbielef...@openoffice.org Sat Apr 10 09:17:34 + 2010 --- *** Issue 110748 has been marked as a duplicate of this issue. *** - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 106244] cannot write 08-09 to a c ell, interperts as a date
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106244 User mechtilde changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from mechti...@openoffice.org Tue Nov 24 18:02:42 + 2009 --- worksforme - closed - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 106244] cannot write 08-09 to a c ell, interperts as a date
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106244 User rainerbielefeld changed the following: What|Old value |New value CC|''|'rainerbielefeld' Status|UNCONFIRMED |RESOLVED Keywords| |oooqa Resolution| |INVALID --- Additional comments from rainerbielef...@openoffice.org Sun Oct 25 11:01:12 + 2009 --- User Error, so INVALID @yomach: Before you file further issues or post again here, please read our guidelines on http://qa.openoffice.org/issue_handling/pre_submission.html and http://www.openoffice.org/bugs/bug_writing_guidelines.html 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 us...@openoffice.org or on the forum at http://user.services.openoffice.org/en/forum/ - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 106244] cannot write 08-09 to a c ell, interperts as a date
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106244 User rainerbielefeld changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from rainerbielef...@openoffice.org Sun Oct 25 11:02:40 + 2009 --- . - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 106244] cannot write 08-09 to a c ell, interperts as a date
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106244 User yomach changed the following: What|Old value |New value Status|CLOSED|UNCONFIRMED Resolution|INVALID | --- Additional comments from yom...@openoffice.org Sun Oct 25 17:42:13 + 2009 --- No, it is still a bug, not a user error. I was just not aware of the workarounds! When i pasted from an outside source a big table with 08-09, 09-10, 10-11 (and so on) everything below 12-13 changed into a date and simply trying to change it back to a number through the cell format resulted in it being changed to 40064. There is a workaround, which is to manually type them again with an ', but that doesn't mean the bug doesn't exist. - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 106244] cannot write 08-09 to a c ell, interperts as a date
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106244 --- Additional comments from rainerbielef...@openoffice.org Sun Oct 25 18:10:25 + 2009 --- @yomach: Can you please try not to open a new issue here for any beginner's mistake you do starting with OOo? For your problems please ask in mailing lists or user forum, there are lots of hints how to do such formatting without any problem. This issue should be set to INVALID again. - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 106244] cannot write 08-09 to a c ell, interperts as a date
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106244 --- Additional comments from yom...@openoffice.org Sun Oct 25 18:13:43 + 2009 --- How is it not a bug if when i paste 08-09 into a cell it turns into 40064?!? - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 106244] cannot write 08-09 to a c ell, interperts as a date
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106244 User regina changed the following: What|Old value |New value CC|'rainerbielefeld' |'rainerbielefeld,regina' Status|UNCONFIRMED |RESOLVED Resolution| |WORKSFORME --- Additional comments from reg...@openoffice.org Sun Oct 25 18:15:28 + 2009 --- If you paste a big table, insert it as unformatted text and set the column header to the correct type in the import dialog. - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 106244] cannot write 08-09 to a c ell, interperts as a date
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106244 --- Additional comments from yom...@openoffice.org Sun Oct 25 18:25:09 + 2009 --- Hmm, It still doesn't work specifically with the table i'm trying to paste as the table get all messed up (I tried that - problem is that the HTML defines where the cells are, but in unformatted form it does not detect it and all the other options in there are a bit useless for that). However, i see your point. Thanks for your help. - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 106244] cannot write 08-09 to a c ell, interperts as a date
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 yom...@openoffice.org Sat Oct 24 16:08:17 + 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 106244] cannot write 08-09 to a c ell, interperts as a date
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106244 User es changed the following: What|Old value |New value Priority|P1|P3 --- Additional comments from e...@openoffice.org Sat Oct 24 17:22:47 + 2009 --- As a new user to OOo, please beware of the priorities: http://www.openoffice.org/scdocs/ddIssues_EnterModify.html#priority - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 106244] cannot write 08-09 to a c ell, interperts as a date
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106244 --- Additional comments from yom...@openoffice.org Sat Oct 24 18:26:26 + 2009 --- Err, sorry again... But maybe this one is even P2? P3 description gives the following example: Functionality which is not available, but a workaround exists; e.g. you cannot apply formattings to your text via the toolbar, but only using the menu In the case i gave you simply cannot change the formatting (unless there is a workaround that i don't know about). and By the way, there is a Typo in the quote i wrote (formattings instead 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 106244] cannot write 08-09 to a c ell, interperts as a date
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106244 --- Additional comments from yom...@openoffice.org Sat Oct 24 18:29:03 + 2009 --- I'll add the fact that this bug was a showstopper for me, after trying to find a workaround it for a couple of minutes i gave up and used google docs... So i think it should be P2 - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 106244] cannot write 08-09 to a c ell, interperts as a date
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=106244
--- Additional comments from ko...@openoffice.org Sat Oct 24 20:22:04 +
2009 ---
There are two ways to work around this.
1) type apostrophe (') in front, which forces the entered value to be
interpreted as text.
2) change the cell format to Text, then type whatever you need to type.
-
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: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 106244] cannot write 08-09 to a c ell, interperts as a date
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106244 --- Additional comments from yom...@openoffice.org Sat Oct 24 20:42:33 + 2009 --- Ok, easy enough workarounds, thanks. - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
