Open Office Calc
Open Office Calc
(OP)
Anyone using OpenOffice.org's FREE spreadsheet and other alternatives to Microsoft's versions ? Problems, comments and suggestions would be useful additions to this forum.
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
|
RE: Open Office Calc
The biggest issue I find is with spreadsheet solutions. Programming in VBA for Excel is more common due to the nature of VB. OpenOffice is a little more difficult to find compatible programs.
--Scott
http://wertel.eng.pro
RE: Open Office Calc
No compatibility/ interchange problems to report. Fair warning; I keep stuff simple.
Mike Halloran
Pembroke Pines, FL, USA
RE: Open Office Calc
Anyway for the rest it works fine.
Best regards
Morten
RE: Open Office Calc
I'd also be interested in problems you've encountered. I've had several recent crashes with one particular fairly large spreadsheet. Can't figure out what caused the crash. Or why the files became corrupted, if that is what happened.
RE: Open Office Calc
I exchange another smaller spreadsheet occasionally, and encountered one glitch where OO displayed a cell without trouble, and Excel reported a #REF error for that cell and every dependent cell. I think it had something to do with a leading space or something trivial like that. I couldn't debug it in OO until I saw it in Excel.
Mike Halloran
Pembroke Pines, FL, USA
RE: Open Office Calc
But... I hear that the Linux version is supporting VBA now.
But... I married a corporate who has access to the more than reasonable discount mentioned above. Legal, status quo and ONE MILLION rows for $20. Sold.
RE: Open Office Calc
By the time I gave up it was taking about 20 minutes for a reresh.
To OO's credit, it exported as an xls perfectly, where it runs very quickly.
Yes, the lack of VBA and the poor graphing is the day-to-day killer for me, but not being able to handle large sheets is no good either.
Cheers
Greg Locock
SIG:Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.
RE: Open Office Calc
Thanks for the suggestion and comments:
"But... I married a corporate who has access to the more than reasonable discount mentioned above. Legal, status quo and ONE MILLION rows for $20. Sold."
I would gladly pay $20 for a good spreadsheet. Where does one find such a thing ???
RE: Open Office Calc
Certain corporations have agreements with larger companies to offer home use licenses to all employees of all the software the corporation licenses. The cost of the home use license (the same functionality as the corporate license) is $20 per.
--Scott
http://wertel.eng.pro
RE: Open Office Calc
Now if I understood why I have to pay $200 for the same thing someone else can get for $20...............
RE: Open Office Calc
Something which seriously bugs me about OO Write and Calc is that it capitalizes your initial letter and you have to trick it to let you keep your text as you entered it.
RE: Open Office Calc
$200 adds to profit, $20 is intended and licensed in a way that the software is really an at-home extension of the seat you occupy in the office.
Anything to avoid a VPN i am in favour of.
RE: Open Office Calc
RE: Open Office Calc
You might also want to look into Lotus Symphany. It's IBM's free package based off the Open Office code.
RE: Open Office Calc
Cheers,
Joerd
Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.
RE: Open Office Calc
However, if you have student, you can get the student edition for around $100, which does not include Access, at Costco and other stores.
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Open Office Calc
RE: Open Office Calc
Don Phillips
http://worthingtonengineering.com
RE: Open Office Calc
RE: Open Office Calc
Don Phillips
http://worthingtonengineering.com
RE: Open Office Calc
RE: Open Office Calc
I do not have OpenOffice so I cannot try inserting OLE objects but I can see what you would want the copy/paste capability. Have you tried OpenOffice forums to see if someone created OLE capability on some version of the software?
Don Phillips
http://worthingtonengineering.com