https://bugs.documentfoundation.org/show_bug.cgi?id=124098
--- Comment #55 from V Stuart Foote <[email protected]> --- (In reply to pharmankur from comment #54) > (In reply to V Stuart Foote from comment #53) > > Can you elaborate more on how to do this ? > Also how to make it permanent and for all files ? Two ways. And this is for existing ODF spreadsheets. But work on a copy (just to be safe). One if you have the file open in Calc, see comment 6. The other is if you don't want the delay. Simply open archive with Z-zip, notice the content.xml that is the meat of the document. Select and use 7-zip's Edit (configure 7-zip to use vi, or gvim for editing in advance). Find the string "optimal" (in vi, gvim issue the ex / to find). Cursor to the "true" and replace with "false". Write and quit the edit. 7-zip will detect the change and ask if you want to merge back into the archive. As to making it permanent, not certain but Tools -> Options -> Advanced -> Open Expert Configuration and search for "optimal". Adjust the org.openoffice.Office.UI.CalcCommands stanza: org.openoffice.Office.UI.Commands:LabelType['uno:SetOptimalRowHeight'] Properties long "1" --> "0" That should keep future sheets from including the optimal set optimal row height style. -- You are receiving this mail because: You are the assignee for the bug.
