Bug 147543 - In a partially visible Calc OLE Object the vertical cell borders extend downward slightly
Summary: In a partially visible Calc OLE Object the vertical cell borders extend downw...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Draw (show other bugs)
Version:
(earliest affected)
6.0.0.3 release
Hardware: x86-64 (AMD64) All
: lowest trivial
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, regression
Depends on:
Blocks: OLE-Objects Regressions-borderline
  Show dependency treegraph
 
Reported: 2022-02-19 21:23 UTC by david_ashworth
Modified: 2024-01-29 10:07 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Draw file with embedded Calc - some rows hidden (7.45 KB, application/pdf)
2022-02-19 22:01 UTC, david_ashworth
Details
Draw file with OLE embedded table (17.10 KB, application/vnd.oasis.opendocument.graphics)
2022-02-21 10:59 UTC, david_ashworth
Details
Source Calc file to embed (10.64 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-12-14 14:58 UTC, david_ashworth
Details

Note You need to log in before you can comment on or make changes to this bug.
Description david_ashworth 2022-02-19 21:23:25 UTC

    
Comment 1 david_ashworth 2022-02-19 22:01:13 UTC
Created attachment 178397 [details]
Draw file with embedded Calc - some rows hidden
Comment 2 david_ashworth 2022-02-19 22:05:36 UTC
I created a table in Calc which had some cells with backgrounds and all cells with narrow borders.

Importing this as an OLE object into Draw showed 2 cosmetic errors.

1. When only some of the rows are shown the column borders extend a short distance below the bottom row.
This appears to apply only to importing into Draw and Impress, Write appears OK.

2. The background fill is up and to the left a small amount from the grid - see #135891
Comment 3 raal 2022-02-20 16:38:51 UTC
Hello,

Thank you for filing the bug. Please send us a sample document, as this makes it easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO', so please do change it back to 'UNCONFIRMED' once you have attached a document.
(Please note that the attachment will be public, remove any sensitive information before attaching it.)
How can I eliminate confidential data from a sample document?
https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F
Thank you
Comment 4 david_ashworth 2022-02-21 10:59:37 UTC
Created attachment 178428 [details]
Draw file with OLE embedded table

Sample Draw file attached. Embedded table showing only some rows.

Vertical lines below baseline visible.
Cell background offset visible as per #135891
Comment 5 Buovjaga 2022-12-14 10:45:45 UTC
(In reply to david_ashworth from comment #4)
> Created attachment 178428 [details]
> Draw file with OLE embedded table
> 
> Sample Draw file attached. Embedded table showing only some rows.

Can you also attach the Calc file, so we can test embedding it?

Set to NEEDINFO.
Change back to UNCONFIRMED after you have provided the document.
Comment 6 david_ashworth 2022-12-14 14:58:30 UTC
Created attachment 184146 [details]
Source Calc file to embed
Comment 7 Buovjaga 2022-12-14 18:57:47 UTC
Thanks for the Calc document, I found it was indeed necessary to have it for the testing.

(In reply to david_ashworth from comment #2)
> I created a table in Calc which had some cells with backgrounds and all
> cells with narrow borders.
> 
> Importing this as an OLE object into Draw showed 2 cosmetic errors.
> 
> 1. When only some of the rows are shown the column borders extend a short
> distance below the bottom row.
> This appears to apply only to importing into Draw and Impress, Write appears
> OK.

I tested this by inserting the Calc doc as OLE, double-clicking it to edit and changing the height, so only rows 1-4 were visible.

I bisected this with linux-64-6.0 and got this as the result https://git.libreoffice.org/core/commit/f839ea98181a1c6970fe25a82cf798dc151ed332
fix tdf#114934 borderline feature regressions

There is even a meta bug for it: bug 114934

The issue is really minor as even before the change, there was a very slight extension of the vertical borders (not seen on all zoom levels).

> 2. The background fill is up and to the left a small amount from the grid -
> see #135891

This is bug 99953 (found/confirmed by bisecting).
Comment 8 Thorsten Behrens (allotropia) 2024-01-29 10:07:40 UTC
Un-Ccing developer for the moment, old regression & very high workload.