Unsupported formulas

I dont know of 1) any way to identify the offending cells nor 2) a list of formulas that are not supported.

however, I do know that Array Formulas are not supported (the ones you enter by pressing CTRL-Shift-Enter together) nor are pivot tables. These all will be converted into values. There are many statistical functions that are not supported. and anything you had to load an add-in for would not be.

Hope this gives you a starting point to determine what you are missing.

Jason

I would also look in cells you know were calculations to see it they have a formula or value.

You could run a script to quickly identify cells that contain formulas (so you can spot the ones that should have formulas but don't).

This one below turns the text in the cells with formulas red.

1. Copy-paste into Script Editor (in Applications > Utilities)
2. Click anywhere in the document
3. Click the triangle 'Run' button.

SG

tell application "Numbers"

tell document 1

repeat with s in sheets

repeat with t in s's tables

repeat with c in t's cells

if c's formula is not missing value then

set c's text color to "red"

end if

end repeat

end repeat

end repeat

end tell

end tell

Hi SG,

That is neat. I would prefer to make the background color a nice yellow though.

tell application "Numbers"

tell document 1

repeat with s in sheets

repeat with t in s's tables

repeat with c in t's cells

if c's formula is not missing value then

set c's background color to {65535, 65535, 0}

end if

end repeat

end repeat

end repeat

end tell

end tell

quinn

ps how do I get free of this indent?

Thanks quinn. I've been trying to figure out a way, after reconstructing formulas that didn't import from Excel, to have a script set background color back to the way it was, in my case usually transparent (i.e. no background). But in AppleScript a cell with no background has a background color of missing value and as far as I can tell you can't set background color to missing value.

SG

Hi SG,

It looks to me like the only background fill types you can se to "no fill" are shapes and text. Does not help you.

quinn

NarcisMG wrote:

Thank you. How do I tell where is my document? for instance the document is called 1.xls and is in my Desktop

The telldocument 1 simply means to address the frontmost open document. So with your document open, just follow the three steps in the post upthread. It doesn't matter to the script where you save it. It just needs to be open, and you need to have clicked somewhere in it to bring it to the "front".

SG

Thanks for posting about the blue triangles. Here's an example:

SG