By using this site, you agree to our Privacy Policy and our Terms of Use. Close
kn said:
Ok, for those that are complaining about Open Office's calc program -- what do you use it for? I make pretty damn complex sheets with a lot of nested conditional "if" statements and other fairly complex calculations and the program works like a champ. Clearly Microsoft's Excel is the more polished version and, well, it's commercial.

If you have something specific that Calc won't do or fails at, please tell me what it is as I'm curious...

I have never used Calc before so here are a few of my questions:

1. Can you create macros in the Calc spreadsheets? ( and I am not talking about putting "=..." in a cell.  I mean creating actually functions)  And if so what language does it use?

2. How well can it comunicate with a database?  Are there functions to have the spreadsheet automaticly pull data from a database and update the information when the sheet is opened?