Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Named ranges don't work with range operator (colon) | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | Joe Smith <jes> | ||||||||
Component: | programming | Assignee: | oc | ||||||||
Status: | CLOSED FIXED | QA Contact: | issues@sc <issues> | ||||||||
Severity: | Trivial | ||||||||||
Priority: | P3 | CC: | issues, oc, rb.henschel, stefan.baltzer, weigel | ||||||||
Version: | OOo 3.1 RC2 | Keywords: | oooqa, regression | ||||||||
Target Milestone: | --- | ||||||||||
Hardware: | All | ||||||||||
OS: | All | ||||||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||||||
Developer Difficulty: | --- | ||||||||||
Issue Depends on: | |||||||||||
Issue Blocks: | 101565 | ||||||||||
Attachments: |
|
Description
Joe Smith
2009-05-04 17:39:12 UTC
Created attachment 61984 [details]
sample document showing problem
The attached file loads and works correctly in OOo 3.0.1, but not in OOo 3.1rc2. The formula using the colon range operator fails. Confirm. Testdocument "i4904_ocrange.ods" from issue 4904 (where this feature has been introduced) shows OK in OOo3.0.1 and fails in OOo3.1RC2. I'll attach two files. File "mytestin31" is the file created in OOo310m11_build 9399 on WinXP. It shows the error in cell A5. Then I opened this file in OOo301m15_build9379 and saved it immediately to file "mytestin31 via 301". In OOo301 the sum in cell A5 is calculated correct and opening the file "mytestin31 via 301" in OOo31 also shows no error. When you unpack the files and look into the content.xml, you see three differences (1) OOo31 has the additional namespace xmlns:field="urn:openoffice:names:experimental:ooo-ms-interop:xmlns:field:1.0" (2) OOo31 has an additional style <style:style style:name="ta_extref" style:family="table"> <style:table-properties table:display="false"/> </style:style> (3) OOo31 uses <table:table-cell table:formula="of:=SUM(a1:ende)" office:value-type="float" office:value="0"> <text:p>#NAME?</text:p> where OOo301 uses <table:table-cell table:formula="of:=SUM([.A1]:ende)" office:value-type="float" office:value="6"> <text:p>6</text:p> Created attachment 62052 [details]
as created in OOo31
Created attachment 62053 [details]
resaved with OOo 301
Set target OOo 3.1.1. Reassigned to NN. Put OC on c/c. *** Issue 102632 has been marked as a duplicate of this issue. *** Another case, from issue 102632, is SUM(A1:OFFSET(...)). Grabbing issue. Adding issue to cws dr68ooo311. In cws dr68ooo311: revision 273436 sc/inc/compiler.hxx sc/source/core/tool/compiler.cxx Also in cws calc51 for OOo3.2: revision 273474 sc/inc/address.hxx sc/inc/compiler.hxx sc/inc/externalrefmgr.hxx sc/source/core/data/documen4.cxx sc/source/core/data/table3.cxx sc/source/core/inc/interpre.hxx sc/source/core/tool/address.cxx sc/source/core/tool/compiler.cxx sc/source/core/tool/interpr1.cxx sc/source/core/tool/interpr4.cxx sc/source/ui/docshell/externalrefmgr.cxx Reassigning to QA for verification. verified in internal builds cws_dr68ooo3111 and cws_calc51 Detection of invalid ranges in Chart wizard broken => reopen To reproduce the broken chart feature: new spreadsheet, fill A1:A5 with numbers, insert chart, in chart wizard go to page data ranges, delete the 5 in the datarange => nothing happens, but now the editline has to become red and nearly all controls should be disabled because of the invalid range In cws dr68ooo311: revision 274048 sc/source/core/tool/compiler.cxx sc/source/core/tool/reftokenhelper.cxx Also fixes the cases that already didn't work before this CWS ... In cws calc51: revision 274051 sc/source/core/tool/compiler.cxx sc/source/core/tool/reftokenhelper.cxx Back to QA for verification. More thorough reference checking in chart data ranges; also prevent some possible crash if invalid ranges were to be passed to document/cell access. In cws dr68ooo311: revision 274096 sc/inc/refdata.hxx sc/inc/table.hxx sc/source/core/data/document.cxx sc/source/core/tool/reftokenhelper.cxx In cws calc51: revision 274098 sc/inc/refdata.hxx sc/inc/table.hxx sc/source/core/data/document.cxx sc/source/core/tool/reftokenhelper.cxx verified in internal build cws_dr68ooo311 and cws_calc51 Tested in OOo-dev 3.1 310m17(Build:9415) on Fedora Linux 11 Looks great--thanks! Tested in DEV300_m54 on Fedora Linux 11: OK here, too. Nice! Verified in DEV300m54 on WinXP Closing *** Issue 104492 has been marked as a duplicate of this issue. *** |