Summary: | FEATURE REQUEST: Powerful fill instrument | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Yan Pas <yanp.bugz> |
Component: | Calc | Assignee: | Yan Pas <yanp.bugz> |
Status: | RESOLVED WORKSFORME | ||
Severity: | enhancement | CC: | sophi, yanp.bugz |
Priority: | medium | ||
Version: | 4.4.2.2 release | ||
Hardware: | Other | ||
OS: | All | ||
See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=90394 | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Attachments: | Screeenshot |
Description
Yan Pas
2015-04-01 13:23:25 UTC
Now it's behavior is unpredictable, so I have even created a bug https://bugs.documentfoundation.org/show_bug.cgi?id=90394 (In reply to Yan Pashkovsky from comment #0) > Fill instrument (Draggable plus in the lower right corner of every cell) > should have 5 options: > 1. Copy format formatting is done via style, set your style and you can copy it any time you want to any cell you want > 2. Copy value (default for cells with text foramt) already implemented, just hold Ctrl at the same time you drag > 3. Copy format and value already there > 4. Copy incremental value (If you drag 1 - you will get in the next cells > values 2,3,4... with the defined format of every cell) already there > 5. Copy format and incremental value already there > > I guess that this 5 options should be in dropdown list if ypu click on right > lower corner of the cell. Excel already has only 4 options, so LO may beat > Excel if it will be implemented :) Everything is already there, you even have more under Edit > Fill which let you chose what to fill with once you have selected a range. Closing - Sophie Created attachment 114526 [details]
Screeenshot
2 - agree, didn't know. Maybe popup "Hold CTRL to..." should be implemented
1,3,5 - may be done via other different tools
But I can't understand where the 5 is implemented. Look at the screenshot.
I want after dragging plus from the A1 cell all cells below become:
1-entry (FORMAT:violet as it was)
2-entry (FORMAT:violet as it was)
3-entry (FORMAT:red as it was)
4-entry (FORMAT:green as it was)
5-entry
6-entry
Cells A2-A5 has their own style, they were not formatted manually
"But I can't understand where the 4"* TYPO 1-entry (FORMAT:big font, white background) 2-entry (FORMAT:violet as it was) 3-entry (FORMAT:violet as it was) 4-entry (FORMAT:red as it was) 5-entry (FORMAT:green as it was) 6-entry .... I guess this request economies two clicks. Closing cause there are easy workarounds |