Welcome to the most active Linux Forum on the web.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 08-20-2018, 02:02 PM   #1
LQ Newbie
Registered: Feb 2012
Posts: 3

Rep: Reputation: Disabled
Using Libreoffice Calc - Every time I restart the program the columns has changed size

I use libreoffice to maintain a spreadsheet that has 18 sheets of data and tables. I had not unpdated the work for sometime but when i did last week, things went South. After wasting countless hours and wasting reams of paper and ink I realized the problem was the program would on its own resize the columns every time I would restart the program. Then the data no longer fit the margins and it would print two pages per sheet.

I would redo all the sheets saving after every sheet had been corrected but the sizes were not saved.
Old 08-21-2018, 07:41 AM   #2
Registered: Mar 2011
Location: MA, USA
Distribution: MINT Debian, Angstrom, SUSE, Ubuntu, Debian
Posts: 8,052
Blog Entries: 13

Rep: Reputation: 3500Reputation: 3500Reputation: 3500Reputation: 3500Reputation: 3500Reputation: 3500Reputation: 3500Reputation: 3500Reputation: 3500Reputation: 3500Reputation: 3500
I don't experience this phenomena, although I could say that any sheets I have are not very large, nor complex.

I'm afraid I don't recognize any question here though. What is your intent? Sharing? Or looking to see if anyone else has seen this behavior?

If it were me, I would try to characterize the problem with a new sheet, and by it up in size and complexity until I could reproduce it regularly. Then I'd consider checking for, and reporting a bug.

It might be worth trying the latest version.
Old 08-21-2018, 11:30 PM   #3
LQ Newbie
Registered: Feb 2012
Posts: 3

Original Poster
Rep: Reputation: Disabled
I would like to know if I am the only one that has this problem. I received an updated version of Libreoffice just recently. The problem I would like to get help for is why the program keeps increasing the size of the column every time I open the program. In this spreadsheet all the columns were increased in width. So when you have 18 sheets it means doing hours of corrections. I have been using libreoffice for at least 6 years after having used excel for many years.

I saved the file to an usb stick and plugged it in a Raspberry Pi3 and opened and closed the file with Libreoffice calc about 8 times and the width always stayed the same. On my desktop I use Linux ubuntu 16.04.
Old 08-22-2018, 01:07 AM   #4
LQ Guru
Registered: Jan 2005
Location: USA and Italy
Distribution: Debian testing/sid; OpenSuSE; Fedora; Mint
Posts: 5,513

Rep: Reputation: 1004Reputation: 1004Reputation: 1004Reputation: 1004Reputation: 1004Reputation: 1004Reputation: 1004Reputation: 1004
I always go here:
1 members found this post helpful.
Old 08-22-2018, 06:53 PM   #5
LQ Newbie
Registered: Feb 2012
Posts: 3

Original Poster
Rep: Reputation: Disabled
Excel works just fine for me.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
libreoffice calc - dynamic sheet name sharky Linux - Software 2 06-22-2015 10:49 AM
Absolute value of a column in Libreoffice calc Adwat Linux - Software 4 03-10-2015 05:35 AM
[SOLVED] Formula Locking In LibreOffice Calc cin_ Linux - Software 2 11-19-2012 05:12 AM
[SOLVED] libreoffice calc qrange Linux - Software 2 09-13-2012 01:19 AM
Colorizing rows/columns in Open Office Calc hedron Linux - Software 3 06-09-2010 10:51 PM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 11:17 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration