.ods spreadsheet gets bold on network sharing

Discuss the spreadsheet application

.ods spreadsheet gets bold on network sharing

Postby RW9275 » Sun Jan 13, 2019 1:10 am

I am trying to share an OpenOffice spreadsheet on the network. The lines and fonts are much bolder than on my PC. I have tried adjusting the lines and fonts on the shared laptop, but can't get it right. My Excel spreadsheets share correctly. Any idea how this can be corrected?
OpenOffice 4.1.5
Windows 10 Home 64Bit
RW9275
 
Posts: 10
Joined: Fri Jan 11, 2019 4:55 am

Re: .ods spreadsheet gets bold on network sharing

Postby John_Ha » Sun Jan 13, 2019 1:49 am

If the screen resolutions are different, thin lines may display different thicknesses due to different pixel sizes.

The text difference sounds like a missing fonts problem. This is written for Writer but applies to Calc.

Remember that the font showing in the Writer font drop-down selection box is the font the document is asking for. This may NOT be the font being used to create the display because, if the font being asked for is not installed on the PC, Windows (or other operating system) will silently substitute a different font which is available.

Please upload a small file showing the problem so that it can be analysed. Use the Upload attachment tab below where you type (128 kB max); or use a file share site, Dropbox or Google Drive for a larger file.
AOO 4.1.6, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 6336
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: .ods spreadsheet gets bold on network sharing

Postby RW9275 » Sun Jan 13, 2019 2:28 am

Thanks for the reply. The fonts being used are Arial, which are installed on both units. The Excel spreadsheet displays fine. Both spreadsheets use the Arial font. I don't have access to the shared unit at this time. If you still need screenshots, I will get them posted.
OpenOffice 4.1.5
Windows 10 Home 64Bit
RW9275
 
Posts: 10
Joined: Fri Jan 11, 2019 4:55 am

Re: .ods spreadsheet gets bold on network sharing

Postby Zizi64 » Sun Jan 13, 2019 12:19 pm

If you still need screenshots, I will get them posted.

Screen shots and other pictures are less informative, than the spreasheet files. We can not examine the used styles and many other properties based on a picture.
Tibor Kovacs, Hungary; LO4.4.7, LO6.1.5 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.0 and AOO4.1.5
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: 7700
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: .ods spreadsheet gets bold on network sharing

Postby RW9275 » Sun Jan 13, 2019 5:44 pm

Thanks Zizi, but I'm not comfortable with sending files. I will try to figure this out.
OpenOffice 4.1.5
Windows 10 Home 64Bit
RW9275
 
Posts: 10
Joined: Fri Jan 11, 2019 4:55 am

Re: .ods spreadsheet gets bold on network sharing

Postby John_Ha » Sun Jan 13, 2019 6:06 pm

If the file has confidential material in it, you can obscure the contents without affecting the structure too much (lines will spill differently because different characters have different widths) by changing every alphabetic character to an " x " with

Edit > Find and Replace
Tick Regular expressions (under More ...)
Find box [:alpha:]
Replace box x
click Replace all

Or just upload a test spreadsheet with a few rows showing the problem.
AOO 4.1.6, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 6336
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: .ods spreadsheet gets bold on network sharing

Postby RW9275 » Sun Jan 13, 2019 10:14 pm

Ok Zizi, here it is.
Attachments
.ods File.ods
The .ods file intact.
(22.18 KiB) Downloaded 7 times
OpenOffice 4.1.5
Windows 10 Home 64Bit
RW9275
 
Posts: 10
Joined: Fri Jan 11, 2019 4:55 am

Re: .ods spreadsheet gets bold on network sharing

Postby RoryOF » Sun Jan 13, 2019 10:30 pm

I tried the file on my computer on a local drive, then on a network drive. Results were identical (and not bold) on both sources.

The file does not change between your computers - what you are seeing is a display problem, caused by some difference in the displays on the computers. We can do nothing to help you - you have to sort this out. As John_Ha says, it is most probably a substituted font - remember that the font indicated in the OpenOffice Format toolbar is not the font being actually used, but the font being requested. If that font is not available n the computer, a font is silently substituted.
Apache OpenOffice 4.1.6 on Xubuntu 18.04 (mostly 64 bit version) and infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 28149
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: .ods spreadsheet gets bold on network sharing

Postby Zizi64 » Sun Jan 13, 2019 10:42 pm

The font property of the cells are "Arial".
But the font property of the Drawing objects are "Arial narrow". I have not such font in my Windows 7 x64. It will be substituted on places where that font is not present.

What objects has that "bold" problem on the target place?
Tibor Kovacs, Hungary; LO4.4.7, LO6.1.5 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.0 and AOO4.1.5
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: 7700
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: .ods spreadsheet gets bold on network sharing

Postby RW9275 » Sun Jan 13, 2019 10:59 pm

The original file was all Arial. I was messing around with the fonts to try and make them less bold. You can change all the cells back to Arial. Remember, this all looks fine on my PC. The problem is in sharing to my laptop. My Excel shares perfectly.
OpenOffice 4.1.5
Windows 10 Home 64Bit
RW9275
 
Posts: 10
Joined: Fri Jan 11, 2019 4:55 am

Re: .ods spreadsheet gets bold on network sharing

Postby Zizi64 » Sun Jan 13, 2019 11:09 pm

You can change all the cells back to Arial.

Not the cells are Arial narrow, but the Drawing objects are. The Sheet "On Computer" was protected without password. I switched off the protection, and then examined the Drawing objects too "in the" column "Mon" with strings: "F", "Carbs", "pp". Those object have "Arial narrow" font property in your attached version.
Last edited by Zizi64 on Mon Jan 14, 2019 12:42 am, edited 1 time in total.
Tibor Kovacs, Hungary; LO4.4.7, LO6.1.5 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.0 and AOO4.1.5
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: 7700
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: .ods spreadsheet gets bold on network sharing

Postby RW9275 » Sun Jan 13, 2019 11:44 pm

I had changed everything to Narrow Arial fonts trying to get things the way I wanted. I forgot to change the items you mentioned back to Arial before I sent the file to you.
OpenOffice 4.1.5
Windows 10 Home 64Bit
RW9275
 
Posts: 10
Joined: Fri Jan 11, 2019 4:55 am

Re: .ods spreadsheet gets bold on network sharing

Postby John_Ha » Mon Jan 14, 2019 2:19 am

1. Edit > Select all. The font box will go empty because you have multiple fonts

2. Select a font you know is on both PCs - eg Arial.

Does it now do it? See attached file.

nb. There is a font specified as Ariall (with 2 x "l").
Attachments
ods File_all Arial.ods
(22.87 KiB) Downloaded 7 times
AOO 4.1.6, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 6336
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: .ods spreadsheet gets bold on network sharing

Postby RW9275 » Mon Jan 14, 2019 3:15 am

I see what you mean. I won't have access to the laptop until sometime tomorrow. I will get back to you.
OpenOffice 4.1.5
Windows 10 Home 64Bit
RW9275
 
Posts: 10
Joined: Fri Jan 11, 2019 4:55 am

Re: .ods spreadsheet gets bold on network sharing

Postby RW9275 » Mon Jan 14, 2019 7:48 pm

Hi Guys,
Well, I went into the OpenOffice program and changed ALL the fonts to Arial. I have the same problem. It does appear to be a display problem, but I don't understand why the Excel file shares correctly. The Excel file is the original one converted to the OpenOffice format. The files are identical using ALL Arial fonts. I will continue working on this, and when I find the answer I will report back. I'm still open to suggestions. Thanks.
OpenOffice 4.1.5
Windows 10 Home 64Bit
RW9275
 
Posts: 10
Joined: Fri Jan 11, 2019 4:55 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 26 guests