Calc wrap text issue

Discuss the spreadsheet application

Calc wrap text issue

Postby ahmer.razzak » Thu Mar 25, 2010 7:00 am

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
User avatar
ahmer.razzak
 
Posts: 5
Joined: Thu Mar 25, 2010 6:53 am

Re: SCALC WRAP TEXT ISSUE

Postby vasa1 » Thu Mar 25, 2010 7:11 am

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 3.5.3.2 on Ubuntu 12.04
vasa1
 
Posts: 254
Joined: Sat Dec 26, 2009 1:20 pm
Location: Bombay

Re: Calc wrap text issue

Postby ahmer.razzak » Mon Mar 29, 2010 6:40 am

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
User avatar
ahmer.razzak
 
Posts: 5
Joined: Thu Mar 25, 2010 6:53 am

Re: Calc wrap text issue

Postby vasa1 » Mon Mar 29, 2010 7:28 am

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 3.5.3.2 on Ubuntu 12.04
vasa1
 
Posts: 254
Joined: Sat Dec 26, 2009 1:20 pm
Location: Bombay

Re: Calc wrap text issue

Postby ahmer.razzak » Mon Mar 29, 2010 7:56 am

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 26 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

Postby ahmer.razzak » Mon Mar 29, 2010 7:58 am

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
User avatar
ahmer.razzak
 
Posts: 5
Joined: Thu Mar 25, 2010 6:53 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 19 guests