Created attachment 124629 [details] Spreadsheet which exhibits failure Upgraded Fedora 23 which included Fedora Calc to 5.0.6.1. Spreadsheet (attached) no longer can be opened. Waited 2 hours. Tried on another machine (also upgraded) with same result. I had noticed that this spreadsheet was taking what seemed to be a long time (several seconds) to load beforehand so I suspect something in the spreadsheet itself is the cause. 'ps' shows minimal cpu usage by the Calc process - it consumes a second of user time every several minutes. The system monitor doesn't show memory being consumed, but there is a 10 KiB/s network traffic in and out (same data volume for each) which I cannot explain. The application could be shutdown without resorting to 'kill', in which case I was prompted to wait or to force a shutdown. No other LO application will start when in this state. An attempt to start Writer, for example, fails with no apparent action. When Calc is again shutdown after attempting to start Writer, a Calc is immediately started to begin a recovery of the default empty spreadsheet. Such a recovery attempt is not initiated if there is no attempt to start Writer. LO 5.0.6.1 ('about' doesn't say 'rc') Build ID: 5.0.6.1-1.fc23 uname -r: 4.4.7-300.fc23.x86_64+debug
After stopping Calc, the 10 KiB/s network observed dropped to zero.
Created attachment 124630 [details] The document is NOT conformant ODF1.2! Hello, the document is not conformant ODF1.2. http://odf-validator.rhcloud.com/
Thank you very much for pointing this out to me. It does beg the question as to how a document maintained by LibreOffice can become non-conformant, but that is a question for another day. It would also seem to be a bug that a non-conformant document would cause Calc to hang up. Shouldn't I be able to attempt to open my mother's recipe for Chicken Cacciatore without such behavior? What was Calc attempting with all the network traffic? It would seem that more effective defense against malformed input is in order. (I give you my spreadsheet as an example :) I recovered the data by opening this file in Microsoft Excel 2007 which complained about some unreadable content, apparently dropped the formulae, but allowed me to export a CSV. I would hope that LO could do the same.
(In reply to raal from comment #2) > Created attachment 124630 [details] > The document is NOT conformant ODF1.2! > > Hello, > the document is not conformant ODF1.2. http://odf-validator.rhcloud.com/ Sorry, but even a little text [one or two words] saved as odt or a few numbers in calc saved as ods are already too much for this validator in confirming mode, saying 'The document is NOT conformant ODF1.2!' But it works with extended confirming. So how much can you trust it then ?! Same with the reporter's file, which passes with 'extended conforming'.
(In reply to raal from comment #2) > The document is NOT conformant ODF1.2! This is normal. See https://wiki.documentfoundation.org/ODF#ODF_Extensions
The spreadsheet has some references to a remote image - http://www.digikey.com/web%20export/common/mkt/en/help.png?requestedName=help?requestedName=help?requestedName=help?requestedName=help?requestedName=help After unzipping and replacing all occurrences of the above inside content.xml with some dummy url, it opens fine in a few seconds.
(In reply to Maxim Monastirsky from comment #6) > The spreadsheet has some references to a remote image - > http://www.digikey.com/web%20export/common/mkt/en/help. > png?requestedName=help?requestedName=help?requestedName=help?requestedName=he > lp?requestedName=help > > After unzipping and replacing all occurrences of the above inside > content.xml with some dummy url, it opens fine in a few seconds. I repeated your actions (learned something in the process - thanks) and confirm the file is recovered. At this point, I'm conflicted. On the one hand, the behavior exhibited by Calc when attempting to open this file is very unfriendly. It not only gave no clue as to the problem, but left no avenue to repair it. On the other hand, perfect defense is impossible and this would seem to be an odd case (I'm not really sold on this argument). Excel 2007 opened it, and without that avenue (or your manual edits) I'd have been out of luck. I also opened that URL (they are all the same) to confirm its validity and am still unable to load my original spreadsheet. It would seem that whatever failure has been triggered ought to be addressed. Even if the URL was inaccessible, a 5 minute timeout should have fired an exception. Instead I say continuous network activity. It seems that something is mishandling that URL.
Thanks for correcting me with validator. I found bug 52547 - the reason why the images are linked and not included in the file. Similar writer bug 42742. Setting to new
(In reply to raal from comment #8) > Similar writer bug 42742. Setting to new Seems like a dup then.
(In reply to MM from comment #9) > (In reply to raal from comment #8) > > > Similar writer bug 42742. Setting to new > > Seems like a dup then. Could be a dup. However, in my case there were 15 links to the same existing PNG file and 10KB/s net traffic for two hours without opening anything. Slightly different behavior from slow loading.
It seems there is a cyclical redirection driven by the web server. The historical limit is 5 redirection, going to implement that in LO.
BZ was offline, reporting the commit myself. I committed a patch related to this issue, to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=18009fe8fbe3982141ddca3f1fcd0900a63150a6 Related: tdf#99499, add a limit to the number of http redirections It enables the Calc file loading and opening. Current daily on Linux: Version: 5.3.0.0.alpha0+ Build ID: 18009fe8fbe3982141ddca3f1fcd0900a63150a6 CPU Threads: 8; OS Version: Linux 3.13; UI Render: default; TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2016-08-12_06:44:06 Locale: en-US (en_US.UTF-8); Calc: group has the patch, it can be used to test the loading. There are other issues to be addressed, though, I'm still investigating.
LO has currently a limitation on the URI web query it can perform. For example, in this bug, the URI: <http://www.digikey.com/web%20export/common/mkt/en/help.png?requestedName=help?requestedName=help?requestedName=help?requestedName=help?requestedName=help> for LO should instead be simplified into: <http://www.digikey.com/web%20export/common/mkt/en/help.png?requestedName=help> The other URI: <https://sealserver.trustkeeper.net/seal_image.php?customerId=84EDAB68F81B2B31985E5E20392A8AC1&size=105x54&style=normal?requestedName=seal_image?requestedName=seal_image?requestedName=seal_image?requestedName=seal_image> for LO should instead be simplified into: <https://sealserver.trustkeeper.net/seal_image.php?customerId=84EDAB68F81B2B31985E5E20392A8AC1&size=105x54&style=normal> This kind of simplification only solve this specific instance, would not work on other possible instances (e.g. with different more complex web queries). This need further longer work.
Dear developer, This bug has been in ASSIGNED status for more than 3 months without any activity. Resetting it to NEW. Please assigned it back to yourself if you're still working on this.
** Please read this message in its entirety before responding ** 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 http://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://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
http://bugs.documentfoundation.org/attachment.cgi?id=124629 opens fast in Версия: 6.1.1.1 ID сборки: 2718b4a18dfcc6a54ebe5f7b801ee7a47fa81e0c Потоков ЦП: 4; ОС:Windows 6.1; Отрисовка ИП: по умолчанию; Локаль: ru-RU (ru_RU); Calc: group threaded but I don't see any image in spreadsheet. There are some link to pdf's in some cells @Xisco: what do you think now about this bug?
it takes real 0m6,890s user 0m2,263s sys 0m0,232s in Version: 6.3.0.0.alpha0+ Build ID: 3b518953a8141b0d5043c2f3996a92956fdc3a47 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US Calc: threaded I guess we can close this as RESOLVED WORKSFORME
(In reply to Roman Kuznetsov from comment #16) > http://bugs.documentfoundation.org/attachment.cgi?id=124629 opens fast in > > Версия: 6.1.1.1 > ID сборки: 2718b4a18dfcc6a54ebe5f7b801ee7a47fa81e0c > Потоков ЦП: 4; ОС:Windows 6.1; Отрисовка ИП: по умолчанию; > Локаль: ru-RU (ru_RU); Calc: group threaded > > but I don't see any image in spreadsheet. There are some link to pdf's in > some cells > > @Xisco: what do you think now about this bug? Which images do you mean ?
Giuseppe Castagno committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/0e9cea7ccdac443a51c81ce6ec3e1115a09b00be ucb: webdav-curl: Related: tdf#99499, add a limit to the number of http redirections It will be available in 7.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.