| Summary: | LET function, round-trip issue with ms sample for the function. | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | m_a_riosv <miguelangelrv> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | NEW --- | ||
| Severity: | normal | CC: | himajin100000, kelemeng |
| Priority: | medium | ||
| Version: | 24.8.0.0 alpha1+ | ||
| Hardware: | All | ||
| OS: | All | ||
| See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=137543 | ||
| Whiteboard: | target:24.8.0 | ||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 150900 | ||
| Attachments: |
Test LET function with sample on Excel help.
LET with array function Export Original file reproduced in Excel 21 My example saved in Calc nightly The original and the Calc-saved file in Excel 21 |
||
|
Description
m_a_riosv
2024-06-07 09:00:38 UTC
Balazs Varga committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/5a75414d1772d1fd998f405e3b9bd80b1f10c51f tdf#161454 - Fix new array functions handle empty matrix cells It will be available in 24.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. > https://git.libreoffice.org/core/commit/
> 5a75414d1772d1fd998f405e3b9bd80b1f10c51f
So this patch only related to this issue: "Also, there is a different result involving blank cell in source data."
The other one "Creating the sample in Excel (xlsx), it opens as array in Calc, but saving and opening again in Excel, doesn't work." unfortunatelly, I have no idea atm, checked the xml files and everything looked fine around the let function. Also in case of other inside array function in the LET function it is worked fine in MSO after LO export. Atteched an example document. But I saw some suspecios line in the workbook.xml which were missed from the exported file but not from the original file. May be related to this issue.
<xcalcf:calcFeatures>
<xcalcf:feature name="microsoft.com:RD" />
<xcalcf:feature name="microsoft.com:Single" />
<xcalcf:feature name="microsoft.com:FV" />
<xcalcf:feature name="microsoft.com:CNMTM" />
<xcalcf:feature name="microsoft.com:LET_WF" />
<xcalcf:feature name="microsoft.com:LAMBDA_WF" />
<xcalcf:feature name="microsoft.com:ARRAYTEXT_WF" />
</xcalcf:calcFeatures>
Created attachment 194621 [details]
LET with array function Export
Verified about the empty cell Version: 24.8.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 5a75414d1772d1fd998f405e3b9bd80b1f10c51f CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded About the array, in your sample file the function looks like an explicit array, but in Excel if you delete the LET formula and introduce it only with enter, the array is also created but without being an explicit array ({}). Opening the last in LO it is an explicit array formula. Saving in LO and opening it in Excel, work with the explicit array. But I think the issue is LO importing the formula as an explicit array, what it is not in Excel. Created attachment 194641 [details]
Original file reproduced in Excel 21
Created attachment 194642 [details] My example saved in Calc nightly Version: 24.8.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 5a75414d1772d1fd998f405e3b9bd80b1f10c51f CPU threads: 6; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win Locale: en-GB (en_GB); UI: en-US Calc: default I believe I managed to create a CSE array in the A28 cell, yet it is broken the same way by Calc as the one in A11 Created attachment 194643 [details]
The original and the Calc-saved file in Excel 21
|