Font changes while saving in xls

6 replies [Last post]
kartikeyasri
Offline
Last seen: 2 years 7 weeks ago
Title:
Joined: 11 May 2012
Posts: 6

Hi,

When I am saving my files in xls format for sharing, the font changes back to Arial. Is there a way to stop this?

Also is there a way to change the default font from Arial to Helvetica?

Libreoffice: 3.5.4

Mac OS X: 10.7.4

n/a
PeterRoots
Offline
Last seen: 43 weeks 14 hours ago
Title: ==Moderator==
Joined: 25 Oct 2011
Posts: 941
for the default font in Calc

for the default font in Calc (things might be a bit different on a mac)

Format>Styles and Formatting (or press F11)

Right click the default style and select modify

change the font to what you want.

Not sure why the font changes when saving to xls - is this showing up on your machine or when you give it to someone else? If only on their machine probably because they have Arial but not Helventica installed

Linux Mint 15 LibreOffice 4.1.1.2 : OpenSUSE 12.3 LibreOffice 4.0.3

kartikeyasri
Offline
Last seen: 2 years 7 weeks ago
Title:
Joined: 11 May 2012
Posts: 6
I have tried doing the same

I have tried doing the same but the font changes to Arial from another font(helvetica, Times new roman). It is showing on my system as well as on other systems.

I have installed helvetica on other system, but it is the same. The font changes to Arial.

n/a
PeterRoots
Offline
Last seen: 43 weeks 14 hours ago
Title: ==Moderator==
Joined: 25 Oct 2011
Posts: 941
could you post an example of
could you post an example of a problem document here so we can see if there is something in the doc causing the issue? (post the ods not the xls version)

Linux Mint 15 LibreOffice 4.1.1.2 : OpenSUSE 12.3 LibreOffice 4.0.3

kartikeyasri
Offline
Last seen: 2 years 7 weeks ago
Title:
Joined: 11 May 2012
Posts: 6
Please find the file as
Please find the file as requested.
AttachmentSize
fontChanges.ods 7.36 KB
n/a
PeterRoots
Offline
Last seen: 43 weeks 14 hours ago
Title: ==Moderator==
Joined: 25 Oct 2011
Posts: 941
Thanks for the file.

Thanks for the file. Interesting!

I don't have Helvetica on my system but but in LO your file shows the font is Hevetica (I obviously see a substitute font). When I save as either xls or xlsx then close and reopen, sure enough, the font is now Arial.

Thinking that you may be using CTL, I enabled this on my system. I now have English(India) as my Western language and Hindi as my CTL default. Now I see that the western font is Helvetica and the CTL font is Arial.

Your problem still exists when I change both to Linux libertine G (had to test with something else other than Helvetica)

Now I have enabled support for Asian Languages - no language selected and I see that your default style is using Arial for this as well as CTL

I have now changed your document to have a default style containing libertine G for Western text front family, Asian text font family and CTL font family.

Now when I save as xls the font stays as Libertine G so I guess this would be the same for Helvetica. I have not checked what Helvetica supports in terms or Asian characters so you might come unstuck on this (also not checked on what Libertine G supports, this was just a random choice to let me test things)

My assumption is that during the conversion to xls the multiple fonts in the default style do not all get looked at correctly and that the Asian font overrides the Western font.


Linux Mint 15 LibreOffice 4.1.1.2 : OpenSUSE 12.3 LibreOffice 4.0.3

oweng
oweng's picture
Offline
Last seen: 6 hours 13 min ago
Title: ==Moderator==
Joined: 26 Jan 2012
Posts: 2467
known bug
Appears to be a known bug (FDO#34412) without a fix yet. There are no reports in the details relating to the Apple platform, however I would guess this is the same issue.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.