Bug 6549

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

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 => RESOLVED
CC: (none) => stormi
Resolution: (none) => WONTFIX

Not a problem. We could go on forever on wrinkles
in LibreOffice. Not our deal.