Cell Sizes Change When Opening ODS File on Another PC

Discuss the spreadsheet application
Post Reply
typicallytiffany
Posts: 2
Joined: Sat Jul 20, 2019 6:28 am

Cell Sizes Change When Opening ODS File on Another PC

Post by typicallytiffany »

Hello!

I tried to search the forum for this problem, but didn't find this question asked. I am taking an ODS file that I created from a PC using Windows 7, and transferring it to a PC using Windows 10. Both are running the same version of OpenOffice (4.1.16). However, when I open the spreadsheet on the Windows 10 computer, all the cells are smooshed together, and cutting off the text. Does anyone know why? I've tried transferring these files via email/then downloading and also through thumb drive.

Anyone have an issue with this? I have a feeling it's a simple thing I'm missing.

Thanks!

Tiffany
Open Office 4.1.6
OS:Windows 10
User avatar
robleyd
Moderator
Posts: 5082
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Cell Sizes Change When Opening ODS File on Another PC

Post by robleyd »

Perhaps the two computers have different settings? Check View | Zoom settings on both machines. Or perhaps the column width settings are different.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
User avatar
RoryOF
Moderator
Posts: 34612
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Cell Sizes Change When Opening ODS File on Another PC

Post by RoryOF »

Look at the % figure in the bottom right of the OO windows. If these differ, the zoom levels differ.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
typicallytiffany
Posts: 2
Joined: Sat Jul 20, 2019 6:28 am

Re: Cell Sizes Change When Opening ODS File on Another PC

Post by typicallytiffany »

Hey guys, thanks for your responses! I checked the zoom level, and it is set at 100% on both computers. If the column widths have changed, is there any way to make the configurations stick when you transfer the file, and open it up somewhere else?


Thanks!
Open Office 4.1.6
OS:Windows 10
User avatar
RoryOF
Moderator
Posts: 34612
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Cell Sizes Change When Opening ODS File on Another PC

Post by RoryOF »

If the two computers have different sized screens and or different resolutions, then the cell sizes will be different.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
User avatar
Zizi64
Volunteer
Posts: 11359
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Cell Sizes Change When Opening ODS File on Another PC

Post by Zizi64 »

Please upload a small .ods sample file and two screenshot images here.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
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.
Post Reply