View Full Version : Excel problem
nodeh
11 May 2007, 05: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 ( é-è-ê,ë,ï ...), apostrophs, " ,and I didn't find the way the choose the codage as it is possible in File/Import-Export/Export TEXT ...
I'm also interested in French version ( where those letters are frequent ! )
Thanks to help me
Frank
11 May 2007, 06: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, 03: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, 08:37 AM
Sorry, I forgot one step...
Between steps 2 and 3, in TextEdit choose Format -> Make Plain Text.
nodeh
12 May 2007, 09:57 AM
Sorry, I forgot one step...
Between steps 2 and 3, in TextEdit choose Format -> Make Plain Text.
It's OK now, thanks !
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.