Issue 81414 - Import Data from Base to Calc destroys formatting
Summary: Import Data from Base to Calc destroys formatting
Status: CLOSED DUPLICATE of issue 16794
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.2.1
Hardware: All Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Depends on:
Reported: 2007-09-09 17:24 UTC by dennis_mrowczynski
Modified: 2007-09-10 14:29 UTC (History)
1 user (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description dennis_mrowczynski 2007-09-09 17:24:13 UTC
I don't have the english version of Open Office, so I describe it with german
texts, perhaps someone can translate it to english:

Open Calc
Go to Ansicht, Datenquellen
Take an query or table and pull it into the table
Your data is there, fine. Now format the table (take some colors for some rows,
make the caption a bit bigger and so on).

Now, go to Daten, Bereich aktualisieren.

All your formatting is away, nothing's left of your work.

I think, Calc should only import data and should leave the formatting as it was
(Microsoft Excel 2002 does it in this way).

By the way: why isn't there a status message while Calc is importing some data?
When it's a little bit more (let's say 30000 cols with about 20 rows each) you
never know, how far Calc is.
Comment 1 frank 2007-09-10 14:29:13 UTC
double to Issue 16794

*** This issue has been marked as a duplicate of 16794 ***
Comment 2 frank 2007-09-10 14:29:41 UTC
closed double