Hi Tony, On Thu, Mar 10, 2005 at 19:13:21 -0000, Tony Pursell wrote:
> In the 2.0 Beta (1.9.79) I cannot open a .csv in anything other than > Writer. The file was created in the Mail Merge Wizard as a tab > delimited file. I open it with the File Open icon, I get the file open > dialog, I select files of type Spreadsheet (or Text (.txt, .csv)), "Spreadsheet" won't do. IMHO this is a bit misleading in the dialog, as the Spreadsheet selection will only list files of known spreadsheet extensions, but does not select any filter. But "Text CSV" should. > It gives > me the ASCII Filter Options Dialog showing it is in Unicode, I click OK > and it opens in Writer. No way can I get it to open in Calc. This sounds like the file contains 0x00 hex null bytes, but does not start with a Unicode byte order mark (BOM) U+FEFF. As Calc can't import null bytes while reading an 8bit character encoded stream it refuses to open the file. If the Mail Merge Wizard really writes Unicode files it should prepend them with a BOM. 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]
