[Libreoffice-bugs] [Bug 138356] CALC Hyperlink button text corrupted with part of an embedded graphic image

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=138356

--- Comment #9 from Colin <that.man.colin at gmail.com> ---
(In reply to Regina Henschel from comment #7)
> I have now inspected the attached file: The formal structure of the file is
> OK. But the buttons on 3. and 4. sheet have the form attribute
> "form:image-data" which should not be there. This attribute belongs to an
> image button ("form:image" in file source). But these are simple push
> buttons ("form:button" in file source).
> 
> To investigate further we need a step-by-step description, which
> _reproducible_ creates such buttons. Only if a developer can reproduce it,
> it is possible to fix, that such attribute is added to a push button.

If it's feasible to utilise the existing file then it should be a simple matter
to delete the three corrupt buttons and then simply recreate them using the
normal procedure for creating a hyperlink button. It would be an advantage to
note the existing links and re-use them.
If I remember correctly, the face text simply said "Source" which was entered
into the appropriate parameter at creation. 
It's then just a matter of opening the links a few times - I actually used them
to capture data which was then pasted into the appropriate places.
The corruption does not occur immediately and I can't define how many times I
used the buttons to access the data prior to the corruption. As you can
imagine, their physical location apprised me of their function so it was
probably more "muscle memory" than sentient utilisation.
I accept the later verbose definition is simply a description of the operation
for which I can provide a fully functional file and instructions on how to
select the appropriate data from the "source" locations and distribute it
accordingly but I suspect that's overkill. Bear in mind - that's what I was
doing when the error manifested itself. I can possibly just produce a step by
step procedure for creating five hyperlink buttons over five spreadsheet pages
and then inserting a graphic image (also a web site "cut & paste") but I
imagine the developers already know how to create five hyperlink buttons to
anything and then "grab & paste" a screen image into a sheet half way through
the file so they have the sequence:-
Sheet 1 create hyperlink button
Sheet 2 create hyperlink button
Sheet 3 leave blank
Sheet 4 create hyperlink button
Sheet 5 create hyperlink button
Screen grab anything from the internet
Crop it with Irfanview
Insert it anywhere into sheet 3
1 Cycle through activating the hyperlinks
2 Close and save the file
3 Open the file and cycle through activating the hyperlinks
4 Close and save the file
Repeat 3 & 4 until corruption occurs

At some stage the butttons will become corrupt but I'm unsure whether it
coincides with activation of the Hyperlinks or closing and reopening.

The genuine sheet comprises five pages as does the example provided. The
"source" buttons link to a collection of downloadable Excel sheets or CSVs
which I simply identify, download and open with LO and paste to the appropriate
locations. It's generally a paste special because the data is used to create a
complex array with conditional fomatting, a pair of simple columnar arrays,
three discrete columnar arrays with charts and conditional colour formatting
"Temperature Charts". The final Source button links to a dynamic array on the
website where I simply highlight the data array without the headers and paste
special as unformatted text. I also have a "map" which picks up the simple
vertical column of data produced from the website array and transposes selected
data to columns which are then referred to from the first sheet.
All the data is "public domain". If desired I can provide the live file with or
without the hyperlink buttons or the graphic for the developer to build the
hyperlinks and insert a graphic.
For the record, my live file no longer includes the graphic but I can't
remember if I removed it and it immediately remediated or whether I simply
removed the hyperlinks and the graphic then recreated hyperlinks.
Even if my live file is utilised and modified to recreate the symptoms, it's
more a case of "working" the sheet for its designed purpose and watch it fail.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210207/df7bea87/attachment-0001.htm>