https://bugs.documentfoundation.org/show_bug.cgi?id=161454
Bug ID: 161454
Summary: LET function, round-trip issue with ms sample for the
function.
Product: LibreOffice
Version: 24.8.0.0 alpha1+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 194579
--> https://bugs.documentfoundation.org/attachment.cgi?id=194579&action=edit
Test LET function with sample on Excel help.
Attached a sample test for LET function, taken from function help in Excel
https://support.microsoft.com/en-au/office/let-function-34842dd8-b92b-4d3f-b325-b8b8f9908999
Sample 2.
Creating the sample in Excel (xlsx), it opens as array in Calc, but saving and
opening again in Excel, doesn't work.
Also, there is a different result involving blank cell in source data.
Version: 24.8.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: 6d39b1a6068bbbd5ca4947f668f989dbfb73342d
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
Microsoft® Excel® para Microsoft 365 MSO (versión 2405 compilación
16.0.17628.20006) de 64 bits
Perhaps the issue is not with LET but the array's manage.
--
You are receiving this mail because:
You are the assignee for the bug.