[Libreoffice-bugs] [Bug 122098] FILEOPEN XLSX, Function with logic answer gives back 1 or 0 in LO

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=122098

--- Comment #5 from himajin100000 at gmail.com ---
I still haven't checked if the following lines are the culprit, but I suspect
so.

https://opengrok.libreoffice.org/xref/core/sc/source/filter/oox/sheetdatacontext.cxx?r=76fbe494#119
https://opengrok.libreoffice.org/xref/core/sc/source/filter/oox/sheetdatacontext.cxx?r=76fbe494#145

Logicfunction/xl/worksheets/sheet1.xml
<sheetData>
<row r="1" spans="1:2" x14ac:dyDescent="0.25">
<c r="A1" t="b">
<f>EXACT(B1,C1)</f>
<v>1</v>
</c>
</row>
<row r="2" spans="1:2" x14ac:dyDescent="0.25">
<c r="A2" t="b">
<f>EXACT(B2,C2)</f>
<v>0</v>
</c>
<c r="B2" t="s">
<v>0</v>
</c>
</row>
</sheetData>

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20181218/bab2215e/attachment-0001.html>