I'm using iWork '09 but this situation may apply in later versions too.
In Numbers, when I add a row to the bottom of a table some of the formulas from the previous line get filled automatically to the new line. It seems to only be formulas but the thing is I can't work out what category of formulas, because some seem to propagate while others don't. An example of each:
Auto-filled to new row:
=VLOOKUP($ID 0023,$ID number:$Name,4,)
Not filled:
='M' 23+'U' 23
The above are in adjacent cells on the last row before the newly added one.
What exactly determines which formulas make it into the new row and which don't?
GS
Got a credit card? use our Credit Card & Finance Calculators
Thanks to Anonymous,bruncher,niord,gvonge,Shelford, for Donating to support the site
Apple Numbers query
-
- Lemon Quarter
- Posts: 4478
- Joined: November 8th, 2016, 11:14 pm
- Has thanked: 1626 times
- Been thanked: 1621 times
Return to “Technology - Computers, TV, Phones etc.”
Who is online
Users browsing this forum: No registered users and 9 guests