To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107338 Issue #|107338 Summary|R1C1 parser fails to parse ranges Component|Spreadsheet Version|DEV300m65 Platform|All URL| OS/Version|Linux Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|kohei Reported by|kohei
------- Additional comments from [email protected] Tue Dec 1 02:11:45 +0000 2009 ------- The Excel R1C1 parser fails to parse ranges, and all ranges end up producing a #REF! error. 1) Change the formula syntax mode to Excel R1C1. WIth Go-OO you can do that in the Options dialog (under the Formula page). In the upstream build, you need to change the value of the data member ScDocument::eGrammar to GRAM_NATIVE_XL_R1C1 in the constructor of ScDocument. 2) type some numbers in a range of cells. 3) use SUM to sum up those values. 4) you get #REF! instead of a number. --------------------------------------------------------------------- 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]
