[Libreoffice-bugs] [Bug 58531] FILEOPEN: Reload no longer refreshes external links in 4.0
https://bugs.freedesktop.org/show_bug.cgi?id=58531 Kohei Yoshida changed: What|Removed |Added Status|NEW |ASSIGNED Assignee|libreoffice-b...@lists.free |kohei.yosh...@suse.de |desktop.org | -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 58531] FILEOPEN: Reload no longer refreshes external links in 4.0
https://bugs.freedesktop.org/show_bug.cgi?id=58531 --- Comment #18 from Yi Ding --- No problem. Oddly on one of our older (production use) spreadsheets it doesn't prompt to update links but just does it automatically (in 3.6). Not sure what's triggering the difference in behavior (maybe some setting?). In the new example spreadsheets I've uploaded, there's always a prompt. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 58531] FILEOPEN: Reload no longer refreshes external links in 4.0
https://bugs.freedesktop.org/show_bug.cgi?id=58531 Yi Ding changed: What|Removed |Added Attachment #72683|text/plain |application/vnd.oasis.opend mime type||ocument.spreadsheet --- Comment #17 from Yi Ding --- Comment on attachment 72683 --> https://bugs.freedesktop.org/attachment.cgi?id=72683 test2.ods mimetype fix -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 58531] FILEOPEN: Reload no longer refreshes external links in 4.0
https://bugs.freedesktop.org/show_bug.cgi?id=58531 Yi Ding changed: What|Removed |Added Attachment #72681|text/plain |application/vnd.oasis.opend mime type||ocument.spreadsheet --- Comment #16 from Yi Ding --- Comment on attachment 72681 --> https://bugs.freedesktop.org/attachment.cgi?id=72681 test1.ods mimetype fix -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 58531] FILEOPEN: Reload no longer refreshes external links in 4.0
https://bugs.freedesktop.org/show_bug.cgi?id=58531 Yi Ding changed: What|Removed |Added Attachment #72518|text/plain |application/vnd.oasis.opend mime type||ocument.spreadsheet --- Comment #15 from Yi Ding --- Comment on attachment 72518 --> https://bugs.freedesktop.org/attachment.cgi?id=72518 test ods file mime type fix -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 58531] FILEOPEN: Reload no longer refreshes external links in 4.0
https://bugs.freedesktop.org/show_bug.cgi?id=58531 --- Comment #14 from Kohei Yoshida --- (In reply to comment #11) > The problem is that currently it prompts the user "This file contains links > to other files. Should they be updated?" and even after the user clicks > yes, the link is still not updated. > > This seems like a fairly clear bug rather than future feature, and IMHO a > serious one, because it'll break any spreadsheet that has links to any other > spreadsheet from the user perspective (yes, it'll work after doing a > recalculate but the user will never know to do that, especially when they've > already been prompted once). Ah, so Calc prompts for the link update? I mis-read the description then. I thought Calc wouldn't prompt for the link update unless the doc is recalculated. Yes, then it's a bug. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 58531] FILEOPEN: Reload no longer refreshes external links in 4.0
https://bugs.freedesktop.org/show_bug.cgi?id=58531 Yi Ding changed: What|Removed |Added Blocks||54157 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 58531] FILEOPEN: Reload no longer refreshes external links in 4.0
https://bugs.freedesktop.org/show_bug.cgi?id=58531 --- Comment #13 from Yi Ding --- Created attachment 72683 --> https://bugs.freedesktop.org/attachment.cgi?id=72683&action=edit test2.ods -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 58531] FILEOPEN: Reload no longer refreshes external links in 4.0
https://bugs.freedesktop.org/show_bug.cgi?id=58531 --- Comment #12 from Yi Ding --- Created attachment 72681 --> https://bugs.freedesktop.org/attachment.cgi?id=72681&action=edit test1.ods Adding more test files to show ODS->ODS links also broken. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 58531] FILEOPEN: Reload no longer refreshes external links in 4.0
https://bugs.freedesktop.org/show_bug.cgi?id=58531 --- Comment #11 from Yi Ding --- The problem is that currently it prompts the user "This file contains links to other files. Should they be updated?" and even after the user clicks yes, the link is still not updated. This seems like a fairly clear bug rather than future feature, and IMHO a serious one, because it'll break any spreadsheet that has links to any other spreadsheet from the user perspective (yes, it'll work after doing a recalculate but the user will never know to do that, especially when they've already been prompted once). -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 58531] FILEOPEN: Reload no longer refreshes external links in 4.0
https://bugs.freedesktop.org/show_bug.cgi?id=58531 --- Comment #10 from Kohei Yoshida --- Although this may call for a need to separate the "update link on load" mechanism from the calculation so that the user will get prompted even when the full calculation is not performed on load. That's something to think about for future releases. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 58531] FILEOPEN: Reload no longer refreshes external links in 4.0
https://bugs.freedesktop.org/show_bug.cgi?id=58531 --- Comment #9 from Kohei Yoshida --- (In reply to comment #7) > Hi Yi, > Doing a hard recalculation (Ctrl+Shif+F9), open the import box for csv files > and then update, while in 3.6.4.3 the import box for csv is open when accept > update at opening the file. > > After a little research, I have found that changing the new option in: > Menu/Tools/Options/LOdev calc/formula - Recalculation on file load - ODF > spreadsheet (not saved by LibreOffice) to always recalculate solve the issue. > > But I think the issue is that does not work with the option Prompt user. So > the bug is there. That's in itself not a bug. The option is intended for ODS documents *not* saved by LibreOffice. If you open one that's last saved by LibreOffice, it won't recalculate on load. But you can (as you've already noted earlier) still hard calculate after the load. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 58531] FILEOPEN: Reload no longer refreshes external links in 4.0
https://bugs.freedesktop.org/show_bug.cgi?id=58531 --- Comment #8 from Yi Ding --- Thanks for looking into this Marios. It looks like the default setting for that option is "Never recalculate" which may be preferable for formulas that reference in-workbook values but definitely not (IMHO) for ones that reference other files. Would this also affect worksheet links then between ODS files? I think those get used by a lot of (power) users. I also filed a similar bug about DDEs breaking after loading. Maybe it's due to the same setting? bug 59032 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 58531] FILEOPEN: Reload no longer refreshes external links in 4.0
https://bugs.freedesktop.org/show_bug.cgi?id=58531 --- Comment #7 from mariosv --- Hi Yi, Doing a hard recalculation (Ctrl+Shif+F9), open the import box for csv files and then update, while in 3.6.4.3 the import box for csv is open when accept update at opening the file. After a little research, I have found that changing the new option in: Menu/Tools/Options/LOdev calc/formula - Recalculation on file load - ODF spreadsheet (not saved by LibreOffice) to always recalculate solve the issue. But I think the issue is that does not work with the option Prompt user. So the bug is there. On other hand, import data from csv I think is better trough Menu/Insert/Sheet or Sheet from file, because in this way you do not need to worry about how many rows are in the csv, and the new option do not interfere with the update. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 58531] FILEOPEN: Reload no longer refreshes external links in 4.0
https://bugs.freedesktop.org/show_bug.cgi?id=58531 Yi Ding changed: What|Removed |Added Version|4.0.0.0.beta1 |4.0.0.0.beta2 --- Comment #6 from Yi Ding --- In fact, if you just open test.ods on your computer, you'll see that test.ods doesn't even update the first time under 4.0 (I've checked with beta 2 and it's the same) leaving the bottom right cell a 1 instead of a 5. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 58531] FILEOPEN: Reload no longer refreshes external links in 4.0
https://bugs.freedesktop.org/show_bug.cgi?id=58531 --- Comment #5 from Yi Ding --- Created attachment 72518 --> https://bugs.freedesktop.org/attachment.cgi?id=72518&action=edit test ods file -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 58531] FILEOPEN: Reload no longer refreshes external links in 4.0
https://bugs.freedesktop.org/show_bug.cgi?id=58531 --- Comment #4 from Yi Ding --- Created attachment 72517 --> https://bugs.freedesktop.org/attachment.cgi?id=72517&action=edit test csv file -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 58531] FILEOPEN: Reload no longer refreshes external links in 4.0
https://bugs.freedesktop.org/show_bug.cgi?id=58531 Yi Ding changed: What|Removed |Added Status|NEEDINFO|NEW --- Comment #3 from Yi Ding --- I tried resetting my user profile, but it did not change anything. I've attached a few test files (you might have to change the links on your machine to match your directory structure) Basically, what you can do is open test.ods, then modify test.csv to something else. In 3.6 test.ods would update once you hit file->reload. This no longer happens in 4.0 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 58531] FILEOPEN: Reload no longer refreshes external links in 4.0
https://bugs.freedesktop.org/show_bug.cgi?id=58531 mariosv changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 --- Comment #2 from mariosv --- Hi Yi, Have you trying resetting the user profile? Sometimes solve strange issues. https://wiki.documentfoundation.org/UserProfile -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 58531] FILEOPEN: Reload no longer refreshes external links in 4.0
https://bugs.freedesktop.org/show_bug.cgi?id=58531 mariosv changed: What|Removed |Added CC||mari...@miguelangel.mobi --- Comment #1 from mariosv --- Hi Yi, no issue here with: Win7x64 Ultiimate. LibreOffice Version 4.0.0.0.beta1 (Build ID: 87906242e87d3ddb2ba9827818f2d1416d80cc7) verify your options in Men/Tools/Options/LibreOffice calc/General - updating. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs