An open community 
of Macintosh users,
for Macintosh users.

FineTunedMac Dashboard widget now available! Download Here

Previous Thread
Next Thread
Print Thread
"Numbers" question
#62710 10/27/22 07:27 PM
Joined: Aug 2009
Likes: 7
OP Online

Joined: Aug 2009
Likes: 7
[rant]I understand their necessity, but I HATE design copyrights! I've got no Windows experience, so I've got no feel for how it differs from macOS, but I recently switched from Excel to Numbers, and I'm almost overwhelmed by the differences.[/rant]

Excel has a pref that enabled me to select the direction in which my cursor moves when I hit "return" after entering data in a cell...my preference being to the cell to the right. Numbers defaults to the cell below, and if there's a way to change it, I've had zero luck finding it.

Anybody?

Thanks!


The new Great Equalizer is the SEND button.

In Memory of Harv: Those who can make you believe absurdities can make you commit atrocities. ~Voltaire
Re: "Numbers" question
artie505 #62714 10/28/22 12:48 PM
Joined: Aug 2009
Offline

Joined: Aug 2009
Well, I don't use Numbers. But, in Excel, the right arrow key will move the focus to the right.

Re: "Numbers" question
Gregg #62715 10/28/22 01:07 PM
Joined: Aug 2009
Likes: 7
OP Online

Joined: Aug 2009
Likes: 7
Excel offers pref options, and as you just said, reacts to the arrow keys too, but while Numbers also reacts to the arrows, "return" as "move cursor right" works better for me, and I'd like it to be able to set it as my default, but...


The new Great Equalizer is the SEND button.

In Memory of Harv: Those who can make you believe absurdities can make you commit atrocities. ~Voltaire
Re: "Numbers" question
artie505 #62717 10/28/22 05:20 PM
Joined: Aug 2009
Likes: 4
Offline

Joined: Aug 2009
Likes: 4
The option may not exist, but Tab will move you to the next cell. On a standard keyboard this move can be done with the left little finger, as opposed to the right little finger for Return. This move also keeps your brain energized, like brushing your teeth with your opposite hand. wink


On a Mac since 1984.
Currently: 24" M1 iMac, 27" iMac, M2 Macbook Air, macOS 10.15.x and MacOS 13; iPhones, iPods (yes, still) and iPads.
Re: "Numbers" question
Ira L #62720 10/28/22 08:05 PM
Joined: Aug 2009
Likes: 7
Moderator
Offline
Moderator

Joined: Aug 2009
Likes: 7
For what it is worth I just checked MacPilot 14, that has literally thousands of hidden macOS preference settings and the only hidden Numbers preferences it offers are:
  • Do not create TOC for Excel documents
  • Save compression level
  • Use human-readable XML file format


So I think you are out of luck.


"Sacred cows make the best hamburger"

- Mark Twain
Re: "Numbers" question
joemikeb #62721 10/29/22 08:47 AM
Joined: Aug 2009
Likes: 7
OP Online

Joined: Aug 2009
Likes: 7
Thanks, all, for the input.

I'm not the least bit sure why I'm married to the pref, but I guess I'll just have to learn to live without it and use the arrows instead.

I'd love to have been around for some of the discussions about which aspects of Excel could and couldn't be reproduced in Numbers, and how to reproduce the ones that could.

It seems like the app was developed by lawyers, rather than by software engineers.


The new Great Equalizer is the SEND button.

In Memory of Harv: Those who can make you believe absurdities can make you commit atrocities. ~Voltaire
Re: "Numbers" question
artie505 #62725 10/29/22 11:18 AM
Joined: Aug 2009
Likes: 4
Offline

Joined: Aug 2009
Likes: 4


Jon

macOS 11.7.1, iMac Retina 5K 27-inch, late 2014, 3.5 GHz Intel Core i5, 1 TB fusion drive, 16 GB RAM, Epson SureColor P600, Photoshop CC, Lightroom CC, MS Office 365
Re: "Numbers" question
jchuzi #62726 10/29/22 11:59 AM
Joined: Aug 2009
Likes: 7
OP Online

Joined: Aug 2009
Likes: 7
Thanks a million for that, Jon! I've done the deal already.

I had decided to forego upgrading my Office installation, because I didn't feel like investing another $75 or so, but I'm finding Numbers annoying enough that it's worth the $40.

Icing! First time in a few years that I haven't been charged sales tax. laugh

(I first checked to make certain that Numbers can export to Excel.)


The new Great Equalizer is the SEND button.

In Memory of Harv: Those who can make you believe absurdities can make you commit atrocities. ~Voltaire
Re: "Numbers" question
Ira L #62731 10/29/22 07:04 PM
Joined: Aug 2009
Likes: 7
OP Online

Joined: Aug 2009
Likes: 7
Originally Posted by Ira L
The option may not exist, but Tab will move you to the next cell. On a standard keyboard this move can be done with the left little finger, as opposed to the right little finger for Return. This move also keeps your brain energized, like brushing your teeth with your opposite hand. wink
You've apparently got body parts that I've never even heard of! tongue


The new Great Equalizer is the SEND button.

In Memory of Harv: Those who can make you believe absurdities can make you commit atrocities. ~Voltaire
Re: "Numbers" question
jchuzi #62732 10/29/22 07:54 PM
Joined: Aug 2009
Likes: 7
OP Online

Joined: Aug 2009
Likes: 7
Thanks again, Jon.

I didn't realize how much I missed Excel until I restored it...as they say, it's a mechaya! laugh


The new Great Equalizer is the SEND button.

In Memory of Harv: Those who can make you believe absurdities can make you commit atrocities. ~Voltaire
Re: "Numbers" question
artie505 #62734 10/30/22 11:19 AM
Joined: Aug 2009
Likes: 4
Offline

Joined: Aug 2009
Likes: 4
Much as I dislike Microsoft, I must admit that the Office suite is really good. The only app that I use is Word, but I can't abide by Pages (annoying and unintuitive). Word does what I want and even my wife (technology challenged) can use it.


Jon

macOS 11.7.1, iMac Retina 5K 27-inch, late 2014, 3.5 GHz Intel Core i5, 1 TB fusion drive, 16 GB RAM, Epson SureColor P600, Photoshop CC, Lightroom CC, MS Office 365
Re: "Numbers" question
jchuzi #62735 10/30/22 11:42 AM
Joined: Aug 2009
Likes: 7
OP Online

Joined: Aug 2009
Likes: 7
The unfortunate fact of the matter is that design copyrights dictate that whoever comes first gets the right of way, and everyone else has got to navigate around them, so Numbers, Pages, and any other Apple apps that mimic MS Office apps are basically compilations of workarounds and compromises.

Similarly, Windows suffers the same fate in reverse.

Having run Numbers for a month or two and reverted to Excel, I'm now married to Excel.


The new Great Equalizer is the SEND button.

In Memory of Harv: Those who can make you believe absurdities can make you commit atrocities. ~Voltaire
Re: "Numbers" question
artie505 #62737 10/30/22 03:19 PM
Joined: Aug 2009
Likes: 6
Offline

Joined: Aug 2009
Likes: 6
Originally Posted by artie505
Having run Numbers for a month or two and reverted to Excel, I'm now married to Excel.
I've tried Numbers a few times thinking that, if I could get an Apple spreadsheet equivalent to Excel, I'd change over. But, I've always found Numbers had too many differences to make a changeover easy.

My guess is it's because Excel started off on the Mac and was GIF from the ground up instead of trying to adapt software to be "like" the Mac (Windows comes to mind). I recall using MS Multiplan, the only spreadsheet available for Mac when the machine was first released, and it was 'okay' but Excel (about 1984 or 1985) blew it out of the water. Excel was so good that Microsoft ported it over to 'those other machines' about three years later.


ryck

iMac (Retina 5K, 27", 2017), 3.4 GHz Intel Core i5, 8GB RAM, 2400 MHz DDR4
OS Mojave 10.14.6
Canon Pixma TR 8520 Printer
Epson Perfection V500 Photo Scanner
Time Machine on 1TB LaCie USB-C
Carbon Copy Clone on 500GB OWC Mercury OTG Pro
Re: "Numbers" question
ryck #62755 11/02/22 10:26 AM
Joined: Aug 2009
Likes: 7
OP Online

Joined: Aug 2009
Likes: 7
I just noticed that the same file that was 2.3 MB in Numbers is 53 KB in Excel.


The new Great Equalizer is the SEND button.

In Memory of Harv: Those who can make you believe absurdities can make you commit atrocities. ~Voltaire
Re: "Numbers" question
artie505 #62760 11/02/22 11:40 PM
Joined: Aug 2009
Likes: 7
Moderator
Offline
Moderator

Joined: Aug 2009
Likes: 7
Originally Posted by artie505
I just noticed that the same file that was 2.3 MB in Numbers is 53 KB in Excel.

And If you looked inside the Numbers file you will find it is, or at least used to be, a package file. (I vaguely recall reading somewhere that Apple had changed the internal format, perhaps to a database format) but in either case there are multiple files in the package. The reported file size is the size of the allocated sectors and each file gets a separate sector, but the actual data content is often significantly less.


"Sacred cows make the best hamburger"

- Mark Twain
Re: "Numbers" question
joemikeb #62761 11/03/22 03:16 AM
Joined: Aug 2009
Likes: 7
OP Online

Joined: Aug 2009
Likes: 7
Originally Posted by joemikeb
The reported file size is the size of the allocated sectors and each file gets a separate sector, but the actual data content is often significantly less.
Same as with block size v block contents, then?


The new Great Equalizer is the SEND button.

In Memory of Harv: Those who can make you believe absurdities can make you commit atrocities. ~Voltaire
Re: "Numbers" question
artie505 #62765 11/03/22 06:48 PM
Joined: Aug 2009
Likes: 7
Moderator
Offline
Moderator

Joined: Aug 2009
Likes: 7
Originally Posted by artie505
Originally Posted by joemikeb
The reported file size is the size of the allocated sectors and each file gets a separate sector, but the actual data content is often significantly less.
Same as with block size v block contents, then?

Yep!


"Sacred cows make the best hamburger"

- Mark Twain

Moderated by  alternaut, dianne, dkmarsh 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.4.25 Page Time: 0.028s Queries: 48 (0.018s) Memory: 0.6570 MB (Peak: 0.7752 MB) Data Comp: Zlib Server Time: 2022-11-29 08:58:56 UTC
Valid HTML 5 and Valid CSS