<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Wrong cell attributes assumed" href="https://bugs.documentfoundation.org/show_bug.cgi?id=113687#c2">Comment # 2</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Wrong cell attributes assumed" href="https://bugs.documentfoundation.org/show_bug.cgi?id=113687">bug 113687</a> from <a class="email" href="mailto:roberg@iafrica.com" title="Elmar <roberg@iafrica.com>"> Elmar</a> <pre>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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>