Summary: | Filling hidden cells fails | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Colin <that.man.colin> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | RESOLVED DUPLICATE | ||
Severity: | minor | CC: | ilmari.lauhakangas, jluth |
Priority: | medium | Keywords: | bibisected, regression |
Version: | 3.6.0.4 release | ||
Hardware: | All | ||
OS: | All | ||
See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=113785 | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 113499 |
Description
Colin
2020-10-26 16:16:17 UTC
In the 2nd test I inadvertently advised to select the entire matrix starting at C3:G3 to create the new matrix to C15:G15. Of couse it's only necessary to select the last complete line of the original matric C7:G7. Eating Umble Pie. Reproduced NixOS Version: 7.3.0.0.alpha0+ / LibreOffice Community Build ID: 67e47070a7580a17804adce812cc2f98bfe7b51f CPU threads: 16; OS: Linux 5.13; UI render: default; VCL: x11 Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Bibisected with Linux 43all repo to range ee7084c4f720c932df67c8ff033dab4d8d556179..250feedd8e50e5eb52682a194823567ba5287c60 Out of which these seem relevant: commit 73ff3a49a0891c7787f08eec86357c320a76c263 Author: Markus Mohrhard <markus.mohrhard@googlemail.com> Date: Wed Apr 11 22:02:06 2012 +0200 first part for ScTable::GetAutoFillPreview Actually this is a bit more tricky. Currently it is showing wrong values for hidden rows/columns commit 290a851bdc42a78426dea987ffbcb511e36c34fb Author: Markus Mohrhard <markus.mohrhard@googlemail.com> Date: Wed Apr 11 21:53:30 2012 +0200 ScTable::FillAuto should work with hidden rows/columsn now too commit a6a0ea2f352f98b801bb6aade04caeb07e180403 Author: Markus Mohrhard <markus.mohrhard@googlemail.com> Date: Wed Apr 11 21:44:09 2012 +0200 add unit test for autofill commit f61cbce529d039bb0e208e81cf66974cc4428420 Author: Markus Mohrhard <markus.mohrhard@googlemail.com> Date: Wed Apr 11 21:35:59 2012 +0200 make ScTable::FillSeries work correctly with hidden rows/columns There was one intermediate state, where the cells were filled, but not incremented (I marked it as 'good'). I would consider autofill affecting hidden rows as a bug it if were to happen. It very intentionally does not work that way. See bug 113785. bug 56799 is discussing autofill - seems to be identical to this discussion. Note the last comment 21 - NOTABUG. *** This bug has been marked as a duplicate of bug 56799 *** (In reply to Justin L from comment #4) > I would consider autofill affecting hidden rows as a bug it if were to > happen. It very intentionally does not work that way. See bug 113785. Are you implying you'd sooner rewrite the help facility than fix the bug? At the very least, a well-defined procedure would probably give the user the ability to select a preferred approach. Just like when the user is asked if they would prefer cell references to be expanded and adjusted when cells/rows are inserted or autofilters re-sort the cells according to value..............and many more examples which any user could identify. Reductio ad absurdum. I imagine there is some mechanism with LO that detects "drag Filling" and presumably that mechanism could be improved to incorporate "would you like the hidden cells updated?" |