Issue 107338 - R1C1 parser fails to parse ranges
Summary: R1C1 parser fails to parse ranges
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: DEV300m65
Hardware: All Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: thb
QA Contact: issues@sc
URL: https://bugzilla.novell.com/show_bug....
Keywords:
Depends on:
Blocks: 20857
  Show dependency tree
 
Reported: 2009-12-01 02:11 UTC by kyoshida
Modified: 2017-05-20 10:20 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description kyoshida 2009-12-01 02:11:45 UTC 
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.
Comment 1 kyoshida 2009-12-01 02:13:14 UTC 
started in kohei04 cws.
Comment 2 kyoshida 2009-12-01 03:38:19 UTC 
fixed in kohei04 cws.

http://hg.services.openoffice.org/cws/kohei04/rev/8823953a3430
Comment 3 kyoshida 2010-02-09 21:28:05 UTC 
re-assigning to Thorsten for QA verification.
Comment 4 thb 2010-03-09 00:20:56 UTC 
Verified in CWS