Currency conversion made impossible - suddenly USELESS for business! 1/5
The latest update has introduced a (intended?) bug whereby currency conversion becomes pretty much impossible to do intelligently:
If, for example, you buy a pineapple for USD3 and want to know how much this would be in Euros, in the past you simply had to do this:
In the first cell (A1), put in USD3.
In the second cell (B1), enter the foreign exchange rate, e.g. 0.8451.
In the third cell (C1), you would enter the formula: (A1) x (B1) = (C1)
Finally, you would open the Format sidebar, under “Data Format” you would select “Currency”, and then from the list of currencies below select the one you desire, e.g. Euro. Job done!
NOW, the software automatically resets the currency in (C1) to whatever the currency in (A1) is, and you cannot avoid it!
Yes, plainly logically / arithmetically speaking USD3 x 0.8451 = USD2.5353. I will admit that.
However, for currency conversion purposes, it is UTTERLY USELESS to have the software force the mathimatically correct solution upon you.
"Thanks” to this annoying update virtually all of my existing Numbers files such as expense reports, payroll reports, market research files, annual reports, etc have been rendered completely useless!
APPLE, you NEED to get this fixed!! Without a fix my business will no longer be able to operate, and I as well as countless other internationally operating businesses around the world will have no choice but to use another software such as Excel instead!
It Cant Sort Numbers 2/5
I’m Making a very simple item tracker sheet and each of the items is numbered (1,2,3,4…56,57….103,104,105,etc…) and when I went to sort them into numerical order, it went from 1 to 10 instead of 2, then it went from 10 to 100, and skipped every number in between. It'ss like it's just putting them in numerical order based off the numbers going left to right rather than what the numbers actually are.
Lost formatting 2/5
After the last update, some of my spreadsheets lost formatting.
Don't install the latest update 2/5
I'm usually a very big fan of Numbers and the whole iWork suite all together.
However, there's huge issue in the latest version. A lot of my spreadsheet stopped working. I do a lot of currency conversion.
So I'd have Cell A with a Euro amount. Cell B with a USD amount, then Cell C with the USD amount converted to Euro. Something with a formula like Cell B / 1.17. Then Cell D would be Total Euro (so, cell A + Cell C).
This used to work very well. Now, if a cell with a formula references a cell in a given currency, it AUTOMATICALLY becomes of the same currency. Which means my Euro amount converted from USD is displayed as USD, even though it used to be configured as a Euro currency cell. And there's no way to restore it back to Euro, it will constantly go back to "Automatic" format type.
As a result, all my totals now are in error state because you can't directly add USD cells with Euro cells.
Apple, please fix this. I hope I'm not the only one to encounter this issue. I would change my rating back to 5 stars if it wasn't for this bug!
What is going on 2/5
We’ve been using Numbers for many years and never had any issues with it until this version. We regularly do our invoices on a long standing template many time with different currencies on the same page. Normally its never been a issue, but now, you can only use a sinlge currency per page, everything else just get changed automatically.. Very annoying and is costing us time and money….
GET THIS SORTED OUT before we have to look into other products….
Updated Damages Application 1/5
You can not print horizontally with update… when using spreadsheets this is perhaps the most common feature… why would this be the case???
Cells with custom data format default to USD or EUR 3/5
Hello, after the update of Numbers (from 4.2 to 4.3) all my cells that have custom DATA FORMAT are defaulting to "AUTOMATIC" and "CURRENCY US DOLLAR $” and in some documents they default to EUR €. My custom format is NOT currency and thus all the data in those cells gets messed up upon opening the docs. All my invoices that I've issued since 2011 that I open now get corrupted. I have tested with many docs going back to files from 2011. I was on the phone with Apple Support now and figured out there is a BUG in the latest update (4.3) só we reverted to Numbers 4.2 from Time Machine and everything os OK using v4.2. So it's proven that this is a bug within Numbers 4.3. The support case ID is: 100303170788. Numbers for iOS 11 has the exact same problem both on iPhone and iPad. New docs are OK. Old docs are NOT. Please fix. Thanks
numbers and update 5/5
I just did an update on my mac and now trying to download numbers but i am getting this error "Numbers can’t be installed on “Macintosh HD” because OS X version 10.12 or later is required."
Annoying Update Popups 4/5
I really like numbers it makes doing spread sheets fun. Really there is nothing to complain about with the functionality of the program itself. The exception are the annoying popup windows that say there a new version if you update MacOS. There a dozen of these annoying popup windows a day. Why should the end user have to keep getting these annoying pop windows all day that interrupt the use of the software? Wish I could update, however not the system admin on the machine. My work decides what version of the OS to use not me. Please fix the app to not keeping popping windows to update to the next version. Maybe keep it for only when the app starts up.
Number formatting won’t change 2/5
Latest update will not allow me to change the number formatting from currency for values added from other tabs! Also, all my values in a spreadsheet that were coming from other tabs are now in currency format and they won’t change back.
Currency manipulation broken 1/5
New update does not allow a value in a cell in a currency to be multiplied/divided by a value in another cell and return a value in another currency. For instance £ be multiplied by a cell with an exchange rate to return a value in €, it is forcing the return of the conversion in £.
This is the 21st century, right? 1/5
By Hondo Ace
Why even make this product? It is like using a spreadsheet in 1994. My 2015 mac pro would like to use something other than Microsoft Office 365! Additionally, I also just discovered the quotient function drops remainders and uses only whole number so all my data inputs yield outputs that are incorrect. I thought it was just a setting regarding rounding places/decimals but nope it is standard operating procedure. Who builds a spreadsheet that can not compute basic math! 8 divided by 1.6 equals 5. But, not to Apple; it is 4! Are you kidding me? All my data is fiction when using this. I honestly wonder why do they make this and how can they be taken seriously!
Don’t know how to autofill the cell column 4/5
For example I am starting is cell A2 : -10, A3 : -9 and so on. i tried to select both cells and drag down but it wont work. ive looked online for videos but still wont work. does anyone know what i am doing wrong?? Please help and thanks!
Don’t leave your documents open 3/5
I like Numbers, but it has a glaring problem if you happen to leave you documents open off a server or other connected disk. You can’t save, and you can’t even “Save As” — it loses all connection to the original document (even though you’re looking at it).
There’s no alternative except to copy and paste when you do that — and you’ll lose your work. On top of that, the copy and paste functionality is odd — it likes to repeat cells when you specify an area.
At least Excel will allow you to save as!!
Shuts down when I type… a number!!! 1/5
Every time I type a number, the app shuts down. I can type letters, but not numbers.
I have tried starting spreadsheets from scratch and also using my old ones.
When tried to contact support, I was informed that they might charge me 29€.
One very annoying bug 1/5
Huge grievance. Remember the window size of my files! If I have three columns, but a few dozen rows my window will be narrow and long. Why does it reset to taking up half my screen every time I open it up! So annoying!
Also, it asks for TouchID, which it recognizes, but then STILL pops up a prompt to type in my password.
auto zoom 4/5
The new feature in which my spreadsheets auto zoom to fit my screen are a pain in the *ss. Please make it stop or at minimum give us the ability to turn off this feature. Thank you.
Its just been so dumbed down it just doesn't work for me anymore.
No Save As, and what they replaced it with is absolutely horrible.
Merging cells has screwed up my formulas on a spreadsheet that I've used without any problems whatsoever until I wasted my funds on this dumbed down version that is compatible with iOS.
What a joke...
What the heck happened? 2/5
By Hoppe 1
Ever since the last update, Nombers, Keynote and Pages will not open. If I fight through icloud I MIGHT be able to get them to work. I have several iMacs and devices and it is happening on all of them when I hit the icon.
Works well. 5/5
Numbers and all Apple office software just works. Takes some getting used to when you’re used to usign the “other” office software, but it’s worth getting used to this.
Numbers works well and imports most of my Excel work with out any issues. I will certainly contine using Numbers - it keeps getting better!
No permite ingresar nada. 1/5
En esta actualización, la aplicación ya no funciona. Cada vez que se quiere ingresar un valor en cualquier celda el programa aborta.
Please Fix This! 2/5
By DJ Tribal
I’ve downloaded several photos and cannot insert them directly into a new document unless I copy and paste them into PHOTOS app. Why can’t I access ALL FILES or DOWNLOAD files from the drop down menu in any of these Apple apps? This makes no sense. Please fix this.
Please bring back updating stock quotes! 3/5
I loved the new stock quote integration feature of Numbers! I understand where live updating may be too expensive, but the new version only updates prices from the previous day’s close. This is near useless.
Perhaps Apple could update quotes with a 15-20 minute delay? Anything more frequent than the previous day’s close would be appreciated.
Otherwise, great app. I love working on my spreadsheets across all of my devices.
Don’t upgrade if you use comments! 1/5
In their quest to improve comments (the display is much nicer & cleaner) they’ve broken them completely. Hovering over a given cell will show the comment from the cell above it. And even clicking on a cell’s comment marker (little yellow triangle) will open the wrong comment. I use comments extensively, and if this isn’t fixed very soon (days, not weeks) I will have to switch back to Excel, which I hate. I can only guess that no one on the Numbers teams uses comments.
Nice but... 3/5
Very nice application, inlcuding the iWork suite, but very little consideration for the 90% of us who have to convey our documents in MS formats. Navigating through exports and subsequent lost formatting and trying to go back an forth is such a chore that it make me not want to use the native Apple programs at all. PLEASE enahnce the interoperability between iWork apps and MS counterparts (like Google docs has done). By doing so you will ensure people use the Apple apps.
Numbers Version 4.2 1/5
After installing this update, all the Comments in my workbooks are messed up and incorrect. Be warned, especially if you make a lot of comments on worksheets
Stocks are frozen in yesterday’s market Totally useless for stock tracking 1/5
I loved the new stocks tool introduced in the previous version, however after the update the stocks are frozen in yesterday’s market, no real time updates.
Totally useless for stock tracking.
I’m wondering how to return to previous version.
So Much Cleaner Than Microsoft Excel 5/5
By John P Young
It doesn’t have as many features as Exce but It’s so much easier to use than Excel and also so much cleaner. You don’t have that stupid ribbon tabbar bar at the top where have the buttons are grayed out anywhere, if you need a tool it will come up when you select the object/table your working on. Also if you are working with basic functions the function helper is Amazing.
This update make Numbers even smoooother!!! 5/5
I was having a problem where open large text and photo base number files.
Now number open, edit and save very smoooooth.
Thank you Apple!!
Will not even open 1/5
Got the newest MacBook. Downloaded Pages 4.1.1 and it will not even open. I get to the screen where I can open a Blank document and then it crashes. Older versions of Pages not available easily. Very frustrating
Great Design; Missing Capabilities 3/5
I love Numbers’s UI, and I want to use this app, but I’m really missing a few features from Sheets/Excel:
- The ability to write, e.g.,=SUM(B2:B), so that a formula applies to a whole column, no matter how long the column becomes
- Some equivalent of data validation, so that I can either choose a cell’s value from a dropdown menu OR input the value manually
- The ability to manually specify a domain for conditional formatting rules. (E.g., I want to be able to type the domain, instead of having to highlight the cells).
- Support for array formulas
Becoming the norm with apple—doesnt work! 1/5
I see all the great things this does but will never know as it will not download. I have about had it with apple, just went thru the nightmare of photos and what a joke. As microsoft is doing so much apple is making things so difficult in a desire to do I no not what. A great company and product getting steam rolled by competition and I have purchased about every apple product at home and office for 27 years. But at wits end.
cant update 2/5
numbers will not allow me to update so i cant use the chart i chose that says i need to update. now what
You Need Sierra to use this version, are you kidding me? 1/5
What a lousy thing. Why does the app store let you try to download this if you are running el Capitan? I thought Apple was smart? Not So! Because it will not work. Not everybody wants or needs Sari.
Transpose functionality 1/5
You can transpose with Numbers, if you want to transpose the entire sheet… There is only one word for this. Ridiculous. Makes me wonder if there are not other nasty little suprises just waiting to pop up.
So I gave it one star, because I cannot recommend this program as a replacement for Excel, which is undeniably the standard regardless of the version.
Why the changes? 2/5
Why are the tabs now on top, linear, so that if they have long names only a few show at a time? Why is the formating on the right? Why do developers, especially Apple developers, feel that they have to “mix it up” every few years? Why do we have to spend so much time to RELEARN a program that we’ve already used for years? It just makes me want to turn off the computer and play cards….
Issue with Update 4/5
In my case, the solution was to open the new version from the folder Applications>Numbers. Delete the old version from Applications>iWork09>Numbers
It worked for me!
The only reason I am giving 4 stars is because i think this should be managed by Apple in a better way. Communication is everything!
The app itself is great!
Same story, won’t download 1/5
What is so different with this version that you need macOS Sierra? 1/5
Hello Apple Inc, for several reasons, not everyone can or want to update to Sierra which is the required minimum macOS version for this Numbers update. I personally use more than one Macintosh, a 2009 MacPro running ElCapitan that can’t update to Sierra, a 2015 MacBookPro that is updated to Sierra, an iPad3 running iOS 9.3.5 (can't update to iOS10) and an iPhone7+ running iOS10.3.1.
When I opened a numbers document in my MacBookPro running Sierra, it converts that document to 4.1.1 and I can no longer open the document in my MacPro which is very frustrating. As you can see, you made it very difficult for me to use Numbers with this update.
It’s like tricking your customer to ditch their older 2009 MacPro to run the latest numbers spreadsheet (2009 is not old, I have 10 years + widows PC that continues to work with Windows 10). So now I’m thinking of ditching iWorks alltogether and go Office 2016, at least I have the confidence that Office 2016 will continue to work with all my devices. This is only one of many increasing frustrations I have with Apple devices and it continuous to pile up.
FYI, I have been using Apple products since the 90s. My whole family uses a ton of Apple devices. My 17 yr old daughter uses a 2013 MacBookPro, iPhone 6+, Watch and iPadAir2. My wife uses a 2011 MacBookPro (still getting used to ElCap and not into changing macOS every year), an iPhone5, Macbook mid 2007 and an 8-core MacPro 2006 (running old accounting app) both upgraded to SSD but stuck in Lion 10.7.5 hell.
Stop the silly 2010 model minimum requirement to run the latest macOS, 7 year old computers w/ 12 core Xeon CPU and 16GB memory is still very capable and I find it ridiculous that I can’t install Sierra on this machine. This is not the way you treat your loyal customers!
Updatates won’t load 1/5
By cat lady 03
I have been using numbers and pages since I got my macbook pro 5 years ago…lately after I make a document in either app,,, when I go to open it again it tells me the extension is wrong, I need to update it, I update the document then it tells me it can’t be opened because its unrecognizable…I create expense reports in numbers and it takes months of work in one document…I just tried to open my current years spread sheet and it tells me the same thing,,, cant open it.. so apple community questions say the same thing is happening to other people,,, so i try to start by updating numbers and I have been watching the stupid thing spin for over an hour..
ANYONE OUT AT APPLE LISTENING? What are we suppose to do ?
the update problem 4/5
I was going to write a really angry comment to Apple because of this problem. I was having the same issue with my pages and keynotes apps as well. Very frustrating because when I need them I need them right then. Any way I went to my hard drive and found the updated apps in my application folder. I removed the older versions from the dock and put the new ones on the dock instead. I had no problem pulling up my documents in numbers this time. I just hope I remember this the next time I get a message that I need the updates. I always stay current with my updates. Hope this helps anyone with the update problems.. It worked for me
I agree with KnashingTeeth 1/5
I can’t get the down load I’m stuck with 3.6.2 & all I get is the wheel & NADA ! Why is there not a update option in the Bar ? What IS going on ? the “nick name is obviously to keep reviews from being posted !
By Frustrated And Counting
Having the same issue as everyone else is reporting for Numbers. Prompted, attempted, logged in, spinning cog that it’s “thinking” then it times out. I have yet to get numbers to update and I’ve tried over several different dates.
Update will never download even though I’m prompted to update it.
By Joe-Joe 416
Will not download
Updates don’t download 4/5
Every time I open Numbers, I’m told there is an update. But the AppleStore Updates page says there are no updates for Numbers, Keynote, or Pages. However, if I search for Numbers, there is a button that says Update. I click it and the progress gear start going round and round but nothing is downloaded. The I go to this Numbers page and click the Update button and nothing downloads.
I am somewhat glad to see that I’m not the only one having this problem but I’d like to know — is there or is there not an update for Numbers on Sierra? I was able to get the update for Yosemite with no problem but nothing happens in Sierra except tell me there is an update.
Good Update to Numbers 5/5
By Hungry Traveller
I recently downloaded the latest update to numbers. I was very glad to see that Apple finally added an easy to use Stock function (and a Stock spreadsheet template) to download stock quotes real time. This is great. I don’t have to mess around with difficult to use macros in other brands spreadsheets. IMHO this was long overdue and is a great addition. I can now create a stock spreadsheet on my Mac at home and then make accessable to my mobile devices through the cloud and have all of my customized inforrmation whereever I go. I will definitely be using Numbers more often now.
Update doesn’t function 1/5
Keeps propting me to update, but it will not download. It does this on every computer I have.
annoying update messages 1/5
By Evil Spock
Update won't download, and I get nagged constantly to update. I don't need the freaking update just stop nagging me everytime I open Numbers.
Recent update pros/cons 3/5
I have been using Numbers for over a year instead of Excel for a few personal spreadsheets including my personal finances.
I find it easier to use than Excel and until the recent update had been relatively satisfied.
I like the integration between my iPads and my Macs using iCloud.
The recent addition of the STOCK function that gets stock quotes has been a big plus.
The recent update crashes fairly frequently on macOS 10.12.4 on a Mac Mini 2012 with 16GB RAM. Prior to recent update was very stable. I now don’t wait for auto-save, after any change I do a manual save. Pretty annoying, I hope they fix this soon.
iCloud sync has been working well recently but there have been times in the past that they haven’t synced properly. After an editing session I note the date and time of the update and make sure when I edit on another device that they match. I also backup to DropBox frequently.