Bug 160395

Summary:	PIVOTTABLE: Result Field can be deleted with the Del key
Product:	LibreOffice	Reporter:	Michael Otto <Micha.Otto.de>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	normal	CC:	libreoffice-bugs, stephane.guillou
Priority:	medium
Version:	Inherited From OOo
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	103381
Attachments:	a Pivot Table, no matter which (here: one with group Spiel2, and one where to group some dates)

Description Michael Otto 2024-03-27 12:43:54 UTC

Created attachment 193342 [details]
a Pivot Table, no matter which (here: one with group Spiel2, and one where to group some dates)

+++ This bug was initially created as a clone of Bug #160393 +++

PRECONDITION:
the problem is seen with any Pivot Table

PROBLEM DESCRITION:
Result Fields are write protected, you even can not change into an empty cell, 
but with the Del key, you can delete the entry

DETAILS:
in any Result Field you can delete the entry with the Del key


Version: 24.2.1.2 (X86_64) / LibreOffice Community
Build ID: db4def46b0453cc22e2d0305797cf981b68ef5ac
CPU threads: 2; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-US (de_DE.UTF-8); UI: en-US
Calc: threaded

Comment 1 Stéphane Guillou (stragu) 2024-04-12 15:20:47 UTC

Reproduced in:

Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: d5dcc9de8ebce5d14be89ddeb6606ef0aeebf7a9
CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: CL threaded

Backspace can also be used.

Same in OOo 3.3 -> inherited.

I agree that if other edits are blocked with the message "You cannot change this part of the pivot table", emptying the cell should not be allowed either.

Surprised I could not find a duplicate.