Page 1 of 1

Calc wrap text issue

Posted: Thu Mar 25, 2010 7:00 am
by ahmer.razzak
Dears,

We are exporting some data from internet into SCALC.
After unselecting wrap text option we can view that data as per our requirement.
But after saving that file and then we open that file the data automatically change into wrap text .

Can some one help how to stop that wrap text automatically selection.

Thanks

Ahmer

Re: SCALC WRAP TEXT ISSUE

Posted: Thu Mar 25, 2010 7:11 am
by vasa1
Just a guess but if you change the settings in the default (by clicking on F11 for the style list) and save that modified default for that document, it may work.

Re: Calc wrap text issue

Posted: Mon Mar 29, 2010 6:40 am
by ahmer.razzak
Dear ,

Thanks for your reply, i tried but not worked i need to select default style every time when i open that file.

Ahmer

Re: Calc wrap text issue

Posted: Mon Mar 29, 2010 7:28 am
by vasa1
ahmer.razzak wrote:Dear ,

Thanks for your reply, i tried but not worked i need to select default style every time when i open that file.

Ahmer
So you have a file with wrapped text. Go to F11 and check the alignment of the default style. It should be automatic wrap off.

If that is so, select the entire sheet (Ctrl+A), then select the default style. Now all cells will be formatted that way.

Save and exit. Re-open. Do you still see wrapped text?

Re: Calc wrap text issue

Posted: Mon Mar 29, 2010 7:56 am
by ahmer.razzak
Dears,

No its not working when i open that file its in same format.
I have also attached this file for your references.
Thanks

Ahmer

Re: Calc wrap text issue

Posted: Mon Mar 29, 2010 7:58 am
by ahmer.razzak
Dears,

I have also explore that when we save that file in ods extension its working fine but problem occurs with .xls format

Thanks

Ahmer