Numbers Crashing on Sierra

Question

Level 1

7 points

Numbers Crashing on Sierra

I'm running Numbers 3.6.2 on macOS Sierra Build 16A304a (Public Beta 6) on a mid-2010 MacBook 2.4GHz Core 2 Duo with 8GB RAM.

I have an Expenses spreadsheet where, as the name suggests, allows me to input all my expenses for my different bank accounts. Daily, weekly and monthly totals are calculated within the same sheet and on another sheet in the same file I have a chart of account balance vs time, so whenever I enter a value in the Expenses sheet a bunch of calculations are completed. Since upgrading to Sierra Numbers has been crashing (on this spreadsheet only) when:

I don't save the document after every single cell I edit
I wait too long to save after editing a cell - typically 5-10 seconds
Take more than 2-3 seconds to edit a cell

This is extremely frustrating and results in numerous crashes per minute. Please help because I use this spreadsheet every day 😟

Many thanks!

Posted on Sep 8, 2016 2:34 AM

Reply

Answer 1

Jul 5, 2017 1:55 PM in response to Csound1

EtreCheck version: 3.4 (420)

Report generated 2017-07-05 21:51:46

Download EtreCheck from https://etrecheck.com

Runtime: 4:00

Performance: Good

Click the [Lookup] links for more information from Apple Support Communities.

Click the [Details] links for more information about that line.

Problem: Apps are crashing

Description:

Numbers and Pages applications crash when editing takes place

Hardware Information:ⓘ

iMac (21.5-inch, Late 2013)

[Technical Specifications] - [User Guide] - [Warranty & Service]

iMac - model: iMac14,1

1 2.7 GHz Intel Core i5 (i5-4570R) CPU: 4-core

8 GB RAM Upgradeable - [Instructions]

BANK 0/DIMM0

4 GB DDR3 1600 MHz ok

BANK 1/DIMM0

4 GB DDR3 1600 MHz ok

Bluetooth: Good - Handoff/Airdrop2 supported

Wireless:
en1: 802.11 a/b/g/n/ac

iCloud Quota: 3.09 GB available

Video Information:ⓘ

Intel Iris Pro - VRAM: 1536 MB

iMac 1920 x 1080

Disk Information:ⓘ

APPLE HDD HTS541010A9E662 disk0: (1 TB) (Rotational)

[Show SMART report]

EFI (disk0s1 - MS-DOS FAT32) <not mounted>
[EFI]: 210 MB

Macintosh HD (disk0s2 - Journaled HFS+) /
[Startup]: 999.35 GB (188.28 GB free)

Recovery HD (disk0s3 - Journaled HFS+) <not mounted>
[Recovery]: 650 MB

USB Information:ⓘ

USB30Bus

Apple Inc. BRCM20702 Hub

Apple Inc. Bluetooth USB Host Controller

Apple Inc. FaceTime HD Camera (Built-in)

Canon MG5700 series

Thunderbolt Information:ⓘ

Apple Inc. thunderbolt_bus

System Software:ⓘ

macOS Sierra
10.12.5 (16F73) - Time since boot: about 15 hours

Gatekeeper:ⓘ

Mac App Store and identified developers

Kernel Extensions:ⓘ

/Library/Extensions

[not loaded] com.seagate.driver.PowSecDriverCore (5.2.7 (26995) - SDK 10.4) [Lookup]

/Library/Extensions/Seagate Storage Driver.kext/Contents/PlugIns

[not loaded] com.seagate.driver.PowSecLeafDriver_10_4 (5.2.7 (26995) - SDK 10.4) [Lookup]

[not loaded] com.seagate.driver.PowSecLeafDriver_10_5 (5.2.7 (26995) - SDK 10.5) [Lookup]

[not loaded] com.seagate.driver.SeagateDriveIcons (5.2.7 (26995) - SDK 10.4) [Lookup]

System Launch Agents:ⓘ

[not loaded] 7 Apple tasks

[loaded] 177 Apple tasks

[running] 98 Apple tasks

System Launch Daemons:ⓘ

[not loaded] 40 Apple tasks

[loaded] 175 Apple tasks

[running] 103 Apple tasks

Launch Agents:ⓘ

[not loaded] com.adobe.AAM.Updater-1.0.plist (Adobe Systems, Inc. - installed 2015-01-18) [Lookup]

[loaded] com.google.keystone.agent.plist (Google, Inc. - installed 2017-03-29) [Lookup]

Launch Daemons:ⓘ

[loaded] com.adobe.fpsaud.plist (? 2afb3af7 9b06641b - installed 2017-06-14) [Lookup]

[loaded] com.google.keystone.daemon.plist (Google, Inc. - installed 2017-04-13) [Lookup]

[running] com.seagate.TBDecorator.plist (? 595582c 212092b1 - installed 2015-11-02) [Lookup]

[loaded] jp.co.canon.MasterInstaller.plist (Canon Inc. - installed 2016-09-30) [Lookup]

User Launch Agents:ⓘ

[loaded] com.adobe.AAM.Updater-1.0.plist (Adobe Systems, Inc. - installed 2015-01-18) [Lookup]

[loaded] com.skype.skype.shareagent.plist (Skype Communications S.a.r.l - installed 2017-06-10) [Lookup]

User Login Items:ⓘ

iTunesHelper Application (Apple, Inc. - installed 2017-05-15)

(/Applications/iTunes.app/Contents/MacOS/iTunesHelper.app)

Mail Application

(/Applications/Mail.app)

Internet Plug-ins:ⓘ

FlashPlayer-10.6: 26.0.0.131 (installed 2017-06-16) [Lookup]

QuickTime Plugin: 7.7.3 (installed 2017-07-04)

Flash Player: 26.0.0.131 (installed 2017-06-16) [Lookup]

EPPEX Plugin: 10.0 (installed 2016-05-23) [Lookup]

OfficeLiveBrowserPlugin: 12.3.6 (installed 2015-01-24) [Lookup]

Google Earth Web Plug-in: 7.1 (installed 2015-07-19) [Lookup]

PepperFlashPlayer: 26.0.0.131 (installed 2017-06-16) [Lookup]

Silverlight: 5.1.30514.0 (installed 2015-04-10) [Lookup]

3rd Party Preference Panes:ⓘ

Flash Player (installed 2017-06-14) [Lookup]

Time Machine:ⓘ

Time Machine not configured!

Top Processes by CPU:ⓘ

2%
WindowServer

2%
kernel_task

0%
fontd

0%
Google Chrome Helper

Top Processes by Memory:ⓘ

751 MB kernel_task

651 MB iMovie

206 MB Mail

200 MB Google Chrome

168 MB WindowServer

Top Processes by Network Use:ⓘ

Input Output Process name

13 MB 811 KB Mail

673 KB 382 KB mDNSResponder

224 KB 435 KB jp.co.canon.ij.scanutility2.CIJSUAgent

56 KB 31 KB netbiosd

14 KB 66 KB apsd

Top Processes by Energy Use:ⓘ

4.86 WindowServer

0.18 launchd

0.12 Google Chrome

0.12 Microsoft Database Daemon

Virtual Memory Information:ⓘ

2.42 GB
Available RAM

86 MB Free RAM

5.58 GB
Used RAM

2.34 GB
Cached files

256 KB Swap Used

Software installs:ⓘ

Adobe Flash Player:
(installed 2017-06-13)

Adobe Pepper Flash Player:
(installed 2017-06-13)

Adobe Flash Player:
(installed 2017-06-16)

Adobe Pepper Flash Player:
(installed 2017-06-16)

Install information may not be complete.

Diagnostics Information:ⓘ

2017-07-05 06:03:22 Numbers.app Crash [Open]

Cause: Crashing on exception: -[__NSCFConstantString characterAtIndex:]: Range or index out of bounds

2017-07-04 23:36:30 Pages.app Crash [Open]

Cause: Crashing on exception: -[__NSCFConstantString characterAtIndex:]: Range or index out of bounds

Reply

Answer 2

Jul 5, 2017 1:26 PM in response to -GDS-

This crashing experience when editing a Numbers spreadsheet happens and I don't use beta versions of software and I have updated software. This is disgraceful that Mac software, Numbers, crashes on Sierra OS. Tony Jordan

Reply

Answer 3

Jul 5, 2017 10:57 PM in response to SGIII

Many thanks, that seems to have worked, no crashes in the 3 times I have used Numbers since last evening. Would it be something that should automatically take place as part of Apple updates? Thank you again. Tony Jordan

Reply

Answer 4

SGIII

Level 8

37,568 points

Jul 5, 2017 1:58 PM in response to jordant1950

There's a bug that will crash Numbers when some region settings are left blank. Make sure you have a value in all of these in System Preferences > Language & Region > Advanced...

SG

Reply

Answer 5

KiltedTim

Level 10

227,544 points

Sep 8, 2016 2:36 AM in response to -GDS-

Beta software can not be discussed in the public forums.

You should not be running beta software on a production system. It's intended for testing.

Reply

Answer 6

-GDS- Author

Level 1

7 points

Sep 8, 2016 2:40 AM in response to KiltedTim

Aw 😟 Is there any place I can get help for Sierra? I've already committed to Sierra on my main computer so I'd rather not go back. Alternatively, would you be able to help with the issue, under the assumption that it's an OS version independent problem?

Reply

Answer 7

Sep 8, 2016 5:13 AM in response to -GDS-

You should NEVER deploy a public beta for use on a mission critical machine. Move the document to another machine and modify the document on that other machine running a stable OS

Since you were not having these problems until you change OS it is logical to conclude the OS is, in fact, then problem. So no-one here can assist.

Reply

Answer 8

Csound1

Level 9

60,063 points

Sep 8, 2016 5:15 AM in response to -GDS-

Wayne has clearly told you that your problem can not be addressed here, that is not going to change no matter how many times you ask. Use a machine without a beta operating system if you want reliability.

Reply

Answer 9

Sep 8, 2016 6:19 AM in response to -GDS-

The other idea I have is to move the document to iCloud and use the web interface until you can use Numbers on Sierra reliably

Reply

Answer 10

-GDS- Author

Level 1

7 points

Sep 8, 2016 2:56 PM in response to Wayne Contello

I'll try the Numbers web interface until the issue gets resolved or when I can post here after the final release - thanks for the idea Wayne!

Just to clarify, I know it's not recommended to install macOS Sierra on your main machine but I chose to and make regular backups. Numbers crashing has been the only problem I've had with the OS over the last month and a half and I'm satisfied otherwise. I'll think more carefully next time I get presented with the opportunity to test beta software. Thanks for the tips.

Csound1, you essentially reiterated what Wayne and KiltedTim said before you, adding nothing to the conversation and sounding condescending in the process which I didn't appreciate - I didn't even ask again between Wayne's first post and yours so I'm not sure what you're on about.

Reply