| View previous topic :: View next topic |
| Author |
Message |
Carlos FireFox
General User
Joined: 30 Nov 2005
Posts: 36
|
 Posted: Wed Nov 30, 2005 12:10 pm Post subject: New on Calc |
 |
|
Ok im new on Ooo (Sorry for my bad english)
Im tempted to migrate my business from MS Office to Ooo.
So i have some questions.
1.- I heavily depends on Excel and all its functions (Pivot Tables, complex formulas, etc etc) (except Macros) Shall i will have problems using Calc ¿?
2.- What functions does word have, that arent included in Calc and viceversa, what are the pros of having Calc versus Excel (not the obvious one.. Calc is FREE) 
And finally, does anyone knows the release date for the 3.0 version ?
Thank you |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Wed Nov 30, 2005 12:44 pm Post subject: |
|
|
OOo has a superior handling of userdefined styles, consistant in all applications. For example, a formula of a spreadsheet-cell can calculate, which userdefined style has to be used (function STYLE()). You can even define hierarchic styles-trees. The tool is called "Stylist" (key F11).
Calc has some disadvantages if you are a heavy user of array-formulas (matrices). {=ROW(A1:F100)} always returns a single "1" (the row-index of the first cell). I can not say much about Writer. Without high ambitions, I use the same three simple templates happily. The drawing-application is a wonderful tool, when you learn a little bit.
Other week points of calc are charts and data-pilots(pivot-tables). You can not use calculated fields in data-pilots. But you can create calculated fields in the source-table and include them in the data-pilot. You find many issues about charting in this forum, including some workarounds.
Last edited by Villeroy on Wed Nov 30, 2005 12:53 pm; edited 1 time in total |
|
| Back to top |
|
|
richhill
OOo Advocate
Joined: 16 Jun 2004
Posts: 418
Location: Mesa, AZ
|
| Posted: Wed Nov 30, 2005 12:49 pm Post subject: |
|
|
OOo recently released 2.0 which improved the DataPIlot (Pivot Table) functionality more in line with Excel capabilities.
Like Villeroy said ... array formulae is a bit of hit or miss
Charting is a sad story - but the future is bright.
At least until Excel 12 
_________________
OOo Calc tips: http://www.openofficetips.com |
|
| Back to top |
|
|
AndrewZ
Moderator
Joined: 21 Jun 2004
Posts: 4140
Location: Colorado, USA
|
| Posted: Wed Nov 30, 2005 1:36 pm Post subject: Re: New on Calc |
|
|
| Carlos FireFox wrote: | 1.- I heavily depends on Excel and all its functions (Pivot Tables, complex formulas, etc etc) (except Macros) Shall i will have problems using Calc
|
I suggest actually trying a sample of your documents in OpenOffice.org because, as you said, it is free. You have nothing to lose through a little testing. Start by verifying that your most dependent cells are calculated correctly. Check the PivotTables. Look for formula errors (such as #REF). This process should quickly answer your question #1.
| Quote: | 2.- What functions does word have, that arent included in Calc and viceversa, what are the pros of having Calc versus Excel (not the obvious one.. Calc is FREE)
|
For very large spreadsheets, Excel is faster, but on my Opteron 252 CPU the difference is small. As Rich mentioned, Calc charting is poor, but that should improve in OOo version 3. Otherwise, I notice little functional difference between Excel and Calc.
| Quote: | | And finally, does anyone knows the release date for the 3.0 version ? |
As far as I can tell, no date has been set. Since 2.0.0 was just released, I guess 1 to 2 years for version 3. |
|
| Back to top |
|
|
Carlos FireFox
General User
Joined: 30 Nov 2005
Posts: 36
|
| Posted: Thu Dec 01, 2005 7:58 am Post subject: |
|
|
Thank you for your advices, i will give OOo a try.
God Bless... |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|
