Description: F1 help for MENU>Data>Calculate>Formula to Value is missing Steps to Reproduce: 1.MENU>Data>Calculate>Formula to Value 2.F1 3. Actual Results: No help available Expected Results: Help available - particularly as it obliterates any formulae in "unselected" cells of the "Target" column when applied to an auto filter sorted "Marquee Selection" - that's Sorted NOT selected or deselected. The cells I don't want recalculated are still visible at the bottom of the list. Is that a separate bug report or a feature? Impossible to tell as the help file is missing Reproducible: Always User Profile Reset: No OpenGL enabled: Yes Additional Info: Version: 7.2.2.2 (x64) / LibreOffice Community Build ID: 02b2acce88a210515b4a5bb2e46cbfb63fe97d56 CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: sv-SE (en_GB); UI: en-GB Calc: threaded
(In reply to Colin from comment #0) > > Help available - particularly as it obliterates any formulae in "unselected" > cells of the "Target" column when applied to an auto filter sorted "Marquee > Selection" - that's Sorted NOT selected or deselected. > The cells I don't want recalculated are still visible at the bottom of the > list. > I can confirm the cells which were originally located in rows ABOVE the marquee selection but would have been "Sorted" to the bottom of the list, retained their formulae.
Further testing demonstrates that if the cells which had their formulae obliterated are then "selected" in the autofilter and the formula is re-pasted to all the cells presented therein, the formulae are correctly pasted only to the displayed cells.
Olivier Hallot committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/4ac52bffa0d4055a8c18d1a25d15a68eae00adee tdf#145898 Formula to Value and Recalculate Hard