[Issue 117843] CALC - MATCH function doesn't work on external file

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=117843

hanya <ha...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |hanya.runo@gmail.com

--- Comment #5 from hanya <ha...@gmail.com> ---
For the match against external document, matching scan is done against the data
matrix 
in ScInterpreter::ScMatch method. 
The matrix data is constructed from the copied data into content.xml file from 
the external file.

It seems the problem is caused by the copied data into the file. The data
contains 
different values from the original.

- Target.ods document contains some data in Sheet1.C1:E1 (A1 and B1 are empty).
<table:table table:name="Sheet1" table:style-name="ta1" table:print="false">
  <table:table-column table:style-name="co1" table:number-columns-repeated="5"
table:default-cell-style-name="Default"/>
  <table:table-row table:style-name="ro1">
    <table:table-cell table:number-columns-repeated="2"/>
    <table:table-cell office:value-type="string">
    <text:p>A</text:p>
      </table:table-cell>
    <table:table-cell office:value-type="string">
      <text:p>B</text:p>
    </table:table-cell>
    <table:table-cell office:value-type="string">
      <text:p>C</text:p>
    </table:table-cell>
  </table:table-row>
</table:table>

- I got the following data that copied into the file that contains MATCH
function like: 
=MATCH("B";'file:///home/asuka/Documents/TestDocs/Target.ods'#$Sheet1.$A$1:$F$1;0)

<table:table
table:name="'file:///home/asuka/Documents/TestDocs/Target.ods'#Sheet1"
table:print="false" table:style-name="ta_extref">
  <table:table-source xlink:type="simple" xlink:href="../TestDocs/Target.ods"
table:table-name="Sheet1" table:filter-name="calc8"
table:mode="copy-results-only"/>
  <table:table-column table:number-columns-repeated="5"/>
  <table:table-row>
    <table:table-cell table:number-columns-repeated="2"/>
    <table:table-cell table:style-name="ce1" office:value-type="float"
office:value="6.9532872652317E-310">
      <text:p>6.9532872652317E-310</text:p>
    </table:table-cell>
    <table:table-cell table:style-name="ce1" office:value-type="float"
office:value="6.95328726508467E-310">
      <text:p>6.95328726508467E-310</text:p>
    </table:table-cell>
    <table:table-cell table:style-name="ce1" office:value-type="string">
      <text:p>A</text:p>
    </table:table-cell>
  </table:table-row>
</table:table>
Before the cell that contains "A", strange two cells are placed.

-- 
You are receiving this mail because:
You are on the CC list for the issue.
You are watching all issue changes.