Can't add rows to a table

May you copy then paste the table in a new document ?

With a bit of luck it will behave correctly.

If it doesn't, change the private values then send the modified document to my maibox (click my blue name to get my address).

Of course, you may also try to open the document from an alternate user account.

Yvan KOENIG (VALLAURIS, France) lundi 30 avril 2012

iMac 21”5, i7, 2.8 GHz, 12 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.3

My Box account is : http://www.box.com/s/00qnssoyeq2xvc22ra4k

I was having the same problem. That's how I ended up here. But then it occured to me that I had filtered the table on a certain value. I reset the filter and all is well. It makes sense: you can't add to afiltered view because the new row wouldn't have the filtered value yet. And if it allowed a blank row you might enter a value contrary to the filter.

Mike

Mike,

You reminded me that I had filters on. - It is obvious - Now !

Thank you

Phil.

Mike - thanks for posting the solution! I ran into this same problem today and was baffled. Easy fix and a face palm moment at the same time. :-)

Thanks - for working this out. I felt it must be something I had already set but don't know how to find out what filter I have set so as to undo it. Can you help?

Hi Lavarcham,

Numbers 3

Table with no Filters

Filtering on Category (text is b)

To "undo" that Filter, go here:

and untick the Filters checkbox 🙂.

Regards,

Ian.

Thanks so much Ian for your clear advice with really made sense. I have been searching for the way to follow it and then the penny dropped as I noticed you are referring to Numbers doc. I should have been clearer and specified that my problem is with a table in Pages (it's my record of running since 2009) I have searched to find any reference to similar format re filters but it doesn't seem to exist. But thank you very much for trying to help.

Lavarcham

Hi Lavarcham,

No, I can't find a way to apply a Filter to a table in Pages.

Perhaps this will help to summarise a long Pages table.

Formula in B2 of the Summary table (and Fill Down)

=SUMIF(Stocktake::Fruit,A2,Stocktake::Count)

If SUMIF is not what you want, try COUNTIF.

Just an idea, and nothing to do with a record of running 😉.

The drawback of doing this in Pages is that you can't "hide" a table on another Sheet. A Pages document consists of a series of (umm...) pages.

Perhaps you could move the summary to its own page and print only that page?

Tested in Pages 5.6.2

Should work in Pages '09 (Pages 4).

Happy Paging!

Regards,

Ian.

Hi Ian

Again so helpful and clear thank you. And for interest I think I understand now why I couldn't add more rows, I believe that there must be a limit within pages to the number of rows that can be added within one table i.e. 999 And that is where I had got to. I have taken a simplistic route and begun another table within the same document. Far from sophisticated but it meets what I want for this record.

Nice talking to you and thanks again

Regards

Lavarcham

Hi Lavarcham,

a limit within pages to the number of rows that can be added within one table i.e. 999

I believe you are right

The Row stepper won't accept a value greater than 999.

Nice talking to you and thanks for these challenges.

Regards,

Ian.

For sure the filters...uncheck or remove them and it should work!

Fantastic! This was driving me crazy, then I saw your post and unchecked the 'Filter' checkbox in the sort/filter tool window and it worked!

Thank you!