Description: I pasted in an html table and did a format column optimal width to show partially hidden data but it did not work any more. Steps to Reproduce: 1.Paste in a html table with varied widths 2.click the select all corner 3.Select format - column - optimal width Actual Results: SOme cell data is still hidden Expected Results: All cells wide enough to show all data Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Linux (All) OS is 64bit: yes
Thank you for the report, David. I tested copying the table from: https://en.wikipedia.org/wiki/Fediverse And pasting with default settings in Calc. Applying optimal width (with extra 0.2 cm) has no effect. The issue has to do with the "Wrap text automatically" option applied to the cells when the original formatting is kept, which is tracked in bug 145911. Marking as a duplicate. Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 88bd66d258de5fee3d35aba80c61fec49eb2a969 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded *** This bug has been marked as a duplicate of bug 145911 ***
I opened my spreadsheet and clicked: select all, format - text - wrap text, to see if that was preventing auto width, but I cannot turn wrap text off. I see it as checked, but when I click it, it does not turn off. Is this part of the same bug?
(In reply to David Pickett from comment #2) > I opened my spreadsheet and clicked: select all, format - text - wrap text, > to see if that was preventing auto width, but I cannot turn wrap text off. > I see it as checked, but when I click it, it does not turn off. Is this > part of the same bug? Good spotting, thank you. I've reported it in bug 155368, same source cause but not sure if it will be the same fix.
(In reply to Stéphane Guillou (stragu) from comment #3) > Good spotting, thank you. I've reported it in bug 155368, same source cause > but not sure if it will be the same fix. Sorry, not same root cause, getting my bugs confused :D Same root cause as bug 153527.