Issue 75934 - refresh of data pilot destroys formatting
Summary: refresh of data pilot destroys formatting
Status: CLOSED DUPLICATE of issue 32303
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.2
Hardware: All All
: P2 Trivial (vote)
Target Milestone: ---
Assignee: frank
QA Contact: issues@sc
Depends on:
Reported: 2007-03-30 21:01 UTC by titusopen
Modified: 2007-06-15 10:54 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Example for simple data pilot with formats that will be destroyed when you refresh (8.47 KB, text/plain)
2007-04-01 21:44 UTC, titusopen
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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!
Comment 1 kpalagin 2007-04-01 19:51:14 UTC
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

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
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.

All the best to Beijing


*** This issue has been marked as a duplicate of 32303 ***
Comment 5 frank 2007-06-15 10:54:46 UTC
closed double