Apache OpenOffice (AOO) Bugzilla – Issue 75934
refresh of data pilot destroys formatting
Last modified: 2007-06-15 10:54:46 UTC
If you make a data pilot and you format the cells (with whatever formatting) within the data pilot section, each time you refresh the data pilot, the formatting is reset to the default and hence destroyed. This is very annoying and simply forbids formatting in the data pilot area. As a workaround, you can insert another spreadsheet and refer to the cells of the data pilot area, so your format is not being destroyed. But that makes you inflexible in case of changes in row or column numbers. I love Open Office and very much appreciate your dedication! Titus
titusopen, please provide sample spreadsheet with data pilot and original data.
Created attachment 44142 [details] Example for simple data pilot with formats that will be destroyed when you refresh
Hi, I can confirm the loss of formatting, using refresh from the context menu. I guess this is no defect, but a missing feature and most probably known. @fst: I assume this is an easy 'close as duplicate' for you. Best regards from Beijing Peter
Hi Peter and all others, this is a double to Issue 32303 and therefore closed now. @pj All the best to Beijing Frank *** This issue has been marked as a duplicate of 32303 ***
closed double