[Libreoffice-ux-advise] [Bug 92419] delete referenced cell - raise error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92419

Heiko Tietze  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |WONTFIX
   Keywords|needsUXEval |
 CC|libreoffice-ux-advise@lists |tietze.he...@gmail.com
   |.freedesktop.org|

--- Comment #21 from Heiko Tietze  ---
There is a general disagreement to your idea. I would appreciate a very
unobtrusive method of communication like via statusbar. But since we don't have
this we communicate per messagebox or infobar not even a balloon tip, and many
other situation would need to inform the user, the proposal is a WONTFIX.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

[Libreoffice-ux-advise] [Bug 92419] delete referenced cell - raise error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92419

Cor Nouws  changed:

   What|Removed |Added

Version|4.4.3.2 release |Inherited From OOo
 CC||c...@nouenoff.nl

--- Comment #20 from Cor Nouws  ---
(In reply to Ferdinand from comment #0)
> if a referenced cell is deleted (delete row/column) the referencing cells
> show #REF
> if this cell is on a different table or out of view it will not be
> recognized by the user IN TIME !

A user deleting data in a spreadsheet should know what he/she is doing.
I expect more situations can be found to 'help' users. I wouldn't start along
this path.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

[Libreoffice-ux-advise] [Bug 92419] delete referenced cell - raise error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92419

Xisco Faulí  changed:

   What|Removed |Added

 CC||xiscofa...@libreoffice.org
Version|5.0.3.2 release |4.4.3.2 release

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

[Libreoffice-ux-advise] [Bug 92419] delete referenced cell - raise error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92419

--- Comment #19 from Buovjaga  ---
(In reply to Ferdinand from comment #18)
> Sorry guys,
> 
> I am a (python, sql) developer myself and I am aware of the danger of
> deleting referenced cells - a widely missing feature in all spreadsheets I
> know.
> 
> The problems hits less experienced users who should be protected against
> such "stupid" errors.

Then you can create a Python extension for it.

If we implemented this in core, then we would get dozens of bug reports
complaining about performance worsening on deleting cell contents.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

[Libreoffice-ux-advise] [Bug 92419] delete referenced cell - raise error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92419

--- Comment #18 from Ferdinand  ---
Sorry guys,

I am a (python, sql) developer myself and I am aware of the danger of deleting
referenced cells - a widely missing feature in all spreadsheets I know.

The problems hits less experienced users who should be protected against such
"stupid" errors.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

[Libreoffice-ux-advise] [Bug 92419] delete referenced cell - raise error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92419

--- Comment #17 from Buovjaga  ---
(In reply to Ferdinand from comment #16) 
> if in addition to the error in the cell a pop up is triggered with the undo
> option it would solve the problem without noticeable delay. 

Ok, I think you just moved the goalposts in such a way that this could now be
the job of your own special extension. Eike, do you agree? Then we could close
this and Ferdinand can find someone to develop such an extension for him.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

[Libreoffice-ux-advise] [Bug 92419] delete referenced cell - raise error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92419

--- Comment #16 from Ferdinand  ---
Sorry I do not understand this reasoning in comment 15

the referenced cell shows the error immediately (given automatic calc is on) 

if in addition to the error in the cell a pop up is triggered with the undo
option it would solve the problem without noticeable delay. 

just my 2c

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

[Libreoffice-ux-advise] [Bug 92419] delete referenced cell - raise error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92419

--- Comment #15 from Eike Rathke  ---
As this is not set to resolved fix it is not implemented, no.

First, we certainly do not want to scan the entire document (or broadcast and
collect a new before-deletion hint) whether a formula expression references a
to be deleted cell or not for each cell/column/row to be deleted. Second, an
expression could also reference a cell/range not only in cell formulas but also
in named expressions, validation, conditional formatting, ...  We could
significantly slow things down with such an approach, so anything like that
should be optional not activated by default, which then again doesn't help an
inexperienced user either. Plus, implementation would be cumbersome.

In short, I'm not a friend of this.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

[Libreoffice-ux-advise] [Bug 92419] delete referenced cell - raise error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92419

--- Comment #14 from Ferdinand  ---
Hi 
I just want to recall the necessity to handle this problem as it is still not
addressed after 2 years in 5.3.3.2.

please will this feature be made available in 5.4 as suggested in comment 6?

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

[Libreoffice-ux-advise] [Bug 92419] delete referenced cell - raise error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92419

--- Comment #12 from V Stuart Foote  ---
(In reply to m.a.riosv from comment #9)
>...

> To not create a new option, could be associated with
> Menu/Tools/Options/LibreOffice calc/General - Show overwrite warning when
> pasting data.

Not sure that checkbox would link the right behavior. The overwrite warning
there is:

"You are pasting data into cells that already contain data. Do you really want
to overwrite the existing data."

But here we are deleting cell(s) that have referenced linkages--and should be
aware of what happens to values in those referenced cells?  Warning should
probably be an alert that action would delete cell(s) with active reference(s).

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

[Libreoffice-ux-advise] [Bug 92419] delete referenced cell - raise error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92419

--- Comment #10 from Ferdinand  ---
pls look at the package manager
you can not delete a package with depending packages. 
you must "force" it and THEN it's your responsibility if you get an
inconsistent state.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

[Libreoffice-ux-advise] [Bug 92419] delete referenced cell - raise error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92419

--- Comment #8 from Ferdinand  ---
sorry guys, data loss is always a major bug

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

[Libreoffice-ux-advise] [Bug 92419] delete referenced cell - raise error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92419

V Stuart Foote  changed:

   What|Removed |Added

 CC||er...@redhat.com,
   ||kohei.yosh...@collabora.com
   ||, vstuart.fo...@utsa.edu

--- Comment #6 from V Stuart Foote  ---
@Eike, Kohei any opinion on this?

Would it be a legitimate alert to warn users of potential for data loss?

And would implementing something like this be too much of a nag if always
enabled, better to just provide as an configurable alert? And pick a default.

Probably no interest as a 5.3 late feature, but seems to have merit for 5.4.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

[Libreoffice-ux-advise] [Bug 92419] delete referenced cell - raise error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92419

--- Comment #4 from Ferdinand  ---
unfortunately still not fixed in 5.2.1.2

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

[Libreoffice-ux-advise] [Bug 92419] delete referenced cell - raise error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92419

Ferdinand  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
Version|4.4.3.2 release |5.0.3.2 release
 Ever confirmed|0   |1

--- Comment #2 from Ferdinand  ---
Hi, any progress on this ?

can't be a big issue to pop up a window as in the referencing cell a REF error
is shown.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise

[Libreoffice-ux-advise] [Bug 92419] delete referenced cell - raise error

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=92419

Beluga todven...@suomi24.fi changed:

   What|Removed |Added

 CC||libreoffice-ux-advise@lists
   ||.freedesktop.org,
   ||todven...@suomi24.fi
  Component|Calc|ux-advise
   Severity|major   |enhancement

--- Comment #1 from Beluga todven...@suomi24.fi ---
UX plz help.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Libreoffice-ux-advise mailing list
Libreoffice-ux-advise@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise