Calc wrap text issue

Discuss the spreadsheet application
Post Reply
User avatar
ahmer.razzak
Posts: 5
Joined: Thu Mar 25, 2010 6:53 am

Calc wrap text issue

Post 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
vasa1
Volunteer
Posts: 261
Joined: Sat Dec 26, 2009 1:20 pm
Location: Bombay

Re: SCALC WRAP TEXT ISSUE

Post 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.
LibreOffice 5.2.1.2 on Lubuntu 16.04 (Openbox)
User avatar
ahmer.razzak
Posts: 5
Joined: Thu Mar 25, 2010 6:53 am

Re: Calc wrap text issue

Post 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
Windows XP SP3 with OPenoffice 3.2.0
vasa1
Volunteer
Posts: 261
Joined: Sat Dec 26, 2009 1:20 pm
Location: Bombay

Re: Calc wrap text issue

Post 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?
LibreOffice 5.2.1.2 on Lubuntu 16.04 (Openbox)
User avatar
ahmer.razzak
Posts: 5
Joined: Thu Mar 25, 2010 6:53 am

Re: Calc wrap text issue

Post 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
Attachments
Wrap Text Problem.xls
(7.5 KiB) Downloaded 116 times
Windows XP SP3 with OPenoffice 3.2.0
User avatar
ahmer.razzak
Posts: 5
Joined: Thu Mar 25, 2010 6:53 am

Re: Calc wrap text issue

Post 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
Windows XP SP3 with OPenoffice 3.2.0
Post Reply