https://bugs.documentfoundation.org/show_bug.cgi?id=149019
Bug ID: 149019
Summary: Automatic text wrapping breaks when "very large
spreadsheets" enabled
Product: LibreOffice
Version: 7.3.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 180043
--> https://bugs.documentfoundation.org/attachment.cgi?id=180043&action=edit
Calc: Very large spreadsheets breaks automatic text wrapping and columns to
misalign
Hello, after enabling the experimental "very large spreadsheets" in Calc
options, automatic text wrapping no longer works as expected and produces
undesirable behavior: the complete text in the cell with automatic text
wrapping enabled does not appear; row gridlines appear in the cell; cells
misaligned on other rows.
Steps taken:
1) Enable experimental features and very large spreadsheets:
Tools > Options... > Advanced > Enable experimental features [checked]
2) Restart LO
3) Create a new spreadsheet (in order to access Calc options)
4) Enable experimental features and very large spreadsheets:
Tools > Options... > Calc > Defaults > Enable very large spreadsheets [checked]
5) Create a new spreadsheet (should have 16384 columns and 16 million rows)
6) Enter text in cell A1:
The text in this line is automatically wrapped in the cell. Very large
spreadsheets is disabled.
7) Enable automatic text wrapping:
a. Right click cell A1
b. From the context menu, select Format Cells...
c. Under the Alignment tab, enable "Wrap text automatically"
Text is not wrapped in cell A1 and is partially visible; multiple row gridlines
appear in cell A1,; a small triangle appears on the right hand side at the cell
border.
8) Change the width of column A (the column with the cell that has automatic
text wrapping enabled). Now columns are misaligned from row below (see
attached pic; compare rows 1-14 with rows 15 and below)
I'm using LO 7.3.3.2 on flatpak, openSUSE Leap 15.3 but I found this behaviour
also on Windows and with LO directly from openSUSE's repos, and all previous
versions of LO Calc that can have very large spreadsheets.
--
You are receiving this mail because:
You are the assignee for the bug.
