Not working? Make sure you set Base to Decimal (Step 7). For my purposes, though, UTF-8 does a good enough job of displaying non-corrupted characters. Like Vasille says in the comment to this question, if your file is not actually in UTF-8 format, you may technically want to convert the characters within the file to the encoding you want before opening in Excel. For some other encoding, use the code page identifier, which you can find in the Text Import Wizard in Excel or in this list. For Value data, enter 65001 to set your default to UTF-8.Right-click on DefaultCPG and select Modify.Name the item DefaultCPG, and press Enter to save.Right-click an empty space on the right side and select New → DWORD.Navigate to HKEY_CURRENT_USER → Software → Microsoft → Office → ▒▒ → Excel → Options, where ▒▒ is your version of Office, mostly likely the largest number you see there.I found my answer at Changing default text import origin type in Excel. The fonts used by WPS Office are provided by the ttf-wps-fonts AUR package. The suite contains Writer, Presentation and Spreadsheets. I answered a similar question at Default character encoding for Excel Text Wizard?. WPS Office for Linux is a proprietary alternative for Microsoft Office with a modern UI which supports cross-device file transfer and cloud backup.
0 Comments
Leave a Reply. |