Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
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.
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.

I do like Keynote quite a bit though, but Numbers and Pages needs some work.
 
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.
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 think it is nice that Apple added the LAMBDA function to Numbers though
 
I used to like WordPerfect and Lotus 123. Shame to see them all go. It’s Office or freeware as the main choices now.
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 don't require MS office myself, and the free ones do what I need, i don;lt see the sense in paying out for something I don't need.
 
  • Like
Reactions: 0049190
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.
OR just not use Pages?
 
I wish Pages had a Zotero plugin.

I had to write my thesis in something else and decided LaTeX was less of a punishment than Word.
 
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.
 
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.
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.
 
Does anyone know, if documents created in the new version, and compatible with previous versions? I have to maintain a number of Macs & IOS devices on different OS versions, & have been burned on this issue before. cheers
 
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.
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.
 
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.
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.
 
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!!

There are roughly 300 functions/formulas in Numbers vice 500 in MS Excel - yes a significant difference - but the impact of that difference will depend on general use cases. I would expect Apple to continue to add functions to Numbers as they make regular updates.

From a value proposition - it comes free with the MacOS/iOS/iPadOS -- and if it meets the bulk of user needs - it's additive to the Mac/Apple ecosystem.
 
Last edited:
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.
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.
 
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.
Ah yes, WordPutrid. The WORST word processor on any platform EVER.

I hated that garbage so much. Fortunately I only ever had to use it a few times, but WOW it was AWFUL. The only thing that comes close is vi. And yes, even vi is a better word processor than WordPutrid.
 
I'd argue that the vast majority of people that use Excel are only using it to show data. Most people use very few functions (if any). They simply want to make a home budget or track hobbies (brew batches, garden plants, etc.). And for these people, I'd also argue that Numbers is FAR superior.

Pages is Ok, and I much prefer it over Word, but as someone who cares about styles, Pages leaves me wanting.
 
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) :)
Yes. https://www.apple.com/iwork/

I had ClarisWorks for Windows back in the day. It was such a powerhouse of an integrated app that it is what brought me to buy a Mac. As far as I remember, iWork was never an all-in-one app but separate apps and didn't have all of the functionality that Claris/AppleWorks had.
 
Really wish Pages and Numbers would be updated for native visionOS support…
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.
 
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.
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.
 
  • Like
Reactions: PlayUltimate
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.