Bug 160179 - [LOCALHELP] Add description for expert configuration "RecalcOptimalRowHeightMode" options
Summary: [LOCALHELP] Add description for expert configuration "RecalcOptimalRowHeightM...
Status: VERIFIED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
24.8.0.0 alpha0+
Hardware: All All
: medium normal
Assignee: Olivier Hallot
URL:
Whiteboard: target:24.8.0
Keywords:
Depends on:
Blocks: HelpGaps-NewFeatures Options-Dialog-Expert
  Show dependency treegraph
 
Reported: 2024-03-13 15:42 UTC by V Stuart Foote
Modified: 2024-05-03 16:08 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description V Stuart Foote 2024-03-13 15:42:16 UTC
As implemented [1] at 24.8 for bug 124098 the expert configuration "RecalcOptimalRowHeightMode" stanza takes a value of "0", "1", or "2"

Default value is "0" and row height of table cells in calc sheets are recalculated on document load (ODF and OOXML [2]). Value "1" by-passes recalculation of row height. Value "2" prompts for user input in a pop-up dialog.

Not available to set in the UI, and setting in expert configuration persists until reset, or to default with clear of user profile.

=-ref-=
[1] https://gerrit.libreoffice.org/c/core/+/163421
[2] https://gerrit.libreoffice.org/c/core/+/164721
Comment 1 Justin L 2024-03-13 16:00:41 UTC
(In reply to V Stuart Foote from comment #0)
> Not available to set in the UI
It is available in the UI.
   tools - options - Calc - Formula - OptimalRowHeight - Always Recalculate
Comment 2 V Stuart Foote 2024-03-13 16:10:33 UTC
Oops, I missed there was an optformula.ui entry, and that 'Optimal row height:' control is available in UI fro the Tools -> Options -> LO Calc -> Formula 'Recalculation on File Load' section. Plain as day...

But, still think it needs a description in Help. Both the UI and the Expert Config stanza.
Comment 3 Olivier Hallot 2024-03-13 17:22:16 UTC
Hi
Help can be updated, no problem.

My (side) comment is about help on expert configs.
First it will be a huge task, with consequences in translation.
Second, such configurations misuse are source for tons of headaches for support teams in organizations, with costly calls to the Help Desk.
Third, who never heard "I didn't do anything", "Yesterday it was working" or "it worked on MS Office", "that <expletive> LibreOffice"... from our beloved users.
Cheers.
Comment 4 Commit Notification 2024-04-08 16:44:59 UTC
Olivier Hallot committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/help/commit/8db831e3f0dce474924168d18e4f8d23fc29f731

tdf#160179 Recalculate row height at load times
Comment 5 V Stuart Foote 2024-05-03 16:08:51 UTC
Help entry for Calc Tools -> Options -> Calc -> Formula "Recalculation on File Load" for "Optimal Row Height" has it covered.

https://help.libreoffice.org/24.8/en-US/text/shared/optionen/01060900.html?System=WIN&DbPAR=CALC&HID=modules/scalc/ui/optformula/rowheightrecalc#bm_id21712590967776