TablePress renumbering columns

Hi,

thanks for your post, and sorry for the trouble.

Do you mean the “Position” column? One nice way would be to add the formula

=ROW+1

into all cells in that column. This will then automatically print the correct number.

Regards,
Tobias

Hi Tobias,

Sorry, I don’t think I was clear enough. I want to insert new rows, then renumber all the rows in the table.

Also, where do I put the formula?

Hi,

no, I think I understood what you mean ??
There’s however no static way to renumber the rows in that column. You will have to use the formula. Just replace every number in column 1 with that

=ROW+1

formula and you will see that the numbers will reappear correctly when viewing the table.
This way, you can reorder or insert rows without having to manually adjust anything.

Regards,
Tobias

Thanks Tobias, I’ll try that.

I think I did it before by exporting the table into Excel and renumbering things there. Then I imported it back into TablePress. Unfortunately, when I export to Excel all my hyperlinks are destroyed.

Sorry to be a nuisance. I did what you said and now I have them all renumbered. Unfortunately, where I have added the new rows, everything has moved across one column to the left, so for those rows my ‘rating’ column is now in the place of the ‘title’ column and the ‘season’ column is now in the place of the ‘rating’ column. The numbers that now appear in the ‘title’ column are hyperlinks, and they work. You will see this in rows 9, 24, 41 and on through the table.

Hi,

I can’t reproduce that. I do see that the “Season” column is empty for some rows, but nothing has shifted to the left for me…

Regards,
Tobias

I fixed it. I had to add this to the html for the title links in the new rows: target="_parent" rel="noopener noreferrer"

No idea why that worked, but it did!

Thank you.

Hi,

no problem, you are very welcome! ?? Good to hear that this helped!

Best wishes,
Tobias

P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!