Issue 126384 - Edit->Fill is not only using cell content (e.g., numbers) but also the cell formatting (e.g., color)
Summary: Edit->Fill is not only using cell content (e.g., numbers) but also the cell f...
Status: REOPENED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 4.1.1
Hardware: All All
: P5 (lowest) Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-06-26 18:06 UTC by jteera5
Modified: 2015-06-30 08:15 UTC (History)
0 users

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description jteera5 2015-06-26 18:06:51 UTC
Edit -> Fill not only fills the numbers in cells but also copies starting cell's color to other filled cells.
Comment 1 mroe 2015-06-26 20:27:28 UTC
This is the normal behaviour. Why do you expect anything other?
Comment 2 Marcus 2015-06-26 20:41:14 UTC
The respective help topics speaks often about numbers but sometimes also of cells. So, IMHO it's not clear that complete cells - incl. formatting - will be used for filling.

However, I don't see this as a real bug but more as an enhancement - e.g., to make it optional to use more than the cell content. Herefore I'm reopening this issue.
Comment 3 jteera5 2015-06-29 17:19:29 UTC
Fill should only fill numbers. You can use Copy to copy formats. I had a column that I remarked cells with colors. When I filled that column, all colors were gone. Help only mentions options for filling numbers.
Comment 4 mroe 2015-06-30 08:15:23 UTC
(In reply to jteera5 from comment #3)
> Fill should only fill numbers. You can use Copy to copy formats. I had a
> column that I remarked cells with colors. When I filled that column, all
> colors were gone. Help only mentions options for filling numbers.

This is your special case. I think most users want the actual behaviour because in the majority of cases equal content should have equal/same formatting especially for filling with Sort Lists.

For your special case there are different solutions. Only 2 as example:
1. copy the cells before filling the row and after that insert only the formats.
2. Use a separate column for marking the row and create a Conditional Formatting which dye the cells in the marked row.

Maybe the help could be more clear for this feature.
But this enhancement wish should also provide how this feature could be extended without changing the default/actual behaviour. Maybe this could be solved better as an installable extension.