Created attachment 196409 [details] Failing example using WITH block In LO 7.x assignment to struct members worked in LO BASIC within a WITH block. Assignment fails in LO 24.8.1.2. WITH BLOCK Example 1: Worked in LO 7.x, failed in LO 24.8.1.2 With RangeAddress .StartColumn = StartColumn .StartRow = StartRow .EndColumn = EndCellRange.EndColumn .EndRow = EndCellRange.EndRow .Sheet = EndCellRange.Sheet End With WITH BLOCK Example 2: Works in LO 24.8.1.2 and presumably in LO 7.x RangeAddress.StartColumn = StartColumn RangeAddress.StartRow = StartRow RangeAddress.EndColumn = EndCellRange.EndColumn RangeAddress.EndRow = EndCellRange.EndRow RangeAddress.Sheet = EndCellRange.Sheet See attachments for full working examples
Created attachment 196410 [details] Working example using WITH block
I confirm this error in my system. Version: 24.8.1.2 (X86_64) / LibreOffice Community Build ID: 480(Build:2) CPU threads: 16; OS: Linux 6.10; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US 24.8.1-1 Calc: threaded
https://gerrit.libreoffice.org/c/core/+/173305
Mike Kaganski committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/47a348bb0fd6dfdd93c1975d216daadc4f6b9b6f tdf#162935: use PUTC for WITH variable assignment: it doesn't copy value It will be available in 25.2.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.
Mike Kaganski committed a patch related to this issue. It has been pushed to "libreoffice-24-8": https://git.libreoffice.org/core/commit/ffd39976cb982f0f32e802b43364de8f29653a2e tdf#162935: use PUTC for WITH variable assignment: it doesn't copy value It will be available in 24.8.2. 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.