Issue 21328 - Flatten excel file
Summary: Flatten excel file
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: bettina.haberer
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-10-16 15:58 UTC by dubiel
Modified: 2013-08-07 15:15 UTC (History)
1 user (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description dubiel 2003-10-16 15:58:43 UTC 
If I make an offer for my customer I do some calculations. 
For example I take price and add 20% to it. Then I send
this document to my customer, but I don't want him to 
know I have increased price for him by 20%. So I copy 
all cells, open new spreadsheet and choose PasteSpecial. 
Then take "Strings", "numbers", "DAte and time", "Formats". 
Now I have only final prices, and my customer can't read
formulas. 

I would like you to add option that makes this work 
by one command -- for example Edit->Flatten, which 
will remove all computation from cells and leave formats, 
and contents intact. 

It would be nice to have File->Send->Document_as_XLS_attatchment
where I would choose "Flatten". Now I wouldn't have 
to do so much everyday work....
Comment 1 frank 2003-10-16 16:28:34 UTC 
Hi Bettina,

1 4 u.

Frank
Comment 2 bettina.haberer 2004-01-30 16:40:20 UTC 
Hello dubiel, you can do that by exporting the offer as PDF file.
Comment 3 bettina.haberer 2004-01-30 16:40:36 UTC 
Closed.