Exporting as CSV loses upper case text format

Question

Exporting as CSV loses upper case text format

Hi Folks,

When I format a column of text to upper case and export the sheet as .csv, It reverts to whatever random format it had before. The column is for states in a list of addresses.

I also wish I could format text in lower case if needed.

Any ideas?

iMac intel 20", Mac OS X (10.4.8), Imac G5, iBook G4, eMac

Posted on Apr 29, 2008 7:58 AM

Reply

Answer 1

KOENIG Yvan

Level 8

41,819 points

Apr 29, 2008 9:13 AM in response to Terry Collins

In iWork's components, applying a style "uppercase" or "lowercase" doesn't change the case of the data. It just display it as asked.
So, when we export in a text only format, we lose the style and grab the data as it was typed.

I understand that the developper feel safe to keep the original data intact but here it may appear as an annoying feature.

This is why I already asked them for added feature alloying us to really change the case as we wish.

Of course, I don't know if they will insert these features.

Yvan KOENIG (from FRANCE mardi 29 avril 2008 18:12:53)

Reply