https://bugs.documentfoundation.org/show_bug.cgi?id=159945
Bug ID: 159945
Summary: (Regression since 7.6) Optimal-width columns too small
(shows '#' chars)
Product: LibreOffice
Version: 24.2.0.0 alpha1+
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug.
