Test platforms are Mageia 2, 32-bit, KDE Live-CD Linux Mint 13, 32-bit, Live-CD Boot the Mageia Live-CD then create two simple xls files in lets say /test. Create temp01.xls Create a list of numbers in lets say A1:A5 Use simple numbers: 125, 200, 350, 400, 500 Create temp02.xls Copy array A1:A5 from temp01.xls then paste special -> link that array starting at A1 in temp02.xls At this point test02.xls is in fact linked to test01.xls Save both files and close them. Open test02.xls and the following error window is reported: ---- reported error window ---- The following external file could not be loaded. Data linked from this file did not get updated. file:///home/live/test/home/live/test/test02.xls ---- end error window ---- The same error window will be reported regardless if temp01 is open or closed. Go through the same process using .ods files and things work fine. No error window. I went through the same process with Linux Mint 13 and got the same error. That would lead me to believe that this is an LibreOffice 3 problem and not a Mageia 2 problem.
reproduced here, and it works on odt too. Here too, it paste twice the path
CC: (none) => dmorganec
(In reply to comment #1) > reproduced here, and it works on odt too. > > Here too, it paste twice the path. Thanks for your support. Seems to be some wrinkles here. More testing on my part especially using a Mageia 1 Live-CD to see if it was there.
Ya, there's been a BIG change since Mageia 1, 32-bit, KDE Live-CD LibreOffice 3 Ver 3.3.2 Both xls & odt seamlessly link arrays together. Make a change to test01.xls/odt, then make test02.xls/odt active, and the link automatically updates. Not so in Mageia 2, LibreOffice 3 Ver 3.5.3.2 Not our fault and not a good thing at the same time. This could effect a lot of people.
I wanted to share how I found this. I use Calc for my personal household budget. I've a collection of yearly, monthly and checkbook xls/odt files that I've built up over the years. I simply copy them from one OS install to the next. So when I switched over to Mageia 2 for my primary computer I copied all those files over. Everything worked. So I suggest that any presently existing xls/odt files will likely link just fine. Now along comes July so it was time to create a new July 2012 xls ( now odt ) file and when I created that file and attempted to make the copied array link back to the 2012 yearly file that's when the error came up. So, potentially, people won't immediately discover this. As long as they use xls/odt files that were created before LibreOffice 3 Ver 3.5.3.2 then they'll continue to link to arrays properly. It's when they create a new xls/odt file, that's when they will encounter the error.
upstream known bugs : https://bugs.freedesktop.org/show_bug.cgi?id=48463 (existing for linux but not for windows) and perhaps : https://bugs.freedesktop.org/show_bug.cgi?id=50799
CC: (none) => philippedidier
That makes me more and more prudent with the new versions of programs for professional use !!! This bug exists for 3.5.1 then 3.5.2 then 3.5.3 then 3.5.4 version ... The comments in bug 48463 need to be read : There's a real gap between dev and users about the concept of "release blocker" !
(In reply to comment #6) > This bug exists for 3.5.1 then 3.5.2 then 3.5.3 then 3.5.4 version ... Many thanks to Philippe Didier for tracking this. We all look forward to an update from LibreOffice that fixes this critical Bug.
It's a pity : 3.5.5 RC has the same bug, and final will certainly come uncorrected next week ! (70 days ... and the only reaction on freedesktop-bugzilla was to complain that the reporter produces noise !) We can't anymore share complex .xls documents, unless we use the previous 3.4.6 version of libreOffice : that will soon no more be provided and maintained by libreoffice.org ! there will not be any 3.4.7 version and the new security bugs will not be corrected... end of life !!! Corporate and private users are supposed to use now the 3.5.4 recommended version before the coming 3.5.5 And the 3.6.0 beta is already here ... beside 3.5.x having still hundreds of not corrected bugs and regressions. in French we say "fuite en avant" that means nearly : forging ahead regardless... Never have been told that you must absolutely not use LibreOffice to share work with people still using xls documents to be readable by everybody (someone working with old Microsoft Office for instance...) that's corporate use ! The fundamental choice ought to be either to obey to an arbitrary schedule or to keep and maintain the last version until the next is really ready and don't bring regressions (Debian way) Mageia devs can't do anything for this LibreOffice problem... But it's worth thinking about the real need to be cutting edge.
I would suggest that old MS xls files are still the major format for spreadsheets in corporate use today. Kinda like Windows XP is the most common OS. If you want to send a business plan to someone likely those forecast files are in xls format.
That is why I say it's a pity... Mageia 2 is not useable for my professional use ... because of such a stupid uncorrected bug from LibreOffice ! I can't force everyone to use openformat like ods or odt and I need to communicate... Friends of mine can only ask their students (using Microsoft Office) to never use xlsx or docx documents but only xls or doc to be readable by everybody. Even if they try to promote opendocument format they can't impose it. Fortunately I always keep a multiple boot on my computer : Mandriva 2010.2 , and Debian squeeze with some backported packages ; both of them rock solid for my job ! testing Mageia2 besides them, until I am sure it is as useable and secure as them. But I know now that I can't use it for everyday job, even if I'm fond of this real community project. It's a no go ! Wait perhaps for Libreoffice 3.6.x ;-) ... but will it be backported to Mageia2 ? or do we need to wait for Mageia3 ?
Is the bug still present in 3.5.7.2 ? (The version currently in mga2) (I can't test it -- I don't have a functional ms partition.)
CC: (none) => andre999mga
Tested in Mageia3 (Cauldron) today including libreoffice-calc-4.0.3.3-2.mga3 : same behavior. Explanation is given on the comment #17 on the upstream bug report: https://bugs.freedesktop.org/show_bug.cgi?id=48463#c17 So looks like it won't be corrected. Workaround is to update link (Menu: Edition > link) each time the destination file is reloaded. :-(
CC: (none) => gibi33
CC: andre999mga => (none)
Ok, since this is an upstream bug and they are not likely to fix it, I'm closing this bug otherwise it will stay open forever. If LO's behaviour changes someday, we might reconsider, although probably not for Mageia 2 which will probably have reached its End Of Life by then. Sorry about that.
Status: NEW => RESOLVEDCC: (none) => stormiResolution: (none) => WONTFIX
Not a problem. We could go on forever on wrinkles in LibreOffice. Not our deal.