[Libreoffice-bugs] [Bug 149391] CALC Hyperlink button Shrinks as it ages
https://bugs.documentfoundation.org/show_bug.cgi?id=149391 Buovjaga changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |WORKSFORME -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149391] CALC Hyperlink button Shrinks as it ages
https://bugs.documentfoundation.org/show_bug.cgi?id=149391 --- Comment #12 from Colin --- (In reply to Stéphane Guillou (stragu) from comment #10) > Couldn't reproduce either with 7.4.7.2. > Colin, have you updated to a more recent version? Are you still seeing that > shrinking? Any new steps? My last experience of the issue was on 4th August with my then installed 7.2.7.2. I have updated to 7.5.6.2 this weekend 25th September and the button presentation is now stable. I have filed another report BUG157413 also related to the stability of URL Buttons. This manifested with the 7.5.7.2 installation identified above -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149391] CALC Hyperlink button Shrinks as it ages
https://bugs.documentfoundation.org/show_bug.cgi?id=149391 --- Comment #11 from Colin --- (In reply to Stéphane Guillou (stragu) from comment #10) > Couldn't reproduce either with 7.4.7.2. > I followed similar steps to Buovjaga, and also played with hiding column > groups, autofilter, resizing columns... to no avail. > Colin, have you updated to a more recent version? Are you still seeing that > shrinking? Any new steps? Version: 7.4.7.2 (x64) / LibreOffice Community Build ID: 723314e595e8007d3cf785c16538505a1c878ca5 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 I'm fairly actively monitoring the situation and on 29th June I identified that more buttons were corrupt so I reset all those affected. By the 17th July another 9 buttons had corrupted with "Fit to Cell" errors in that some just doubled in size and some moved away from the cell boundaries despite being anchored. Two days ago -2nd Aug- four of the buttons from Mid-July failed to connect to the target image claiming the address was wrong or the file didn't exist. Editing failed to remedy the situation so I deleted and recreated those links. Today, one button from 2 weeks ago just disappeared so I've recreated it. Whilst the sheet it all goes wrong on is fairly simple with just 2 auto filtered interactive named arrays there are six more sheets some of which derive some of their data from lookups to this sheet whilst others cross reference 15911 rows of 6 columns against both this source sheet and their own data. I compare every entry for palindromes and prior use so one sheet (an autofiltered array 15911*11) takes every row and then VLOOKUP()s every other row on that sheet 759479763 potential assessments (but many are null) without the other less complex manipulation. Unfortunately, it's impossible to keep trck of everything I do which may cause a hiccup and I obviously only notice the structure changing if I have the need to review something that I didn't change today. Is there any point in providing you with the full sheet. Nothing is personal. The sheet that constantly fails is updated with just one five letter word daily and an image of the web page is then cropped, filed and hyperlinked to that sheet. If it is decided to take a full copy then There are 578 filed images for 6Mb. If these are required then obviously somebody would need to reassign their local path to allow the OS to link that path to the hyperlink specs Should I file another report for the "dropped" hyperlinks or is that just too vague a symptom at present? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149391] CALC Hyperlink button Shrinks as it ages
https://bugs.documentfoundation.org/show_bug.cgi?id=149391 Stéphane Guillou (stragu) changed: What|Removed |Added CC||stephane.guillou@libreoffic ||e.org --- Comment #10 from Stéphane Guillou (stragu) --- Couldn't reproduce either with 7.4.7.2. I followed similar steps to Buovjaga, and also played with hiding column groups, autofilter, resizing columns... to no avail. Colin, have you updated to a more recent version? Are you still seeing that shrinking? Any new steps? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149391] CALC Hyperlink button Shrinks as it ages
https://bugs.documentfoundation.org/show_bug.cgi?id=149391 --- Comment #9 from Colin --- (In reply to Colin from comment #8) > (In reply to Buovjaga from comment #7) > > (In reply to Colin from comment #6) > > > Created attachment 184365 [details] > > > Full replacement for earlier simple sheet > > > > Do you have reliable steps on how we can reproduce with this file? > > > > If you view the original .pdf attachment you can see the status of the > buttons at that time and compare them with how much more severe the issue > becomes with time. > There was also an original CALC file that was replaced by this current version - not sure if there's any value in investigating that - which would be almost a year younger with fewer actions -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149391] CALC Hyperlink button Shrinks as it ages
https://bugs.documentfoundation.org/show_bug.cgi?id=149391 --- Comment #8 from Colin --- (In reply to Buovjaga from comment #7) > (In reply to Colin from comment #6) > > Created attachment 184365 [details] > > Full replacement for earlier simple sheet > > Do you have reliable steps on how we can reproduce with this file? > >Unfortunately, the URLs are added on a daily basis and I scroll the sheet >daily to keep the latest events in view. I only noticed the corruption when I went back to the top to make a few changes to some of the cells - including the hidden ones that produce frequency stats. Even then, it wasn't initially obvious how dramatically the buttons were being changed. If you view the original .pdf attachment you can see the status of the buttons at that time and compare them with how much more severe the issue becomes with time. All I do is complete the Wordle, take a screen dump of the page, crop, save & link it. The working sheet is far more complex, with charts, an accumulating solution register so I can ensure I don't duplicate words and even filters on character positions so I can sometimes identify just how many English words are ?O?SE when my six choices all FAIL. Should I provide the full 7 sheet file in case its a combination effect? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149391] CALC Hyperlink button Shrinks as it ages
https://bugs.documentfoundation.org/show_bug.cgi?id=149391 Buovjaga changed: What|Removed |Added CC||ilmari.lauhakangas@libreoff ||ice.org --- Comment #7 from Buovjaga --- (In reply to Colin from comment #6) > Created attachment 184365 [details] > Full replacement for earlier simple sheet Do you have reliable steps on how we can reproduce with this file? I scrolled around a bit and noticed some hyperlink buttons had a bigger height. Around F164 I corrected the size of multiple buttons (after View - Toolbars - Form Controls, Design Mode). I then copied one button to F354 and tweaked the options: Anchored to a Cell with resize and Fit to Cell size. I saved and reloaded and looked at the buttons around F164. No change had occurred. Arch Linux 64-bit, X11 Version: 7.5.1.2 (X86_64) / LibreOffice Community Build ID: 50(Build:2) CPU threads: 8; OS: Linux 6.2; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US 7.5.1-1 Calc: CL threaded -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149391] CALC Hyperlink button Shrinks as it ages
https://bugs.documentfoundation.org/show_bug.cgi?id=149391 Colin changed: What|Removed |Added Attachment #180528|0 |1 is obsolete|| --- Comment #6 from Colin --- Created attachment 184365 --> https://bugs.documentfoundation.org/attachment.cgi?id=184365&action=edit Full replacement for earlier simple sheet -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149391] CALC Hyperlink button Shrinks as it ages
https://bugs.documentfoundation.org/show_bug.cgi?id=149391 --- Comment #5 from Colin --- (In reply to m.a.riosv from comment #2) > Or please attach a sample file. (In reply to Colin from comment #3) > Created attachment 180528 [details] > Sample File > > Obviously, the links will only work if the file structure and images are > reconstructed. Another fault report has required me to attach the full production sheet and it occurred to me that the sample sheet provided with 149391 was a simple demonstration of the single sheet being affected. I have just noticed that the prior fault is now exacerbated with some of the early buttons having resized themselves into two cells. I also now suspect that the fault may be related to using the autofilter on Column M of the full version. I will now attached the full "production" version. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149391] CALC Hyperlink button Shrinks as it ages
https://bugs.documentfoundation.org/show_bug.cgi?id=149391 QA Administrators changed: What|Removed |Added Ever confirmed|1 |0 Status|NEEDINFO|UNCONFIRMED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149391] CALC Hyperlink button Shrinks as it ages
https://bugs.documentfoundation.org/show_bug.cgi?id=149391 --- Comment #4 from QA Administrators --- [Automated Action] NeedInfo-To-Unconfirmed -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149391] CALC Hyperlink button Shrinks as it ages
https://bugs.documentfoundation.org/show_bug.cgi?id=149391 --- Comment #3 from Colin --- Created attachment 180528 --> https://bugs.documentfoundation.org/attachment.cgi?id=180528&action=edit Sample File Obviously, the links will only work if the file structure and images are reconstructed. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149391] CALC Hyperlink button Shrinks as it ages
https://bugs.documentfoundation.org/show_bug.cgi?id=149391 m.a.riosv changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEEDINFO -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149391] CALC Hyperlink button Shrinks as it ages
https://bugs.documentfoundation.org/show_bug.cgi?id=149391 m.a.riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o ||rg --- Comment #2 from m.a.riosv --- Or please attach a sample file. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149391] CALC Hyperlink button Shrinks as it ages
https://bugs.documentfoundation.org/show_bug.cgi?id=149391 --- Comment #1 from Colin --- Sorry, came through a weblink as the LO Help link is not functioning. Here's the technical info; Version: 7.2.7.2 (x64) / LibreOffice Community Build ID: 8d71d29d553c0f7dcbfa38fbfda25ee34cce99a2 CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: sv-SE (en_GB); UI: en-GB Calc: threaded Let me know if I really need to explain the steps for creating a hyperlink button to a local image ;) -- You are receiving this mail because: You are the assignee for the bug.
