To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74148
------- Additional comments from [EMAIL PROTECTED] Sun Feb 4 21:52:38 +0000 2007 ------- I just managed to reproduce the bug with a new document. Started a completely new spreadsheet, formatted column A to percent, entered 100% for the value of A1 and 1 for B1, which was unformatted. Save, close, reopen document and B1 showed up as 100%. It happens every single time I create a new document from scratch. If any column as a whole is formatted to some type of variable (e.g. percent), everything from that point rightward that has the same value (e.g. 100% followed by 1) will revert to the preceding format. If you then add a value to the left of the original (e.g a numerical one to the left of a percentile column with a 100% value), the percentile will revert to number but the data it corrupted earlier stays in the wrong format. It also seems that formatting a single specific cell will sometimes allow that cell to stay in the corrected format, but the results are neither predictable nor reliable. I am unsure whether document size has any effect on that. The Dom3DB document that I originally submitted doesn't seem to accept any corrections but reverts constantly (even if ALL formats are removed and then each column is reformatted separately), while a new 1-row spreadsheet sometimes does and sometimes doesn't. The bug might also have some relation to how OO adds new columns if one notices a need for new columns to be added somewhere in between existing ones, which is how many of the example file's columns have been added. The program seems to read the column format from the left of the new one and tack that on instead of leaving the new column unformatted, which may have some bearing on the problem. This is using a complete install of OO 2.1 on Windows XP SP2. I suppose it is possible that 2.2 has had this issue fixed and it will only show up on documents created with earlier versions. --------------------------------------------------------------------- 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]
