Saving Calc document with a new character encoding

[MiB]

I need to make a text file from an Excel file that I receive every month. In more detail I need to be able to copy the edited contents to the clipboard to paste into a text document (in another app) that has cp437 encoding. Before the copying point I need to make sure the contents is encoded in cp437 already in OpenOffice Calc.

If there are characters that can't be represented in cp437 I need to have these converted.

How do I even set character encoding in Calc? And is there a conversion option in this or a separate process? If the latter isn't available is there a conversion tool in OS X you can suggest?

[acknak]

As far as I know, OO documents (ODF) always use Unicode encoding. You can select an encoding when you export a document to some other formats.

For example, you can export your document to CSV text, and choose a specific encoding for the exported text:
File > Save As ... File type: Text (CSV), Edit filter options: YES, and select the encoding as "Western Europe (DOS/OS2-437/US"

[MiB]

Thanks. I didn't know this.

At first I thought this wouldn't help me. Then I realized I could forego the copy & paste routine — which would have to happen with cp437 source — and instead save as csv, as you suggest, with tab delimiters and cp437 encoding and have this open automatically with a simple Hazel action on the folder I use. I think this might just work out.