Bug 33671 - Editing -- Paste Into Cells Falsely Reports
Summary: Editing -- Paste Into Cells Falsely Reports
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.0 release
Hardware: All All
: medium normal
Assignee: Kohei Yoshida
URL:
Whiteboard: target:3.4
Keywords:
: 34225 (view as bug list)
Depends on:
Blocks:
 
Reported: 2011-01-28 13:11 UTC by J William Cupp
Modified: 2011-03-22 10:43 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Falsely presented warning message (128.91 KB, image/png)
2011-01-28 13:11 UTC, J William Cupp
Details

Note You need to log in before you can comment on or make changes to this bug.
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.