To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=86843 Issue #|86843 Summary|Algebra formula did not work at all Component|Spreadsheet Version|OOo 2.3.1 Platform|HP URL| OS/Version|Windows Vista Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|gilviz
------- Additional comments from [EMAIL PROTECTED] Sun Mar 9 17:56:45 +0000 2008 ------- I tried to work with a Calc file spread sheet, addig a simple formula condition, (I write the formula the way i would do it on Microsoft Office Excel sheet) it did not work as expected... the formula is writen on cell "A1" with conditions affecting the value on cell "B1" example: =if(B1=5,"five",if(B1<5,"less",if(B1>5,"more"))) No matter the value I place on cell "B1" the result showed on cell "A1" still the same "#NAME?" type de bove formula on Office Excel and compare. Also, tried to copy this formuala with a simple "right click" and paste it into an Microsoft excel sheet and it didn't seem to be compatible at all... I was able to find other anoying issues with the calc application but for now I'll like just to report this one, which in my opinion is the most important. I hope I did something wrong and is not a real issue with OpenOffice.org Thank you Regards GV --------------------------------------------------------------------- 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]
