Currently Being ModeratedJun 29, 2013 4:58 PM (in response to sjrash)
Buy Office 2011 - www.mactopia.com. Numbers is no match for Excel.
Currently Being ModeratedJun 29, 2013 5:13 PM (in response to sjrash)
Thanks Kappy. This is the general concensus I've been hearing. I just wanted to be sure before making the purchase.
Currently Being ModeratedJun 29, 2013 6:20 PM (in response to sjrash)
From the many discussions here about compatibilty between Numbers and Excel, it is clear that swapping documents repeatedly between the two is not good. Go with Office for Mac as Kappy said.
Currently Being ModeratedJun 29, 2013 7:08 PM (in response to Yellowbox)
If you do not want to spend a bunch of money you can try to use LibreOffice for free and see how that goes. For simple spreadsheets it works fine. If you are making fancy spreadhseets and such, then you should spend the money to be consitent with the office.
Personally, and this is just me, I have no Microsoft software on my computer except for Remote Desktop so I can use my computer at work from home. So I preferentially use Numbers and every once in a while use LibreOffice.
Currently Being ModeratedJun 30, 2013 4:22 AM (in response to sjrash)
When I produced spreadsheets for my self-employed work, I just exported them as Excel friendly sheets which my accountant was able to use on her laptop. There was no need for me to purchase Excel or any Office for Mac software. iWork Numbers is quite capable of producing spreadsheets that are Excel-friendly. So much so, that I won't even be purchasing Boot Camp.
Currently Being ModeratedJun 30, 2013 4:52 AM (in response to sapper)
Exporting from Numbers to Excel is OK if you have a single table with no bells and whistles. That is the same as sending your accountant a plain text or CSV file. However, if you want to use the power of Numbers to do some processing and layout...
Here is a "simple" Numbers document. Two tables and two charts (graphs) on one Sheet:
Now export to Excel then import back into Numbers:
Now 4 sheets.
Now repeat (export to Excel, then import back into Numbers:
Now 4 sheets with longer names.
And if your Excel recipient made changes, wouldn't that be a nightmare?
Stick to a single table (that becomes a single Worksheet in Excel) and you can get away with it. Anything else, good luck.
Currently Being ModeratedJun 30, 2013 6:49 AM (in response to Yellowbox)
Hi Ian, no disrespect, but I was only replying to someone else's comment about their need to buy Office for Mac. Unfortunately, your very kind explanatioins, though useful to someone, are of no use to me at all, mainly because I have no need to be exporting spreadsheets any longer.
Thanks all the same.
Currently Being ModeratedJun 30, 2013 7:35 AM (in response to sapper)
And I meant no disrespect to you. Thank you for your input. My example should have been addressed to the OP (Original Poster) sjrash, who may be expecting more than a simple conversion of a single Numbers Table to Excel (and back again to Numbers) several times.
I do have a need to export to and import from Excel, mainly because my friends are Excel users. And I find that frustrating!
Kind regards, and enjoy Numbers!
Currently Being ModeratedJun 30, 2013 8:06 AM (in response to sjrash)
I suppose the $20 in investment isn't a huge risk to find out if it works for me.
Currently Being ModeratedJun 30, 2013 8:22 AM (in response to sjrash)
I am sure that you will enjoy Numbers for your personal use, even if it is not compatible with your work requirements.
Currently Being ModeratedJun 30, 2013 3:52 PM (in response to sjrash)
I purchased Numbers and imported the two excel files I use the most, and edited them. It worked flawlessly. I haven't exported them back to use on excel yet. I will post when I do.
Currently Being ModeratedJun 30, 2013 6:45 PM (in response to sjrash)
Really depends on your spreadsheet more than anything.
I have a couple huge ones with thousands of calculations & lots of data.
Numbers has never usually given me any issues - until I tried to use that spreadsheets with it.
Numbers would give me the spinning pinwheel any time I edited one cell and would show up as "Not Responding" in Activity Monitor.
I broke down and updated my old Office install & opened that same spreadsheet nearly instantaneously in Excel.
And it flies through the calculations.
Your Mileage May Vary.
Currently Being ModeratedJun 30, 2013 7:26 PM (in response to npalardy)
I agree with npaardy with regard to perfoance on large data sets. Compared to Excel or LibreOffice Numbers is ghastly for large data sets. For many other cases it is great.