I'll have to try it. Last time I gave it a go it could open an Excel file, but only save it as a Numbers file.It can. And I think for a long time, too.
I'll have to try it. Last time I gave it a go it could open an Excel file, but only save it as a Numbers file.It can. And I think for a long time, too.
This is exactly right. Excel is the best software for most users because of the functionality and like was mentioned, the ability to use across devices. Of course, Google Sheets is more than enough for most people as well and there are far more advanced programs if you need more than what Excel offers (hello Looker), but Apple has kind of given up and I wish they wouldn’t.In my case, Excel, because Numbers doesn't even come close to parity. I spend 1/2 of every work day in Excel.
So, not only are iWork apps not cross-platform, they just aren't as good. I've heard they keynote is okay, but since it doesn't intergrade with excel, I have no use for it.
You need to export it as Excel file. And when you store it as Numbers files, Numbers adds weird images to the file (>500 KB) which makes no sense at all.I'll have to try it. Last time I gave it a go it could open an Excel file, but only save it as a Numbers file.
I still have a copy of wordperfect here, and it still works on my Windows 10 computer. My sister-in-law used Lotus for years, but eventually had to change to MS Office.I used to like WordPerfect and Lotus 123. Shame to see them all go. It’s Office or freeware as the main choices now.
You can export, File, export to Excel is the option,Will Numbers ever be able to save a spreadsheet in Excel format?
OR just not use Pages?I'd actually love to use Pages and Numbers if they could easily and naively save to a generally USABLE formate, idk like .docx and .xlsx. I love the interface for iWork apps, and I use Pages for any personal writing I do but it's worthless to me for writing or editing work docs.
Seriously Apple, you lost the war on the file format wars decades ago, recognize it and make iWork usable and let's move on. On Numbers, a slightly easier way to drop in formula's, like auto sum in Excel, would be nice.
Also, yes, I realize I can export the docs into docx. I shouldn't have to exports to save in the original format if its not a .pages format first. It just adds extra streps that don't need to be there.
I regularly exchange docx files with our writers nad I insert comments and track changes in Pages, export it back to docx and send it back to them. And I have been doing this now for years.I'd actually love to use Pages and Numbers if they could easily and naively save to a generally USABLE formate, idk like .docx and .xlsx. I love the interface for iWork apps, and I use Pages for any personal writing I do but it's worthless to me for writing or editing work docs.
Seriously Apple, you lost the war on the file format wars decades ago, recognize it and make iWork usable and let's move on. On Numbers, a slightly easier way to drop in formula's, like auto sum in Excel, would be nice.
Also, yes, I realize I can export the docs into docx. I shouldn't have to exports to save in the original format if its not a .pages format first. It just adds extra streps that don't need to be there.
I use Pages daily and I prefer it over MS Word. It just feels less cramped and more focused on the writing part. And reality is much, MUCH more powerful than Word could ever be. Apple added a feature a few years back that allows you to convert the text document into what they call Page Layout and this feature alone is huge! Basicly turns Pages into a simplified desktop publishing app. Not just that graphics wont move, etc. You can control every aspect of the page layout much like in something like Indesign. Having a rudimentary desktop publishing app as part of your hardware is something that is pretty incredible.Pages is a damn site better than Word. Graphics stay where you put them rather than jumping around. Editing is much easier. I only use Word if I am forced to any more - too much bloat.
Page Layout is the best feature of pages. It actually existed since day one of the app when it was iWork, and the Word Document style was added later on. It just became must harder to use when they did the iOS/macOS merger, especially on the iOS side.I use Pages daily and I prefer it over MS Word. It just feels less cramped and more focused on the writing part. And reality is much, MUCH more powerful than Word could ever be. Apple added a feature a few years back that allows you to convert the text document into what they call Page Layout and this feature alone is huge! Basicly turns Pages into a simplified desktop publishing app. Not just that graphics wont move, etc. You can control every aspect of the page layout much like in something like Indesign. Having a rudimentary desktop publishing app as part of your hardware is something that is pretty incredible.
As for writing long text and documents, niether of the two (Word or Pages) is really the tool for the task. Both are meant for less involved tasks. At least in my experience.
I also use Numbers for my personal use. I have used Excel professionally and it is indeed more powerfull, but even in that sense, you shouldn't be really using excel for those kind of work. Excel can do crazy stuff, but its a bit like sailing the ocean with a dinky boat. Personally I prefer Numbers based on how you can make things look. And the program can do most needed things. But Excel will keep its place just because of how MS is positioned in the professional enviorment.
Unfortunately, in testing, I found that functions like Matrix Inverse only support up to 9x9 matrices - making them not useful for what I do.Thats good to know
Understood - Numbers has a 1,000,000 row X 65 Column limit (maybe more in iCloud version) but again ----- that is the extreme end of the use case model. Even for Google Sheets - at that size of a data set you might want to use lightweight databases.For most people that true, but if you've ever tried to open a 1gb+ CSV file in numbers, you're going to have a bad time. While in Excel and Sheets, handle it very well.
Cannot find a cogent list of the new functions in Numbers (it isn't in the Help file they reference) nor of the new ability to let calculation results 'spill over' into adjacent cells.
I have discovered that Numbers now supports matrix functions like matrix multiply, matrix inverse, determinate, etc. Unfortunately some of the functions, like matrix inverse, can only work on matrices up to a trivial 9x9!!
I’m surprised Tim hasn’t moved to turn iWork into a subscription service yet. He’s that greedy.
That is a solid point - Apple has been working on their iCloud environment - it is better - but it still needs more work. Now as a counter point - the Google Workspace is limited as it's a browser based capability - it does not have native apps. That is one advantage for Apple's approach.Page Layout is the best feature of pages. It actually existed since day one of the app when it was iWork, and the Word Document style was added later on. It just became must harder to use when they did the iOS/macOS merger, especially on the iOS side.
Overall iWork is fantastic, just wish Apple's cloud services were on par with googles. I work for an Apple Distinguished School, but google dominates still even here because of that.
Ah yes, WordPutrid. The WORST word processor on any platform EVER.Yes yes, and George RR Martin famously still writes his books on a DOS machine with WordPerfect 5.1....which I still think is the best word processing software ever made.
Seeing the term "iWork" makes me wonder if Apple still uses that term to refer to the suite. Albeit I'm old and remember when these things were All-In-ones (ClarisWorks->AppleWorks->iWorks)Iwork is much better than office. And is free
Yes. https://www.apple.com/iwork/Seeing the term "iWork" makes me wonder if Apple still uses that term to refer to the suite. Albeit I'm old and remember when these things were All-In-ones (ClarisWorks->AppleWorks->iWorks)![]()
Correct. iWork was always separate. Was just pointing out the name progression.iWork was never an all-in-one app but separate apps and didn't have all of the functionality that Claris/AppleWorks had.
It probably sounds crazy to anyone who hasn’t tried an AVP for longer than a few hours… but legitimately the AVP could be the ultimate office solution with just a few minor improvements.Really wish Pages and Numbers would be updated for native visionOS support…
Agreed! For my use I have never came even close to the max row and columns and your comment made want to see those are really the limits. Rows do indeed and at 1.000.000, but colums go all up to a 1.000. Still limited but plentiful for most uses.Understood - Numbers has a 1,000,000 row X 65 Column limit (maybe more in iCloud version) but again ----- that is the extreme end of the use case model. Even for Google Sheets - at that size of a data set you might want to use lightweight databases.