[Solved] Columns vanish after Save

Discuss the spreadsheet application
Post Reply
hlherz88
Posts: 6
Joined: Sat Jul 24, 2021 8:54 pm

[Solved] Columns vanish after Save

Post by hlherz88 »

Would appreciate your help with this spreadsheet question. Modest-sized spreadsheet (120KB) into which I manually type data. No formulas or links. I use Time Machine to back up about once a week.
I enter some new columns and hit Save. A bunch of columns at the "end" (right) vanish. I did not hide them. I did not make the font color match the cell background color.
So, I open the two-day old version saved via Time Machine and it too is missing the columns.
I try closing and reopening the file and get this message:" Document locked for editing by: Unknown User (I'm the only user on this computer, fyi). Open document read-only or open a copy of the document for editing."
Both of those options display the spreadsheet with missing data.
So, I manually enter the data again, doing File: Save after adding EACH individual column. After about 20 columns of data entered, the same problem occurs.
Any suggestions would be greatly appreciated.

This is OpenOffice 4.1.5 on MacOS 10.15.7
Last edited by robleyd on Mon Jul 26, 2021 1:51 am, edited 1 time in total.
Reason: Tag [Solved]
OpenOffice 4.1.5 on MacOS 10.15.7
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Columns vanish after Save

Post by Villeroy »

Save your work in the native document format of the program you are using.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
hlherz88
Posts: 6
Joined: Sat Jul 24, 2021 8:54 pm

Re: Columns vanish after Save

Post by hlherz88 »

I saved as .ods, but no luck. The data isn't there.
OpenOffice 4.1.5 on MacOS 10.15.7
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Columns vanish after Save

Post by RoryOF »

How many columns have you in the spreadsheet?
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
hlherz88
Posts: 6
Joined: Sat Jul 24, 2021 8:54 pm

Re: Columns vanish after Save

Post by hlherz88 »

About 230. Not that big.
OpenOffice 4.1.5 on MacOS 10.15.7
User avatar
RusselB
Moderator
Posts: 6646
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Columns vanish after Save

Post by RusselB »

Please upload your spreadsheet so that we can examine the format. The data is irrelevant, and there are instructions in this tutorial on how to anonymize your spreadsheet before uploading it.
I have a small problem believing that a 230 column spreadsheet is only 120k in size.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
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.
hlherz88
Posts: 6
Joined: Sat Jul 24, 2021 8:54 pm

Re: Columns vanish after Save

Post by hlherz88 »

Sorry, I don't see any buttons in the UI that enable me to attach a file.
Would you please tell me how I can have an attachment with my reply?
Thanks.
OpenOffice 4.1.5 on MacOS 10.15.7
User avatar
robleyd
Moderator
Posts: 5056
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Columns vanish after Save

Post by robleyd »

See How to attach a document for details regarding attaching a document. Screenshots of the process are also in the linked topic.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
hlherz88
Posts: 6
Joined: Sat Jul 24, 2021 8:54 pm

Re: Columns vanish after Save

Post by hlherz88 »

Here's the file you requested.
Last edited by hlherz88 on Sun Jul 25, 2021 11:31 pm, edited 1 time in total.
OpenOffice 4.1.5 on MacOS 10.15.7
FJCC
Moderator
Posts: 9248
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Columns vanish after Save

Post by FJCC »

The xls format is limited to 256 columns, I think. Your data end at column IV, which is the 256th column.
Use the ods format to use more columns.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
hlherz88
Posts: 6
Joined: Sat Jul 24, 2021 8:54 pm

Re: Columns vanish after Save

Post by hlherz88 »

Brilliant. Thank you!
OpenOffice 4.1.5 on MacOS 10.15.7
Post Reply