Description:
Same symptoms as in https://bugs.documentfoundation.org/show_bug.cgi?id=99584 except the test case here works in 7.6.3.0, whereas bug 99584 was about similar-looking problems present all the way back to 4.2 .

I'm opening a separate bug because this seems to be a regression since 7.6.3.0 and before 24.2 (but is also present in 24.8 alpha).   Maybe a bisect could be useful?

This demo spreadsheet uses macros to populate cells and also conditional formats, which might (or not) be related to the current symptoms.



Steps to Reproduce:
1. Open the attached Tdemo.ods (please enable macros)
2. On the _PROTO sheet, click the red "Test" button

(this runs a macro which creates a new sheet "MSFT" and populates it with data)

3. In the MSFT sheet: Set magnification to 100% if needed
4. Resize columns for Optimal Width with 0.00 additional space
   (Select all columns; put cursor in a column header; 
    rightclick->Optimal Width..., set the Add to 0.00, click OK)

Actual Results:
Some cells display ###.

Note especially column E where the values shown as "###" are all constants, not numbers -- however E4, which is horizontally spanned and does not overflow, was set by a macro (details below).

Expected Results:
All data should fit in the optimized column widths


Reproducible: Always


User Profile Reset: No

Additional Info:
The horizontally-spanned cell E4 contains the string "TESTDATA sheet" which was put there in Basic macro code by executing

  NewSheet.getCellRangeByName("SourcePathCell").String = "TESTDATA sheet"

(where SourcePathCell is a Named Range equivalent to $E$4 -- which can be seen via Sheet->Named Ranges and Expressions->Manage)

-----
NOT REPRO in 7.6.3.0.0

REPRO in 24.2 and master:

Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 3b73071f7a7fcf80547da81e5effe4ed6018bbb4
CPU threads: 12; OS: Linux 6.5; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded