Issue 75934

Summary: refresh of data pilot destroys formatting
Product: Calc Reporter: titusopen <matthias.stein>
Component: formattingAssignee: frank
Status: CLOSED DUPLICATE QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P2 CC: issues, kpalagin, peter.junge
Version: OOo 2.2   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Example for simple data pilot with formats that will be destroyed when you refresh none

Description titusopen 2007-03-30 21:01:56 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
Comment 1 kpalagin 2007-04-01 19:51:14 UTC 
titusopen,
please provide sample spreadsheet with data pilot and original data.
Comment 2 titusopen 2007-04-01 21:44:47 UTC 
Created attachment 44142 [details]
Example for simple data pilot with formats that will be destroyed when you refresh
Comment 3 peter.junge 2007-06-15 06:43:25 UTC 
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
Comment 4 frank 2007-06-15 10:54:05 UTC 
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 ***
Comment 5 frank 2007-06-15 10:54:46 UTC 
closed double