To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=58992 Issue #:|58992 Summary:|SelectAll btn, then OptimalWidth (user) btn corrupts |formulae in cells Component:|Spreadsheet Version:|current Platform:|Opteron/x86_64 URL:| OS/Version:|Linux Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|code Assigned to:|spreadsheet Reported by:|revok
------- Additional comments from [EMAIL PROTECTED] Tue Dec 6 14:03:53 -0800 2005 ------- Custom Toolbar zMine has a button for SelectAll and a button for OptimalWidth ( NOT the instant-one, the one that permits me to set it to 0.2", which I have-to-do because otherwise it prints wrong, but that setting, 0.2" disappears every time I restart OOo, but that's another defect ). Sheet BooksPhase1 has lines in it like Breaking the Real Axis of Evil: How to Oust the World's Last Dictators by 2025 - Mark Palmer | 1 | $25 | =C5*D5 | -shipping- | =E5*PST | =(E5+(shipping)*GST) | =E5+F5+G5+H5 | source-of-item lots-of lines like that. . . The PROBLEM is that when I hit the SelectAll button, and then the OptimalColumnWidth button, then SOMETIMES, SOME-OF the first-column-of-equations change. =C5*D5 turns into =D5*D7 or something. Just now it instead changed-it to the C column, turning =C5*D5 to =C9*C7 -sigh- I give up, really. . . Oh, yeah, the date-format-wrongness is a bug, too: ISO dates are prohibited by OOo 2.0? Helpful, that one. . . Ah, well. . . Datacorruption's a breaker, so I'm stuck going back to either gnumeric or the horrid KSpread or KSheet or whatever it's KCalled, fer now. . . Machine is just-switched-on in last hour, almost nothing run on it this session, AMD64 portable, 1GB of Corsair DDR333, 2GB of swap ( untouched at the moment ), SuSE 9.3 AMD64 Download edition, KDE Take a good look at how this got scrambled: =C9*C7 =C10*C8 =C11*C9 =C12*C10 =C13*C11 =C14*C12 =C15*C13 =C16*C14 =C17*C15 =C18*C16 =C19*C17 =C20*C18 =C21*C19 =C22*C20 =D21*C21 # The re-writing has changed =D22*C22 =C21*D21 # These from here-on are right =C22*D22 =C23*D23 =C24*D24 =C25*D25 =C26*D26 =C27*D27 =C28*D28 It doesn't do it to every-sheet, it doesn't do it every time I do the SelectAll OptimalWidth OK routine, and this is on a pristine .ods workbook because I'd thought that this bug was in a corrupt .ods file, rather-than in Calc itself ( therefore copy-paste the values into a clean start-from-blank spreadsheet -- and discover that it's still doing it ) It MAY be because of OOo being 32-bit on my 64-bit linux? Linux Starhawk 2.6.11.4-21.9-default #1 Fri Aug 19 11:58:59 UTC 2005 x86_64 x86_64 x86_64 GNU/Linux Whatever. . . If you want me to run a test-file or something just ask, but I am switching back to anything that at-least doesn't scramble data now-ish. . . --------------------------------------------------------------------- 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]