PDA

View Full Version : Excel problem


nodeh
11 May 2007, 06:43 PM
When I export a rapport from index search , using "Plain text file" as I did with REUNION 8 to open it in Excel I have now a problem with some caracters : all accents (

Frank
11 May 2007, 07:47 PM
You've encountered a transitional issue. Hopefully, someday, Excel will understand Unicode.

Reunion 9 reports saved to a destination of "Plain text file" are encoded with UTF-8 (Unicode).

Here's a workaround:

1. In Reunion's Application Preferences, choose TextEdit as the word processor.
2. Create reports with a destination of TextEdit. The report will open automatically in TextEdit.
3. In TextEdit, choose File -> Save As
4. At the bottom, choose "Western (Mac OS Roman)" from the Plain Text Encoding popup menu.
5. Import the resulting file into Excel.

nodeh
12 May 2007, 04:29 AM
In TextEdit, choose File -> Save As
At the bottom, choose "Western (Mac OS Roman)" from the Plain Text Encoding popup menu.
Import the resulting file into Excel.When I want to "Save As" I don't find this choice on my Mac :I have RTF - HTML - Word - or XML Word but not " Western (Mac OS Roman)" or do I make a mistake ?

Frank
12 May 2007, 09:37 AM
Sorry, I forgot one step...

Between steps 2 and 3, in TextEdit choose Format -> Make Plain Text.

nodeh
12 May 2007, 10:57 AM
Sorry, I forgot one step...

Between steps 2 and 3, in TextEdit choose Format -> Make Plain Text.

It's OK now, thanks !