Ask Your Question
1

Calc - *.xla Add-Ins [closed]

asked 2012-12-09 11:49:26 +0200

libreENG gravatar image

Hey all,

I am an engineer who has switched over to LibreOffice to save licensing costs, but I am struggling to find an easy way to get all the *.xlas and add-ins I use in Microsoft Excel to work in LibreOffice (for example, a steam table add-in). Is there a way to convert the add-ins or get them to work in LibreOffice? Otherwise, I might not be able to fully switch-over.

Cheers

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-19 14:26:19.554061

2 Answers

Sort by » oldest newest most voted
0

answered 2012-12-12 16:08:43 +0200

qubit gravatar image

If you're looking for an easy way to get XLA content working in LibreOffice, I'm afraid you might be out of luck. To quote the OOo forums:

http://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=20163

An .xla file usually contains program code that is not compatible with OOo Calc. Therefore, you cannot load your add-in in Calc.

That being said, if you're gung-ho about migrating to LibreOffice, there's no particular reason why you couldn't get equivalent functionality in LO Calc -- either by using different code, or by tweaking your existing XLA code until it is compatible with LO.

How complicated are these steam tables?

edit flag offensive delete link more
0

answered 2012-12-25 11:51:03 +0200

libreENG gravatar image

qubit,

Thanks for your response - I figured that might be the case! The *.xla I currently have is an add-in that I purchased for $10-15, so recreating it would probably take some time. Steam tables are relatively complex (Check out an online calculator here http://www.steamtablesonline.com/). Anyway, may need to continue using Excel for this part of my job (unfortunately). Merry Christmas,

MZ

edit flag offensive delete link more

Comments

Hi, I am trying to to the same thing. I use the water97_v13.xla that provides all needed functions. I had to change the name of variable pi to pi1 in order to be able to compile it ( if not it didn't work ). I try actually to solve things. I will inform you

gkourtis gravatar imagegkourtis ( 2013-07-31 13:37:35 +0200 )edit

Question Tools

Stats

Asked: 2012-12-09 11:49:26 +0200

Seen: 4,797 times

Last updated: Dec 25 '12