Bug 149152 - I cannot insert and display a pdf into a Calc spreadsheet.
Summary: I cannot insert and display a pdf into a Calc spreadsheet.
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.6.2 release
Hardware: x86-64 (AMD64) Linux (All)
: high major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Regressions-1024plus-Columns
  Show dependency treegraph
 
Reported: 2022-05-18 12:25 UTC by Hud Quistorff
Modified: 2022-06-01 13:46 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Hud Quistorff 2022-05-18 12:25:40 UTC
Description:
Hi,

I’m currently running Version 7.2.6.2 of LibreOffice Calc on Fedora 35.

In Calc, I have a list of items and quantities. Separately, I have a sketch in pdf format. Now, I’m trying to insert that pdf into the Calc spreadsheet so that the list, quantities, and sketch can be printed on one page.

However, when I try to insert the pdf (or any pdf), all I get is an anchor icon at my current cell. No sketch; just an anchor icon. And, no matter what I do next, the anchor disappears.

After posting this problem to the help forum, mikekaganski suggested that used Format | Image | Fit to Cell Size.

When I did that, the anchor was replaced with a grip.

When I tried to drag the grip, Calc crashed.

Thank you,

Steps to Reproduce:
1. Insert a pdf into Calc spreadsheet
2. Select Format | Image | Fit to Cell Size
3. Calc crashes

Actual Results:
Hi,

I’m currently running Version 7.2.6.2 of LibreOffice Calc on Fedora 35.

In Calc, I have a list of items and quantities. Separately, I have a sketch in pdf format. Now, I’m trying to insert that pdf into the Calc spreadsheet so that the list, quantities, and sketch can be printed on one page.

However, when I try to insert the pdf (or any pdf), all I get is an anchor icon at my current cell. No sketch; just an anchor icon. And, no matter what I do next, the anchor disappears.

After posting this problem to the help forum, mikekaganski suggested that used Format | Image | Fit to Cell Size.

When I did that, the anchor was replaced with a grip.

When I tried to drag the grip, Calc crashed.

Thank you,

Expected Results:
After inserting a pdf into a Calc spreadsheet, I would expect to see a pdf in that spreadsheet like I did 2 years ago with an earlier version of LibreOffice. Back then, I used whichever version was available with Ubuntu 20.04.


Reproducible: Always


User Profile Reset: No



Additional Info:
N/A
Comment 1 V Stuart Foote 2022-05-18 13:29:20 UTC
Can not confirm on recent 7.4 master on Windows

A PDF inserted as image (e.g. the first page of the PDF) is inserted at its full size, anchored to the Calc sheet's cell with focus.  The 'anchor' is present in the cell--but the image is as large as it needed.

Selecting the image with a click shows just a corner 'grip' in the cell--it is not a resize. But then with the image focused, the image will respond to the 'Fit to Cell Size' (.uno:FitCellSize) action, shrinking down so that all 6 'grips' fit.

With the image focused/selected, a right-mouse context menu provides the 'Fit to Cell Size' action, as does the Standard menu's Format -> Image menu.

The Cell row height and column width can be adjusted larger before the insert or after the image insert.
Comment 2 Timur 2022-05-31 15:46:02 UTC
(In reply to Hud Quistorff from comment #0)
> In Linux, when I try to insert the pdf (or any pdf), all I get is an anchor
> icon at my current cell. No sketch; just an anchor icon. And, no matter what
> I do next, the anchor disappears.

This is the bug, Insert-Image doesn't work in 7.2 and 7.3, repro Linux, not Windows. 
But it does in 7.4+. Yo may test with daily master. 
It would be useful to know which is the original bug.
Comment 3 Xisco Faulí 2022-05-31 16:27:39 UTC
(In reply to Timur from comment #2)
> (In reply to Hud Quistorff from comment #0)
> > In Linux, when I try to insert the pdf (or any pdf), all I get is an anchor
> > icon at my current cell. No sketch; just an anchor icon. And, no matter what
> > I do next, the anchor disappears.
> 
> This is the bug, Insert-Image doesn't work in 7.2 and 7.3, repro Linux, not
> Windows. 
> But it does in 7.4+. Yo may test with daily master. 
> It would be useful to know which is the original bug.

it works for me 

Version: 7.2.0.0.alpha1+ / LibreOffice Community
Build ID: ff2ba77f22b2e96f96f5537aec1705956b47583d
CPU threads: 8; OS: Linux 5.10; UI render: default; VCL: gtk3
Locale: es-ES (es_ES.UTF-8); UI: en-US
Calc: threaded

could you please bisect when it got fixed for you ?
Comment 4 Hud Quistorff 2022-06-01 04:39:00 UTC
With version 7.2.6.2, I could not insert a pdf into a Calc spreadsheet.

With version 7.3.3.2, mission accomplished!
Comment 5 Timur 2022-06-01 08:15:44 UTC
7.4     
source cf8408bfcbaca2998d47a56df9f1dc6f3cb98b0e
author	Luboš Luňák <l.lunak@collabora.com>	Fri Feb 04 21:59:05 2022 
make the large-sheet maxrow value pow2-based and not pow10-based

I guess backported by c4, but my 7.3 didn't have it. 
Xisco, please update bibi repos.
Comment 6 Xisco Faulí 2022-06-01 08:17:17 UTC
(In reply to Timur from comment #5)
> 7.4     
> source cf8408bfcbaca2998d47a56df9f1dc6f3cb98b0e
> author	Luboš Luňák <l.lunak@collabora.com>	Fri Feb 04 21:59:05 2022 
> make the large-sheet maxrow value pow2-based and not pow10-based
> 
> I guess backported by c4, but my 7.3 didn't have it. 
> Xisco, please update bibi repos.

are you using jumbo sheets in 7.3 ?
Comment 7 Timur 2022-06-01 08:24:46 UTC
(In reply to Xisco Faulí from comment #6)
> are you using jumbo sheets in 7.3 ?
That's it. 
So I set to block bug 133619.
Adding Luboš since his fix didn't have other bug where commit is mentioned.