Bug 33671

Summary: Editing -- Paste Into Cells Falsely Reports
Product: LibreOffice Reporter: J William Cupp <cupp>
Component: SpreadsheetAssignee: Kohei Yoshida (inactive) <libreoffice>
Status: RESOLVED FIXED QA Contact:
Severity: normal    
Priority: medium CC: jbfaure, LibreOffice, libreoffice
Version: 3.3.0 release   
Hardware: All   
OS: All   
See Also: https://bugs.freedesktop.org/show_bug.cgi?id=34225
Whiteboard: target:3.4
i915 platform: i915 features:
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 (inactive) 2011-02-08 20:00:44 UTC
Yes, that should not warn about the overwrite.
Comment 4 Kohei Yoshida (inactive) 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 (inactive) 2011-03-22 10:43:38 UTC
Fixed on master for 3.4.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.