Columns added to AutoFilter table don't sort together with existing columns

[wekesa]

I got rid of Microsoft Office subscription and decided to rough it learning LibreOffice.

I ran into a minor hiccup. There are several documents created in Excel that I constantly access. They contain sortable tables created via Insert > Table, and I realized that this is called AutoFilter in Calc. Everything is well and good until I try to append new columns to the existing table. Usually, Excel auto-formats new columns with the same sortable function, and they sort with the rest of the table. When I do this in Calc, the new columns appear to be disconnected with the original columns. What am I doing wrong here?

The workaround I found so far is to disable AutoFilter on original tab in Calc, select old table range, copy, paste to new tab, add new columns, select the new range in the new tab, enable AutoFilter on the newly-created table. What a pain! Can you please let me know if there is a better way of doing this?

[mariosv]

Maybe the options Menu/Tools/Options/LibreOffice calc/General - Expand formatting/Expand references when new columns/rows are inserted, when the columns are added.

[wekesa]

Another epic advice! Thank you!

[erAck]

While that usually works, it also tends to get in the way in cases one forgot about it… YMMV… toggling it on a case by case basis might be best.

[erAck]

AutoFilter is just a functionality on cell ranges (one anonymous per sheet) or so called named database ranges. Those table ranges imported should show up as database ranges under Data → Define Range…

If columns are added left or right of the original range then the database range definition may have to be adapted. Inserting columns within the range should adjust the database range automatically.

[wekesa]

Thank you so much! Worked like a charm!