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.

Reply via email to