How to specify an endless range for a pivot table source in Calc?

[tyebillion]

I can create a pivot table with an explicit range for the source no problem:

$Income.$A$1:$D$7

But when I try to create a pivot table with an endless range for the source e.g. all rows after the header, the source text goes white and the pivot table is not correct:

$Income.$A$1:$D

How can I specify an endless range for the source without including blank rows?

[mariosv]

Introducing $Income.$A:$D transforms the reference on the source range to $Income.$A$1:$D$1048576 maximum range for rows, seems that pivot table doesn’t keep columns address, in any case marking the option to ignore empty rows, seems that help a bit with the speed.

[tyebillion]

I’m guessing that you are not recommending this method?