To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114459 Issue #|114459 Summary|Editing a statement causes an error Component|Spreadsheet Version|OOo 3.2 Platform|Opteron/x86_64 URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|billgradwohl
------- Additional comments from billgradw...@openoffice.org Sun Sep 12 16:15:53 +0000 2010 ------- On a spreadsheet thats been working for months, I tried to change the contents of a text string by deleting a letter. This produces an error. i.e. Change the word "flour" to "four". This is inside a somewhat complicated IF statement as follows: =IF(AND(C2>0;D2>0);"Either $ or L"; IF(AND((E2+F2)>0;G2>0);"Either lb/oz or kg"; IF(E2+F2+G2=0;""; IF(OR(H2="Y";H2="");"";"Flour must be Y or empty!") ))) Replacing the letter "l" in the line does NOT clear up the error. Any change to this line causes it to show an error. I suspect its an XML issue. I have a sample spreadsheet and instructions that show how to produce the error every time, using nothing more than cell to cell copy and a simple edit to remove a single letter in a text string. How do I upload the sample sheet? I don't have a static IP. --------------------------------------------------------------------- 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