[Bug 170788] LibreOffice Calc LET Function broken when lowercase

[bugzilla-daemon]

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

--- Comment #11 from calcan...@gmail.com ---
Yes, Excel opens the file and the function parses correctly and displays the
expected value.  The difference between the GS exported xlsx vs Excel saved
xlsx is below:

GS export to xlsx:

<f>IF(A1&lt;&gt;&quot;Active&quot;,&quot;N/A&quot;,LET(avg, AVERAGE(A2:A4),
IF(avg&gt;=4, &quot;Great&quot;, IF(avg&gt;=3, &quot;Good&quot;,
&quot;Poor&quot;))))</f>

Excel save as xlsx:

<f>IF(A1&lt;&gt;"Active","N/A",_xlfn.LET(_xlpm.avg, AVERAGE(A2:A4),
IF(_xlpm.avg&gt;=4, "Great", IF(_xlpm.avg&gt;=3, "Good", "Poor"))))</f>


In xlsx format, both LET functions are uppercase. However, the GS example omits
the "_xlfn." function scope and "_xlpm." variable prefixes, but Excel still
handles it fine.

-- 
You are receiving this mail because:
You are the assignee for the bug.