CrunchBang Linux

bzachd

Member

From: Your closet

Registered: 2012-05-01

Posts: 24

[SOLVED] gnumeric formulas vs Excel

Hi all,

I am looking for someone who might use gnumeric more than the average user. Higher level formulas etc.

I am working on updating my Excel skills with a home course but am curious to know if anyone knows if the formulas in say Excel 2007-2010 are the same as the formulas in gnumeric.

Looking to see if the same verbage is the same between aps ( vlookup etc )

Any help would be appreicated.

Thanks,

Zach

Last edited by bzachd (2012-05-29 15:34:37)

Unia

#! Die Hard

From: The Netherlands

Registered: 2010-07-17

Posts: 3,176

Re: [SOLVED] gnumeric formulas vs Excel

I would like to know about this too

---

If you can't sit by a cozy fire with your code in hand enjoying its simplicity and clarity, it needs more work. --Carlos Torres
      Github || Deviantart

p120d16y

#! Die Hard

From: Midwest

Registered: 2011-08-08

Posts: 800

Re: [SOLVED] gnumeric formulas vs Excel

As far as I've used Excel, formulas were nearly identical. I was setting up multiplication and total columns for large purchases and expense spreadsheets. I wouldn't know about seriously advanced formulas into trig or something though.

---

All tyranny needs to gain a foothold is for people of good conscience to remain silent.
---Thomas Jefferson ---

2Karl

#! CrunchBanger

Registered: 2012-03-25

Posts: 216

Website

Re: [SOLVED] gnumeric formulas vs Excel

Can't speak for gnumeric, but I know in Openoffice calc the syntax is the same (perhaps some minor variants here and there). My advice is to just try out your formulae of choice, refer to the help docs to get them working if necessary.

---

"It's a pity she won't live... But then who does?" - Gaff.

nore

#! CrunchBanger

From: Lakeland

Registered: 2009-11-28

Posts: 248

Re: [SOLVED] gnumeric formulas vs Excel

Open http://projects.gnome.org/gnumeric/functions.shtml, choose a function and see, if the description page says

Microsoft Excel Compatibility
This function is Excel compatible.

Digit

#! Die Hard

From: the internet

Registered: 2009-05-26

Posts: 979

Website

Re: [SOLVED] gnumeric formulas vs Excel

my dad's an excel guru.  ^_^  he called up microsoft for help once i recall, where they couldnt help him, and he ended up teaching them loads of stuff.

i recall he tried openoffice's spreadsheet thing once, and was disapointed that his extremely advanced formulas and macros didnt work.  idk about gnumeric tho.  one can get rather involved and deep with excel, as my dad has.

just thought i'd throw in that little anecdote about my dad's insane level of excel-ence.  redundant as it is after nore's post and link. 

---

think

bzachd

Member

From: Your closet

Registered: 2012-05-01

Posts: 24

Re: [SOLVED] gnumeric formulas vs Excel

Fantastic info!!

Thanks for the info and advice!

Zach

nore

#! CrunchBanger

From: Lakeland

Registered: 2009-11-28

Posts: 248

Re: [SOLVED] gnumeric formulas vs Excel

Don't rely 100 % on Gnumeric documents though. Microsoft has added some functions on Excel 2007 and 2010 and changed some others. (List of functions that are not backward compatible.)

Rumour has it, that in Excel 2003 days Gnumeric functions were so compatible with Excel, that they had the same bugs.

bzachd

Member

From: Your closet

Registered: 2012-05-01

Posts: 24

Re: [SOLVED] gnumeric formulas vs Excel

Open http://projects.gnome.org/gnumeric/functions.shtml, choose a function and see, if the description page says

Microsoft Excel Compatibility
This function is Excel compatible.

Thanks I took a look at this site and its extreemly helpful.

Zach

2Karl

#! CrunchBanger

Registered: 2012-03-25

Posts: 216

Website

Re: [SOLVED] gnumeric formulas vs Excel

Don't rely 100 % on Gnumeric documents though. Microsoft has added some functions on Excel 2007 and 2010 and changed some others. (List of functions that are not backward compatible.)

Rumour has it, that in Excel 2003 days Gnumeric functions were so compatible with Excel, that they had the same bugs.

But also remember that most functions can be reproduced with clever use of formulae.

---

"It's a pity she won't live... But then who does?" - Gaff.

bzachd

Member

From: Your closet

Registered: 2012-05-01

Posts: 24

Re: [SOLVED] gnumeric formulas vs Excel

I recently purchased a home course to kinda work through some Excel stuff.... and they have some free spread sheets that might be helpful for you to see if gnumeric would work.

they have some out at www.LearnMicrosoftExcel.com I just downloaded and am running tests on.

Some things are slightly different... but overall it seems to be pretty compatable.

Zach