[Libreoffice-bugs] [Bug 138356] CALC Hyperlink button text corrupted with part of an embedded graphic image
https://bugs.documentfoundation.org/show_bug.cgi?id=138356 BogdanB changed: What|Removed |Added CC||buzea.bog...@libreoffice.or ||g Blocks||120543 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=120543 [Bug 120543] [META] Bugs and enhancements around hyperlinks in Calc -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 138356] CALC Hyperlink button text corrupted with part of an embedded graphic image
https://bugs.documentfoundation.org/show_bug.cgi?id=138356 --- Comment #12 from Colin --- (In reply to QA Administrators from comment #11) > Dear Colin, > > To make sure we're focusing on the bugs that affect our users today, > LibreOffice QA is asking bug reporters and confirmers to retest open, > confirmed bugs which have not been touched for over a year. Still present in Version: 7.4.5.1 (x64) / LibreOffice Community Build ID: 9c0871452b3918c1019dde9bfac75448afc4b57f CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: sv-SE (en_GB); UI: en-GB Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 138356] CALC Hyperlink button text corrupted with part of an embedded graphic image
https://bugs.documentfoundation.org/show_bug.cgi?id=138356 --- Comment #11 from QA Administrators --- Dear Colin, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 138356] CALC Hyperlink button text corrupted with part of an embedded graphic image
https://bugs.documentfoundation.org/show_bug.cgi?id=138356 --- Comment #10 from Colin --- Clutching at straws, there are quite a few reports concerning general failings of the cutting & pasting functionality. Is it conceivable this just symptomatic of another facet of that issue? Cut and paste from a website causing corruption to related hyperlinks -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 138356] CALC Hyperlink button text corrupted with part of an embedded graphic image
https://bugs.documentfoundation.org/show_bug.cgi?id=138356
--- Comment #9 from Colin ---
(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.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 138356] CALC Hyperlink button text corrupted with part of an embedded graphic image
https://bugs.documentfoundation.org/show_bug.cgi?id=138356 --- Comment #8 from Regina Henschel --- (In reply to Regina Henschel from comment #7) > form attribute "form:image-data" which should not be there. I was not correct. A push button can have an "form:image-data" attribute. Then the image is shown in addition to the label text. But here this was not intended. So the question remains, how it was generated. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 138356] CALC Hyperlink button text corrupted with part of an embedded graphic image
https://bugs.documentfoundation.org/show_bug.cgi?id=138356
--- Comment #7 from Regina Henschel ---
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.
--
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 138356] CALC Hyperlink button text corrupted with part of an embedded graphic image
https://bugs.documentfoundation.org/show_bug.cgi?id=138356 --- Comment #6 from Colin --- (In reply to Regina Henschel from comment #5) > It seems to be a kind of refresh problem. Open toolbar "Form Control" and > switch to design mode. Right-click the hyperlink-button and select item > "Control Properties". On tab "General" scroll down till item "Graphics". > Open its drop-down list and close it. OK. Close dialog. Now the button > should be repaired. > > I see, that something is wrong, therefore I set it to "new". But I have not > yet tested, whether the file itself has an error. Is there anything you need me to do to verify the file integrity? I can confirm the image source was a "screengrab" pasted to Irfanview then cropped before insertion into the sheet. Also, but probably not too significant, I use two monitors on this PC together with "Mouse without Borders" to control two more PCs each having only one attached monitor. MwB is not always active but as you've proven - the error occurs regardless of my configuration. I can't verify whether the setup may have been active at the time the image was copied, thereby introducing a file error that persists across PCs Also, I confirm that having stripped the image from the original sheet it has never malfunctioned since. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 138356] CALC Hyperlink button text corrupted with part of an embedded graphic image
https://bugs.documentfoundation.org/show_bug.cgi?id=138356 QA Administrators changed: What|Removed |Added Whiteboard| QA:needsComment| -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 138356] CALC Hyperlink button text corrupted with part of an embedded graphic image
https://bugs.documentfoundation.org/show_bug.cgi?id=138356 Regina Henschel changed: What|Removed |Added Ever confirmed|0 |1 CC||rb.hensc...@t-online.de Status|UNCONFIRMED |NEW --- Comment #5 from Regina Henschel --- It seems to be a kind of refresh problem. Open toolbar "Form Control" and switch to design mode. Right-click the hyperlink-button and select item "Control Properties". On tab "General" scroll down till item "Graphics". Open its drop-down list and close it. OK. Close dialog. Now the button should be repaired. I see, that something is wrong, therefore I set it to "new". But I have not yet tested, whether the file itself has an error. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 138356] CALC Hyperlink button text corrupted with part of an embedded graphic image
https://bugs.documentfoundation.org/show_bug.cgi?id=138356 --- Comment #4 from Colin --- Created attachment 168478 --> https://bugs.documentfoundation.org/attachment.cgi?id=168478&action=edit Spreadsheet with corrupted hyperlink buttons -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 138356] CALC Hyperlink button text corrupted with part of an embedded graphic image
https://bugs.documentfoundation.org/show_bug.cgi?id=138356 --- Comment #3 from Colin --- Added Simple Spreadsheet demonstrating the effect of Graphics upon Hyperlink Buttons. The reason it was originally defined as intermittent is that the corruption was only apparent when a graphic image was embedded "somewhere" in the sheet and not all files had such objects. As demonstrated, Hyperlinks on sheets preceding the graphic are intact whereas those on subsequent sheets are corrupted by the image. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 138356] CALC Hyperlink button text corrupted with part of an embedded graphic image
https://bugs.documentfoundation.org/show_bug.cgi?id=138356 QA Administrators changed: What|Removed |Added Whiteboard|| QA:needsComment -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 138356] CALC Hyperlink button text corrupted with part of an embedded graphic image
https://bugs.documentfoundation.org/show_bug.cgi?id=138356 --- Comment #2 from Colin --- Further investigation (Form design mode and "stretch" the button corner to "fill" the page) reveals that the corruption of the button face has incorporated the entire graphic - not just the first "line" -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 138356] CALC Hyperlink button text corrupted with part of an embedded graphic image
https://bugs.documentfoundation.org/show_bug.cgi?id=138356 --- Comment #1 from Colin --- Just realised something significant. Many of my CALCs contain hyperlinks but this is the only one with an embedded graphic image - the graphic image that appears on the rogue buttons. My apologies, I was focused on the rogue file to the exclusion of the other successful files. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
