Opening Numbers doc at specific cell

Hi SG,

Sorry, but I do not agree. This may help Simon and other users.

Tested in Numbers 10.2 under macOS 10.15.4 Catalina

My settings in System Preferences > General

In Numbers,

• The graph is selected;
• Save (important!);
• Quit Numbers;
• Shut Down;
• Restart;
• Launch Numbers and navigate to open that document;
• Exactly the same objects are selected.

I agree with the OP Simon that the selected objects may not remain selected in an exported Microsoft Excel document.

Stay safe, my friend.

Regards,

Ian.

In System Preferences > General there is this setting for "Close. windows when quitting an app":

Make sure you deselect it if you want Numbers (and other apps) to resume where you left off.

SG

simon12 wrote:

OK, so that works when saving a numbers doc as .numbers Unfortunately, when saving as .xls it reopens at the beginning every time. Obviously some bug that happens when saving in that format.

I wouldn't consider that a "bug." After all .xlsx or the older .xls are not a native format for Numbers, which has a very different design from Excel. Numbers does not try to be a clone of Excel. The ability to import and export in that format are a convenience, not a perfect solution.

Have you tried opening a .numbers file in Excel? (The answer is it you can't.) That's not really a "bug" either.

If you frequently need to send/receive files in .xlsx or .xls format then you are better off with Excel or one of its clones like LibreOffice.

SG

In my experience it opens showing the last thing selected, (cell, sheet, shape, or whatever it was) just where you left off.