https://bugs.documentfoundation.org/show_bug.cgi?id=163964
--- Comment #2 from Gauthier <[email protected]> --- Created attachment 197774 --> https://bugs.documentfoundation.org/attachment.cgi?id=197774&action=edit test file demonstrating issues Actually after more test I realised the issue is slightly more complex than how I first reported it in the bug report. It has in fact to do with inconsistencies when the scope of the expressions are set to one sheet only, instead of global. They work fine in LO but some of them stop working in MS Excel. This is in fact due to the sheet name not being appended to some of the expressions (strangely not consistent across all), which is how the scope seem to be defined in Excel. In the attached file, you'll see that in Excel: expr2 = Sheet1!$B$2+numb >> this does not work expr3 = Sheet1!$A$3/Sheet1!numb >> this works fine When going to Excel (Name Manager), just opening the expression that doesn't work and save it again makes it work as Excel then automatically appends sheet name to it (e.g. expr2 become: Sheet1!$B$2+Sheet1!numb). Version: 24.8.3.2 (X86_64) Build ID: 480(Build:2) CPU threads: 12; OS: Linux 6.11; UI render: default; VCL: kf6 (cairo+wayland) Locale: en-GB (en_GB.UTF-8); UI: en-US Calc: threaded MS Office 2021 Win 11 -- You are receiving this mail because: You are the assignee for the bug.
