Considering most people that use a spreadsheet have no idea what a pivot table is, let alone use one, would make me not consider it a basic feature. if anything, I'd like to see Apple spend more time on formatting than adding advanced feature sets.
Libre/Open/Neo Office is a pretty big bag of hurt if you view from an Apple design perspective; let alone compatibility. It would make no sense for Apple to try to turn it into something to put the Apple brand on even if only by inference.
they may not know it by name but what do iwork user do when they want to see data drawn together and be able to make sense of it.
you may call that an advanced feature. it was just at the top of my head. what about filters?
maybe everything but summing up 3 columns is advanced?
btw if everything is so advanced for the common iwork user why create new document formats that most of them will probably send the file in to a non iwork user?
but when iwork first came out i really liked how they allowed you to drag in formulas, see the result for few kinds of formulas etc but if you dont follow that up feature set and updates who cares?
i just dont see apple being serious about creating the best office application (dosent mean it has to have the best set of feature), or the best cloud syncing, or the best maps application, best password syncing, best browser etc etc. unless they prove me wrong with the next iwork suite they just let it sit there and i worry that will happen into most of their new ventures. they are more a disruptor and divider to me as it stands. what was the last market they entered where without a doubt they have the best offering today?
apple just went through a big bag of hurt updating the appearance on their ios and mac. i never said put the apple brand on it. i said put their weight behind it. they can assist with the ui and make it more accessible for the less "advanced" users.
Microsoft has 30+ years of engineering and untold millions of dollars spent on development. I think there is room for competition but at the same time each consumer is judging each app's worth (like numbers) based on their compatibility, matching every feature identically, with that of Microsoft Office, all while not being a Microsoft product.
i wouldnt agree with thats how they are judging it. i think they judge everything based on their usage and needs and when people need something that isnt there thats when say something.
you also realize that apple has many many years of experience in the office apps world?
btw i wasnt aware that apple bought editgrid. for a long time i thought it surpassed google sheets and had more advanced and better features. they probably still do since google has killed a few things off. for instance it was much easier using editgrid to get data of other websites.