[Libreoffice-bugs] [Bug 113687] Wrong cell attributes assumed

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=113687

--- Comment #2 from Elmar <roberg at iafrica.com> ---
Try the following: type something into cells in row3
type something into cells in row4
Now change the attributes of the cells in row3

Copy the cells to new rows (e.g. to rows7 and 8)

Now, select a cell in row 3
Add a row below row3 using the toolbar button.
Type text into the cells in the inserted row. 
The cells have inherited attributes from the row above it.

Now select a cell in row9 (remember that rows 7,8 moved down one because of the
insert row done above.
Now add a row above row9
The cells inherit attributes from row8, not from row10

Does that make sense?

Why is this a problem? If I have total row at the top, I would change the
background, borders or font to show it is a total line.
Then type my detailed list below that.

Now, if I want to add a detail row to the top of the list (i.e. insert a row
between the total row and the first detail line) it will always inherit the
attributes of the total line.

Note:when I create a sum range, then it acts as I suggest. 
e.g. cell c13 has sum(c14:c20)
If I select C13 and add row below, it adds the row and C14 inherits the
attributes from C13. The formula remains as SUM(C14:C20)

If I undo all of this, then select C14 and add a row above it, the attributes
are inherited from C13, but the formula in C13 has changed to SUM(C14:C21),
which is good.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171115/f24daab7/attachment.html>