Issue 18336 - Paste special (formulas off) => malformatted values (OO 1.1 RC2, RH 9.0)
Summary: Paste special (formulas off) => malformatted values (OO 1.1 RC2, RH 9.0)
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1 RC2
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-08-18 08:43 UTC by janove
Modified: 2003-09-08 16:55 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
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 janove 2003-08-18 08:43:12 UTC 
I have a spreadsheet containing columns and I wish to convert the formulas to values in another 
(new) spreadsheet. 
 
Workflow 
1) Create new speradsheet 
2) Select columns in source spreadsheet 
3) New spreadsheet>  Edit > Paste Special > (under selection: toggle off formulas) > Ok 
4) QC 
 
Some of my time formatted columns are converted to decimal numbers, which is not wat I 
wanted.   The input formula was :"=Q2+0.000150462962962963" and displayed as "12:56:40", 
but after pasting it into the new spreadsheet it read: "0.54" 
 
It is a bit difficult to convert the decimal number to correct time, and as far as I can see, the 
workaround is to export the original file to an ascii file an edit it using sed/awk....
Comment 1 frank 2003-08-19 10:09:55 UTC 
Hi,

this is not a bug but an support request. For such questions please
use the mailing list as this system is just for reporting bugs.

It seems that you have switched off the format function in the Paste
Special dialog as well.

Frank
Comment 2 frank 2003-08-19 10:10:15 UTC 
closed worksforme