Bug 74065 - FORMATTING: borders not removed when deleting lines
Summary: FORMATTING: borders not removed when deleting lines
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.3 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-01-26 05:10 UTC by Francois Marier
Modified: 2015-01-24 12:42 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Spreadsheet which demonstrates the problem (13.78 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-01-26 05:10 UTC, Francois Marier
Details
Screenshot that shows the end result of deleting colums and rows (92.62 KB, image/jpeg)
2014-01-26 05:10 UTC, Francois Marier
Details
Screenshot of the attached spreadsheet before any deletions (113.29 KB, image/jpeg)
2014-01-26 10:44 UTC, Francois Marier
Details
Video demonstrating the problem (1.81 MB, video/ogg)
2014-01-26 10:58 UTC, Francois Marier
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Francois Marier 2014-01-26 05:10:07 UTC
Created attachment 92794 [details]
Spreadsheet which demonstrates the problem

Steps to reproduce:

1. open attached spreadsheet
2. select columns G to M
3. right-click on the column headings and delete all selected columns
4. select lines 24 to 47
5. right-click on the line headings and delete all selected lines

Expected:

The borders that were in the delete columns and lines are gone.

Actual:

Deleting columns did clear the borders around the deleted cells, but the borders around the deleted rows are still there.
Comment 1 Francois Marier 2014-01-26 05:10:45 UTC
Created attachment 92795 [details]
Screenshot that shows the end result of deleting colums and rows
Comment 2 tommy27 2014-01-26 08:43:50 UTC
please post a comparative screenshot "pre" and "post"

I tried your instructions but I do not reproduce it under Win7 64bit (LO 4.1.4.2)
Comment 3 Francois Marier 2014-01-26 10:44:39 UTC
Created attachment 92805 [details]
Screenshot of the attached spreadsheet before any deletions
Comment 4 Francois Marier 2014-01-26 10:46:48 UTC
The two screenshots are the "before & after" of the steps in the bug description.

The exact version of LibreOffice (using the package from Debian sid) is:

  Version: 4.1.4.2
  Build ID: 410m0(Build:2)
Comment 5 Francois Marier 2014-01-26 10:58:11 UTC
Created attachment 92807 [details]
Video demonstrating the problem

Here's a short screencast of me opening the attached spreadsheet and following the steps.
Comment 6 tommy27 2014-01-26 23:17:54 UTC
thanks for the video.
now I reproduce it on Win7 with 4.1.4 and many older LibO releases up to 3.3.3 (I have no earlier 3.3.x versions to test) and with AOO 4.0.0 as well.

anyway the issue seems due to the fact that those borders are a kind of external frame superimposed over cells but it's not a real cell border.

try right clicking on it and you will see that that that frame can be moved where you want.

so basically you were thinking of deleting cell with borders but infact you were deleting cells without borders who had a "fake" border frame over them.

I mark this as RESOLVED NOTABUG
Comment 7 Francois Marier 2014-01-26 23:23:54 UTC
Ah you're quite right, there's an extra border floating above the spreadsheet in the left columns. I hadn't noticed that.

Sorry about the noise, but thanks very much for taking the time to look into it anyways.