Bug 169433 - Calc: Data - Form... The Data Form should modify the data source of a pivot table.
Summary: Calc: Data - Form... The Data Form should modify the data source of a pivot t...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.8.3.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Pivot-Table
  Show dependency tree / graph
 
Reported: 2025-11-14 08:37 UTC by gmolleda
Modified: 2026-01-22 08:36 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description gmolleda 2025-11-14 08:37:19 UTC 
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.
Comment 1 m_a_riosv 2025-11-14 23:07:56 UTC 
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
Comment 2 Buovjaga 2026-01-22 07:17:57 UTC 
Sounds like per comment 1 we should set to NEW. However, gmolleda: please copy and paste here the content of your Help - About (LibreOffice - About on macOS) by clicking the copy button. This allows us to know more about your system.
Comment 3 gmolleda 2026-01-22 08:10:01 UTC 
(In reply to Buovjaga from comment #2)
> Sounds like per comment 1 we should set to NEW. However, gmolleda: please
> copy and paste here the content of your Help - About (LibreOffice - About on
> macOS) by clicking the copy button. This allows us to know more about your
> system.

Version: 25.8.3.2 (X86_64)
Build ID: 8ca8d55c161d602844f5428fa4b58097424e324e
CPU threads: 4; OS: Linux 6.11; UI render: default; VCL: gtk3
Locale: es-ES (es_ES.UTF-8); UI: es-ES
Calc: threaded