Issue 85707 - hyperlinks in cells affecting graphic positioning in calc
Summary: hyperlinks in cells affecting graphic positioning in calc
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 680m242
Hardware: All Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2008-01-30 08:43 UTC by caolanm
Modified: 2017-05-20 11:11 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

ok example (115.42 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-01-30 08:44 UTC, caolanm
no flags Details
not ok (114.66 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-01-30 08:45 UTC, caolanm
no flags Details
a side-by-side screenshot (38.98 KB, image/png)
2008-01-30 08:48 UTC, caolanm
no flags Details
experiment with line height (4.68 KB, patch)
2008-01-31 12:52 UTC, caolanm
no flags Details | Diff

Note You need to log in before you can comment on or make changes to this issue.
Description caolanm 2008-01-30 08:43:55 UTC
Attached is ok.ods and notok.ods (hand edited xml) Both documents have a graphic
anchored to cell in each row. In ok.ods there are no hyperlinks in any cell and
the graphics are positioned on screen perfectly. In notok.ods is the exact same
document except with hyperlinks placed in the last few rows. In notok.ods all
the graphics are misplaced afterwards :-(

If I load ok.ods and then copy the hyperlinks from notok.ods then ok.ods remains
perfectly ok on screen, *but* if I then save and reload it the graphics become
misplaced again.
Comment 1 caolanm 2008-01-30 08:44:39 UTC
Created attachment 51248 [details]
ok example
Comment 2 caolanm 2008-01-30 08:45:16 UTC
Created attachment 51249 [details]
not ok
Comment 3 caolanm 2008-01-30 08:48:50 UTC
Created attachment 51250 [details]
a side-by-side screenshot
Comment 4 caolanm 2008-01-30 09:17:23 UTC
Maybe this is related to issue 8049 ?
Comment 5 niklas.nebel 2008-01-30 10:00:53 UTC
Yes, basically the same. The row heights are a bit different for the rows with
URLs (maybe that should be changed, so the effect wouldn't show in the example).
Comment 6 frank 2008-01-30 10:52:04 UTC
Hi Niklas,

as you had a closer look at this one I think it shoiuld be assigned to you.

Comment 7 caolanm 2008-01-31 12:52:08 UTC
Created attachment 51288 [details]
experiment with line height
Comment 8 caolanm 2008-01-31 12:57:36 UTC
I don't think I at all understand how calc determines the lineheight of a
non-editengine cell, e.g. if we end up using a EditEngine then for 10point Arial
we have in 100thmm

ascent 318, descent 79, intleading 53, outleading 0 -> line height of 397, i.e.

This is indeed the height that a EditEngine returns in column2.cxx from
EditEngine::GetTextHeight() and looks like a solidly derived figure to me, while
the calculations in lcl_GetAttribHeight very much confuse me, and to a much
lesser extent global.cxx and give lower figures.

e.g. to my naive eyes I'd have expected line heights to be derived something
like this attachment.
Comment 9 Marcus 2017-05-20 11:11:46 UTC
Reset assigne to the default "".