<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Calc refresh of pivot table overwrites formatting and no undo" href="https://bugs.documentfoundation.org/show_bug.cgi?id=126557#c6">Comment # 6</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Calc refresh of pivot table overwrites formatting and no undo" href="https://bugs.documentfoundation.org/show_bug.cgi?id=126557">bug 126557</a> from <a class="email" href="mailto:phil4000n@gmail.com" title="Phil <phil4000n@gmail.com>"> Phil</a> <pre>If you say it is not a bug, then I say the function is can not be called "refresh". It's merely as calling a new constructor pivot table function with A. parameters being the formely selected source area B. dumping into the already target area sheet C. and overwriting any styling in the target. This is not the behaviour, as I mentionned in MS-Office, where a refresh is bound to a data update. >inherited from source cells. If you inherit from source cells, that you ought to inherit it's type, that's why for instance in my example I put one line as Header1 style, which is LO63rc2 does not do. Regarding inheritance of the source cells styling: 1/ ought to be an OPTION (for instance a thicker box), as it is not the default and expected behaviour when aggregating data. 2/ "refresh" behaviour ought to be consistent with other functions such as data filtering, sorting, etc. >Maybe the no undo can be a bug There is no undo, presumably because current coding flushes everything and so no undo is kept in the pile. Whether inheriting the source cells or keeping the existing styling, the currently implemented "refresh" functions seems either to lack in its calling arguments the styling and/or in its body it wipes out all styling.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>