I don't know if this a Writer issue or a Calc issue.
I have a whole column in OO Writer that is formatted as TEXT.
I have a whole column in OO Calc that is formatted as TEXT.
When I copy the column from Writer to Calc, the format somehow gets changed to NUMBER-GENERAL in Calc. I want the data to stay as TEXT.
The TEXT data I have looks like this in OO Writer:
89.3.20
07.4.19
NONE
89.3.34
90.30.202
After copying to Calc the data is changing to:
03/20/89
07/04/19
NONE
90.30.202
The values represent item numbers for cataloging purposes in a Museum.
Paste from Writer to Calc - format changes
-
David12846
- Posts: 65
- Joined: Fri Jan 09, 2009 6:46 am
Paste from Writer to Calc - format changes
OOo 4.1.9 on Ms Windows 7
Re: Paste from Writer to Calc - format changes
Use Paste Special (Shift+Ctrl+V) and select Unformatted text. In the Text Import window, select the column containing your data and select Text as the Column type. Then the data will remain unaltered.
AOO 4.1.16 & LO 25.8.3 on Windows 10