[Solved] Rows randomly narrow after each re-opening of file

Discuss the spreadsheet application

[Solved] Rows randomly narrow after each re-opening of file

Postby famgarnett » Tue May 05, 2020 9:25 pm

SOLVED Every time I re-open any spreadsheet I find random rows all scrunched up and have to readjust them. Drives me crazy. How does this stop?
Last edited by famgarnett on Thu May 07, 2020 7:42 pm, edited 1 time in total.
OpenOffice 4.1.5 on Windows 10
famgarnett
 
Posts: 2
Joined: Tue May 05, 2020 9:18 pm

Re: Rows randomly narrow after each re-opening of file

Postby RusselB » Wed May 06, 2020 4:30 am

Welcome to the Forums.
This is the first that I can recall of hearing this problem, and I haven't encountered it, so in order to do some investigative work I (aka the helpers on this forum) will need you to upload/attach a sample spreadsheet that this is happening with.
Please see How to attach a document for more help regarding uploading/attaching a document and/or making that document anonymous.
OpenOffice 4.1.7 and LibreOffice 6.3.3.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 6110
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Rows randomly narrow after each re-opening of file

Postby Zizi64 » Wed May 06, 2020 5:56 am

famgarnett wrote:Every time I re-open any spreadsheet I find random rows all scrunched up and have to readjust them. Drives me crazy. How does this stop?


What file type are you using? Always use the native, international standard ODF file types.

And please upload an ODF type sample file here.
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 9542
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Rows randomly narrow after each re-opening of file

Postby famgarnett » Wed May 06, 2020 6:12 pm

OK, it's when I've been using the spreadsheet as .xls not .ods. Still annoying that I'll have to go through all the spreadsheets and rename them all. Why is the conversion to and from xls like this?
OpenOffice 4.1.5 on Windows 10
famgarnett
 
Posts: 2
Joined: Tue May 05, 2020 9:18 pm

Re: Rows randomly narrow after each re-opening of file

Postby jrkrideau » Wed May 06, 2020 6:24 pm

famgarnett wrote: I'll have to go through all the spreadsheets and rename them all.


No, renaming them will not help!

You need to open each .xls file and do a Save As and pick .ods as the format.

Why is the conversion to and from xls like this?

Who knows? The .xls code was proprietary and secret when the translators were developed so everything was reverse-engineered. Also it may be something peculiar to your installation's set up or both.

Each time you open or save a file in .xls format it is translated and tiny translation errors can build up to a sudden problem. That is one reason experienced users recommend always working in .ods and only saving to another format when it is absolutely needed
LibreOffice 6.4.3.2; Ubuntu 20.04
jrkrideau
Volunteer
 
Posts: 3788
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

Re: Rows randomly narrow after each re-opening of file

Postby JohnSUN-Pensioner » Wed May 06, 2020 8:26 pm

famgarnett wrote:...I'll have to go through all the spreadsheets and rename them all

The office will easily do this for you (but minor errors can still be)

Converter.png
I may not have a lot to give but what I got I'll give to you...
Apache OpenOffice 4.1.5, LibreOffice 6.4.4.2 (x64) on Windows 7
If you think that I did not answer your question, make allowances for my imperfect English
User avatar
JohnSUN-Pensioner
Volunteer
 
Posts: 824
Joined: Fri Jan 14, 2011 1:21 pm
Location: Kyiv, Ukraine


Return to Calc

Who is online

Users browsing this forum: No registered users and 17 guests