Bug 33671

Summary: Editing -- Paste Into Cells Falsely Reports
Product: LibreOffice Reporter: J William Cupp <cupp>
Component: CalcAssignee: Kohei Yoshida <kohei>
Status: RESOLVED FIXED    
Severity: normal CC: jbfaure, kohei, LibreOffice
Priority: medium    
Version: 3.3.0 release   
Hardware: All   
OS: All   
See Also: https://bugs.freedesktop.org/show_bug.cgi?id=34225
Whiteboard: target:3.4
Crash report or crash signature: Regression By:
Attachments: Falsely presented warning message

Description J William Cupp 2011-01-28 13:11:19 UTC
Created attachment 42671 [details]
Falsely presented warning message

When pasting the contents of the clipboard into any cell, the warning about pasting and possibly overwriting data shows every time.  If a cell is initially empty, pasting from the clipboard cannot overwrite data, and so there should not be a warning message.

See attached screenshot.
Comment 1 Jean-Baptiste Faure 2011-02-02 21:28:41 UTC
Hi,

You have probably some formatting (conditionnaly formatting) in your empty cell.

I think this warning message should be sent only when there is real data (value or formula) in the cell.
 
Kohei: what do you about that?

Best regards. JBF
Comment 2 J William Cupp 2011-02-04 03:06:51 UTC
The problem occurs even after a cell has been emptied [select - <Backspace> - "delete all" - <OK>].

If there is conditional formatting remaining in the cell after that, then it probably still should not give a "overwrite contents" warning.
Comment 3 Kohei Yoshida 2011-02-08 20:00:44 UTC
Yes, that should not warn about the overwrite.
Comment 4 Kohei Yoshida 2011-02-08 20:08:13 UTC
I have a pretty good idea why this is so.  BTW the same thing won't happen when the destination only has cell background colors.  This only happens with cells with borders.
Comment 5 John 2011-02-28 13:51:28 UTC
*** Bug 34225 has been marked as a duplicate of this bug. ***
Comment 6 andréb 2011-03-06 19:27:42 UTC
(In reply to comment #4)
> I have a pretty good idea why this is so.  BTW the same thing won't happen when
> the destination only has cell background colors.  This only happens with cells
> with borders.

I wondered why it affected only _some_ empty formatted cells.
I just confirmed, it seems to only affect border formatted cells.
Comment 7 Kohei Yoshida 2011-03-22 10:43:38 UTC
Fixed on master for 3.4.