[Libreoffice-bugs] [Bug 118946] XLSX file generated from perl script does not import formulas correctly

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #3 from Thomas Seeling <thomas.seeling at gmx.net> ---
The formula generated and stored by perl looks like

<f>IFERROR(VLOOKUP(A1,$Lookup.$A$1:$B$10000,2,FALSE),"")</f>

If I convert the spreadsheet to ODS, then save it again as XLSX the XML looks
different:

<f aca="false">IFERROR(VLOOKUP(D2,Lookup!$A$2:$A$10000,1,0),"")</f>

(those are different cells, so don't mind the different arguments to the
vlookup).

-- 
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/20180726/f4905e73/attachment.html>