Cell Sizes Change When Opening ODS File on Another PC

Discuss the spreadsheet application

Cell Sizes Change When Opening ODS File on Another PC

Postby typicallytiffany » Sat Jul 20, 2019 6:54 am

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
typicallytiffany
 
Posts: 2
Joined: Sat Jul 20, 2019 6:28 am

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

Postby robleyd » Sat Jul 20, 2019 2:27 pm

Perhaps the two computers have different settings? Check View | Zoom settings on both machines. Or perhaps the column width settings are different.
Cheers
David
Apache OpenOffice Developer Build 4.2.0 9820 - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2864
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

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

Postby RoryOF » Sat Jul 20, 2019 2:34 pm

Look at the % figure in the bottom right of the OO windows. If these differ, the zoom levels differ.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29257
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

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

Postby typicallytiffany » Sun Jul 21, 2019 6:16 pm

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
typicallytiffany
 
Posts: 2
Joined: Sat Jul 20, 2019 6:28 am

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

Postby RoryOF » Sun Jul 21, 2019 6:31 pm

If the two computers have different sized screens and or different resolutions, then the cell sizes will be different.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29257
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

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

Postby Zizi64 » Sun Jul 21, 2019 8:58 pm

Please upload a small .ods sample file and two screenshot images here.
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
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: 8137
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary


Return to Calc

Who is online

Users browsing this forum: No registered users and 13 guests