When adding records to a range using the Data - Form... menu, if that range is the data source of a pivot table, the Data Form menu should allow expanding the pivot table range when inserting new records, and that form should also have buttons to go to the first and last record.
I think there is a bug, because the option: Menu>Tools>Options>LibreOffice Calc>General - Expand references when insert rows/columns. It is not activated by Menu>Data>Form. So neither a pivot table nor any function/formula is updated, adding new data. Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 620(Build:0) CPU threads: 16; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: threaded