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: Spreadsheet (show other bugs)
Version: 3.3.0 release
Hardware: All All
: medium normal
Assignee: Kohei Yoshida (inactive)
QA Contact:
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:
i915 platform:
i915 features:


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

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.