Summary: | Missing help for CALC "Formula to Value" makes it difficult to identify if its a BUG in the function I needed help to clarify or just missing help | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Colin <that.man.colin> |
Component: | Calc | Assignee: | Olivier Hallot <olivier.hallot> |
Status: | RESOLVED FIXED | ||
Severity: | normal | CC: | xiscofauli |
Priority: | medium | ||
Version: | 7.2.2.2 release | ||
Hardware: | All | ||
OS: | Windows (All) | ||
Whiteboard: | target:7.4.0 | ||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 80430 |
Description
Colin
2021-11-26 09:18:05 UTC
(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 |