Hi Magnus,

On Wed, Aug 17, 2005 at 14:26:14 +0200, Magnus Burman wrote:

> Ran into some problems when trying to save a CSV-file today. Had some 
> fields containing numbers that I formatted as Text, and then tried 
> saving as CSV. Wouldn't work.

Display formats currently aren't exported to CSV.

> Turns out that the cells have to be formatted as Text *before* I enter 
> the data into them, then it will correctly save wrapped in ".

The difference is that then the cell _content_ is text instead of
number. You can also achieve that by preceding the input with a single
quote ' like in '1, the single quote will not be part of the cell
content.

> Is this a bug or am I doing something wrong? Using version 1.9.177.

It's a known limitation, see also
http://qa.openoffice.org/issues/show_bug.cgi?id=4925

  Eike

-- 
 OOo/SO Calc core developer. Number formatter bedevilled I18N transpositionizer.
 GnuPG key 0x293C05FD:  997A 4C60 CE41 0149 0DB3  9E96 2F1A D073 293C 05FD

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to