[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

Attila Szűcs  changed:

   What|Removed |Added

   Assignee|libreoffice-b...@lists.free |szucs.atti...@nisz.hu
   |desktop.org |
 Status|NEW |ASSIGNED

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

--- Comment #48 from egc  ---
By the way, after 6 years the status of this bug, which is classified as
"major" important, is still on "new" and not assigned to anybody.

You could at least add a new handy status, something like "will be ignored" or
"the very appealing solution for this bug is to buy yourself a support and/or
fix it yourself" ... and close the bug. This way people at least know what they
can expect from this bug tracking system ...

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

--- Comment #47 from egc  ---
(In reply to Eike Rathke from comment #46)
> There's a very appealing solution to this, especially if you're using
> LibreOffice in a company environment, helping both you and the eco system
> around LibreOffice: buy support from one of the commercial entities and
> they'll happily fix the bug for you. See
> https://www.libreoffice.org/get-help/professional-support/

I know i know by now ... Everybody here repeats the same thing. I just wonder
if you need all the fuzz of a bug tracking system for this ...

You could have simply said already 6 years ago: "We will not fix this bug, buy
yourself a support to fix it." Instead of letting people wait for t years ...

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

--- Comment #46 from Eike Rathke  ---
There's a very appealing solution to this, especially if you're using
LibreOffice in a company environment, helping both you and the eco system
around LibreOffice: buy support from one of the commercial entities and they'll
happily fix the bug for you. See
https://www.libreoffice.org/get-help/professional-support/

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

--- Comment #45 from egc  ---
(In reply to Julien Nabet from comment #44)

> The pb here is you expect the same support for LO which is released freely
> by TDF than you'd expect from Microsoft for MsOffice which you must pay for.

I was talking about other open source bug tracking systems, not Microsoft or
so, i don't even know those bug tracking systems. But it's ok ...

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

--- Comment #44 from Julien Nabet  ---
(In reply to egc from comment #43)
> (In reply to Julien Nabet from comment #42)
> 
> Yeah right, learning C++ in one or more hours ... for someone who has no
> idea about programming languages ...
I supposed so. Still, you considered the bug is fixable in 15 min with no
programming knowledge or LO code source knowledge... Hope you don't speak the
same way with mechanics, plumber, etc. when you got car or house problems :-)

> 
> Anyway, i realise that i'm in the wrong place here. i always thought a
> bugtracking system (as far as i know them) is a place where normal users can
> find and report bugs to the developers so they fix them (of course, if
> someone of the users is also able to contribute for the fix they can do that
> too, but that's not the case with me)
> but that doesn't seem to be so here.
Take a look here https://cgit.freedesktop.org/libreoffice/core/log/ and you'll
see that most commits which include "tdf#" is a fix (some may be just related
like automatic test to avoid some regression on this part).
So yes the bugtracking system works well for quite some bugs.

> Here i only get advices to fix it myself or to let it fix by the company or
> to get a software developer and fix it ... or to change to another office
> suite ... Great!
In this case yes, nothing wrong here. 
The pb here is you expect the same support for LO which is released freely by
TDF than you'd expect from Microsoft for MsOffice which you must pay for.

> 
> Sorry for wasting your time. Have a good one!
No pb here to discuss here. Have a good day too!

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

--- Comment #43 from egc  ---
(In reply to Julien Nabet from comment #42)

Yeah right, learning C++ in one or more hours ... for someone who has no idea
about programming languages ...

Anyway, i realise that i'm in the wrong place here. i always thought a
bugtracking system (as far as i know them) is a place where normal users can
find and report bugs to the developers so they fix them (of course, if someone
of the users is also able to contribute for the fix they can do that too, but
that's not the case with me), but that doesn't seem to be so here. Here i only
get advices to fix it myself or to let it fix by the company or to get a
software developer and fix it ... or to change to another office suite ...
Great!

Sorry for wasting your time. Have a good one!

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

--- Comment #42 from Julien Nabet  ---
(In reply to egc from comment #41)
> (In reply to Julien Nabet from comment #40)
> 
> As i already wrote, an other office package (MS) is already in use by some
> people in the company and at home, so the company for sure is not willing to
> pay for bug fixes in LO.
I had missed this part so no need to stick on LO indeed except if you're a big
supporter of OpenSource.

> I was hoping i could keep both office packages, but with such blocking bugs
> like this one, and for so long time, my arguments for keeping LO in the
> company are go to 0.
The goal of a company is to make money so no surprise here.

> 
> As i said i'm not a software developer so i can not really tell, but i could
> imagine, that this bug is not such a big deal to be fixed by one of the
> programmers of LO. LO just duplicates the external links, so someone would
> just need to have a look at it why this happens, fix that, and that's it. I
> guess it could be done in 15 minutes for someone who knows the code.
So you're not a software dev but "you could imagine it's not a big deal".
What about taking some hours to learn some C++ (after all there are Youtube
videos to learn C++ in 1 or some hours) then give it a try, here's a link to
start with:
https://wiki.documentfoundation.org/Development/GetInvolved
To install needed software and build the code hours, let's suppose some 3/4
hours.
I'm pretty sure that just with a good will, you may submit a fix on gerrit in
some days.
There are also some people of your IT who may contribute. If they already know
how to program (and perhaps how to program in C++) perhaps they may submit a
bugfix in just 2 days?

> 
> But i don't see any will of the LO developers to fix this bug ... People
> continue reporting the same thing since 6 years and nobody in LO seems to
> find it worth to deal with it. This is not just a minor bug, it is a deal
> breaker for a mixed environment with two office packages and more operating
> systems in use.
> That's why i don't understand why none of the programmers is trying to fix
> this bug. I repeat: It is a deal breaker. Not just a little formatting (or
> whatever) bug. 
Consider this:
- take a look at the number of bugs declared in Bugzilla
- there are only about a dozen of expert devs which regularly contribute and in
those, there are some who are quite driven by the company they belong (I mean
they fix the bugs their company indicate wrt what clients paid)
=> it may give you some hints.

>
> So you're right, at the end it will be time consuming for me to convert all
> the calc sheets to Excel and make them work there. This way my effort goes
> actually into MS Office instead of LO ... which is absurd in my eyes ...
It's just your/company choice to not pay LO because they wrongly consider since
it's freely downloadable, you shouldn't pay to fix the bugs.
So stop telling it's just devs fault and see there's also you/your company
fault not willing to contribute in a way (money or programming).

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

--- Comment #41 from egc  ---
(In reply to Julien Nabet from comment #40)

As i already wrote, an other office package (MS) is already in use by some
people in the company and at home, so the company for sure is not willing to
pay for bug fixes in LO. 
I was hoping i could keep both office packages, but with such blocking bugs
like this one, and for so long time, my arguments for keeping LO in the company
are go to 0.

As i said i'm not a software developer so i can not really tell, but i could
imagine, that this bug is not such a big deal to be fixed by one of the
programmers of LO. LO just duplicates the external links, so someone would just
need to have a look at it why this happens, fix that, and that's it. I guess it
could be done in 15 minutes for someone who knows the code.

But i don't see any will of the LO developers to fix this bug ... People
continue reporting the same thing since 6 years and nobody in LO seems to find
it worth to deal with it. This is not just a minor bug, it is a deal breaker
for a mixed environment with two office packages and more operating systems in
use.
That's why i don't understand why none of the programmers is trying to fix this
bug. I repeat: It is a deal breaker. Not just a little formatting (or whatever)
bug. 

So you're right, at the end it will be time consuming for me to convert all the
calc sheets to Excel and make them work there. This way my effort goes actually
into MS Office instead of LO ... which is absurd in my eyes ...

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

--- Comment #40 from Julien Nabet  ---
(In reply to egc from comment #39)
> 
> 
> Glad you're having fun ... As i'm not a programmer my only choice is it now
> to convert all the calc documents to the other office package already in use
> in the company.
Please read what several people indicated, you can:
- wait
- fix it yourself
OR
- pay someone to do it.

For the rest, you can't convince your company to stick on LO just because you
like it. You/your company must consider ads/cons.
ads:
- it's free
- you can fix the bugs or pay someone to fix the bugs since it's open source
- multi envs (but I suppose most companies don't care since they use Windows
and when they use Linux, it's rather for servers where Office suites are not so
used, except for batch treatments for some cases)
- some relevant features for you/your company may be present in LO exclusively

cons:
- less mature than other Office suites (like Ms) (at least from my opinion)
- more difficult to have support
- depending what module you use, you may undergo lots of bugs (eg: use of
Firebird in Base is a real pb for the moment)
- some relevant features for you/your company may be lacking in LO

So if you and your company:
- don't want/can't pay for bug fixes
- can't fix bug yourselves
- can't wait anymore (I agree 6 years is too long)
=> you should consider migrating.
Now, I suppose you and your company already know that migrating has also a
cost:
- license (except if you choose a free Office suite)/support
- time consuming for IT people who'll do the migration and have to deal with
potential incompatibilities
- user training (even if the interfaces are quite similar, there are always
differences)

So perhaps it may be relevant to compare cost migration and cost to pay someone
to fix this bug and other bugs which are blocking for you.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

--- Comment #39 from egc  ---
(In reply to Julien Nabet from comment #37)
> (In reply to egc from comment #35)
> > ...
> > don't worry, we will, if that's the purpose of Libreoffice ...
> 
> To stay in the ironical tone, "yes it is indeed!".
> 
> Considering
> https://en.wikipedia.org/wiki/Comparison_of_office_suites#Main_components,
> there's some choice!

Glad you're having fun ... As i'm not a programmer my only choice is it now to
convert all the calc documents to the other office package already in use in
the company.

But thanks anyway for the enlightening link, it helped us a lot!

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

egc  changed:

   What|Removed |Added

 CC|e...@writeme.com |

--- Comment #38 from egc  ---
(In reply to Buovjaga from comment #36)
> (In reply to egc from comment #35)
> > (In reply to Julien Nabet from comment #34)
> > > (In reply to egc from comment #33)
> > > > (In reply to Timur from comment #32)
> > > > 
> > > > i mean ... are you nuts?
> > > 
> > > No Timur is completely right.
> > > Why do you think people just obey to what you command?
> > > Now, nobody forces you to use LO, if this bug is blocking for you and your
> > > company, you can also switch to another Office suite.
> > 
> > don't worry, we will, if that's the purpose of Libreoffice ...
> [...]
> If you don't have time/money to contribute, then you just have
> to wait.

We were waiting enough now. This bug is 6 years old, since the first version of
6.x ... I tried to keep Libreoffice in the company, but i can not do it for
ever ...

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

--- Comment #37 from Julien Nabet  ---
(In reply to egc from comment #35)
> ...
> don't worry, we will, if that's the purpose of Libreoffice ...

To stay in the ironical tone, "yes it is indeed!".

Considering
https://en.wikipedia.org/wiki/Comparison_of_office_suites#Main_components,
there's some choice!

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

--- Comment #36 from Buovjaga  ---
(In reply to egc from comment #35)
> (In reply to Julien Nabet from comment #34)
> > (In reply to egc from comment #33)
> > > (In reply to Timur from comment #32)
> > > 
> > > i mean ... are you nuts?
> > 
> > No Timur is completely right.
> > Why do you think people just obey to what you command?
> > Now, nobody forces you to use LO, if this bug is blocking for you and your
> > company, you can also switch to another Office suite.
> 
> don't worry, we will, if that's the purpose of Libreoffice ...

One of the purposes is to be sustainable. Timur explained some of the ways this
is achieved (completely standard free & open source development model). Of
course the result would be "nuts", if everyone would just leech without
contributing. If you don't have time/money to contribute, then you just have to
wait.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

--- Comment #35 from egc  ---
(In reply to Julien Nabet from comment #34)
> (In reply to egc from comment #33)
> > (In reply to Timur from comment #32)
> > 
> > i mean ... are you nuts?
> 
> No Timur is completely right.
> Why do you think people just obey to what you command?
> Now, nobody forces you to use LO, if this bug is blocking for you and your
> company, you can also switch to another Office suite.

don't worry, we will, if that's the purpose of Libreoffice ...

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

--- Comment #34 from Julien Nabet  ---
(In reply to egc from comment #33)
> (In reply to Timur from comment #32)
> 
> i mean ... are you nuts?

No Timur is completely right.
Why do you think people just obey to what you command?
Now, nobody forces you to use LO, if this bug is blocking for you and your
company, you can also switch to another Office suite.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

--- Comment #33 from egc  ---
(In reply to Timur from comment #32)

i mean ... are you nuts?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

Timur  changed:

   What|Removed |Added

   Hardware|x86-64 (AMD64)  |All
   Severity|critical|major

--- Comment #32 from Timur  ---
(In reply to egc from comment #31)
> Will someone have a look at this (how many years old?) bug finally???
No matter how many ?? you put, it can only be fixed if you do it yourself,
find someone to do it or wait for a volunteer to do it. 
Do not annoy people who have the same problem and follow this and who maybe
contribute to the project somehow -even if spending time to fix your wrong
report marking as a duplicate, because you hadn't search before submitting.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

--- Comment #31 from egc  ---
We now also have Macs in our company and i noticed the same behaviour on latest
MacOSX versions.

Will someone have a look at this (how many years old?) bug finally???

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

Timur  changed:

   What|Removed |Added

   Keywords||filter:xlsx

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

Julien Nabet  changed:

   What|Removed |Added

 CC||er...@redhat.com

--- Comment #30 from Julien Nabet  ---
The 30 "warn:legacy.osl:42845:42845:sc/source/core/tool/address.cxx:1601:
ScRange::ExtendTo - cannot extend to invalid range" I got correspond to the 30
REF pbs.

In xlsx, instead of having:
='file:///tmp/Source01.ods'#$SheetA.A1:E3

There's:
='file:///tmp/1'#$SheetA.A1:E3

Eike: thought you might be interested in this one.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

Julien Nabet  changed:

   What|Removed |Added

 CC||serval2...@yahoo.fr
   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=11
   ||7905

--- Comment #29 from Julien Nabet  ---
(In reply to m.a.riosv from comment #21)
> Created attachment 141478 [details]
> Source file for links

I gave a try on pc Debian x86-64 with master sources updated today.
When saving ods target file into xlsx, I noticed these logs:
warn:svl.numbers:42845:42845:svl/source/numbers/zforlist.cxx:895:
SvNumberFormatter::GetFormatStringForExcel - format not found: 4294967295
warn:legacy.osl:42845:42845:sc/source/core/tool/address.cxx:1601:
ScRange::ExtendTo - cannot extend to invalid range
warn:legacy.osl:42845:42845:sc/source/core/tool/address.cxx:1601:
ScRange::ExtendTo - cannot extend to invalid range
...

About Coinmarketcap, I noticed that tdf#117905 has been closed since public API
is gone (see https://bugs.documentfoundation.org/show_bug.cgi?id=117905#c11)

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

m.a.riosv  changed:

   What|Removed |Added

 CC||e...@writeme.com

--- Comment #28 from m.a.riosv  ---
*** Bug 122015 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

Buovjaga  changed:

   What|Removed |Added

 Blocks|128382  |


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=128382
[Bug 128382] [META] XLSX: Aggressive Competitors
-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

m.a.riosv  changed:

   What|Removed |Added

 Blocks||128382


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=128382
[Bug 128382] [META] XLSX: Aggressive Competitors
-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

--- Comment #27 from m.a.riosv  ---
Issue still
Version: 6.4.0.0.alpha1 (x86)
Build ID: cc57df8f942f239d29cb575ea5a7cb01405db787
CPU threads: 4; OS: Windows 10.0 Build 18362; UI render: GL; VCL: win; 
Locale: es-ES (es_ES); UI-Language: en-US Calc:

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

--- Comment #26 from Glen A.  ---
This is a critical data loss issue reported over 5 years ago – when can a fix
be prioritized?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

m.a.riosv  changed:

   What|Removed |Added

 CC||glen...@gmail.com

--- Comment #25 from m.a.riosv  ---
*** Bug 126821 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

m.a.riosv  changed:

   What|Removed |Added

 CC||michael.kallwe...@posteo.de

--- Comment #24 from m.a.riosv  ---
*** Bug 121472 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

m.a.riosv  changed:

   What|Removed |Added

 CC||kelem...@ubuntu.com

--- Comment #23 from m.a.riosv  ---
*** Bug 116331 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

Timur  changed:

   What|Removed |Added

 CC||andrespoc...@gmail.com

--- Comment #22 from Timur  ---
*** Bug 120845 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

--- Comment #21 from m.a.riosv  ---
Created attachment 141478
  --> https://bugs.documentfoundation.org/attachment.cgi?id=141478=edit
Source file for links

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

m.a.riosv  changed:

   What|Removed |Added

   Priority|medium  |high
   Severity|normal  |critical

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

--- Comment #20 from m.a.riosv  ---
Created attachment 141477
  --> https://bugs.documentfoundation.org/attachment.cgi?id=141477=edit
Sample file with the links

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

m.a.riosv  changed:

   What|Removed |Added

 CC||miguelangelrv@libreoffice.o
   ||rg

--- Comment #19 from m.a.riosv  ---
It is on
Version: 6.1.0.0.alpha0+
Build ID: c8c74a0b4ca6f3a3619f423b6548c80c52392ae0
CPU threads: 4; OS: Windows 10.0; UI render: default; 
TinderBox: Win-x86@42, Branch:master, Time: 2018-04-14_22:59:27
Locale: es-ES (es_ES); Calc: group

Links that are broken they are arrays, not single cells references.

Attached a target.ods and a source01.ods

Saving the "target.ods" as "target.xlsx" and reopen/reload shows the issue,
file name is changed for the array links, substituted by a number.

This issue causes a data lost, set up as critical.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

--- Comment #18 from Andrew  ---
I have tried this again with Version 5.3.7.2 (x64)
With .xlsx I am still having many problems.
Saving all the files as .xls and they seem to be working OK.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

Thomas Lendo  changed:

   What|Removed |Added

 Blocks||112071


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=112071
[Bug 112071] [META] Linked external data issues
-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

Bartosz  changed:

   What|Removed |Added

 Status|ASSIGNED|NEW
   Assignee|gan...@poczta.onet.pl   |libreoffice-b...@lists.free
   ||desktop.org

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

Bartosz  changed:

   What|Removed |Added

   Assignee|libreoffice-b...@lists.free |gan...@poczta.onet.pl
   |desktop.org |

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

Bartosz  changed:

   What|Removed |Added

 Status|NEW |ASSIGNED

--- Comment #14 from Bartosz  ---
Test scenario:
1. I have opened coinmarketcap-new-update_60s_LOv4162.xlsx,
coinmarketcap-new-update_60s_LOv4262.xlsx and
coinmarketcap-new-update_60s_LOv4400_2014-08-18.xlsx filew with LO 5.2.2
2. All links are working. After clicking it with CTRL + Right Mouse Buttton it
is moving to corrsponding site.

So in my opinion the original bug report was resolved.

There are still missing message after .xlsx run: "This file contatins links to
other files. Should they be updated?"

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

--- Comment #13 from Buovjaga  ---
(In reply to Andrew from comment #12)
> When I clicked on "Help / Check for Updates" it told me I was up to date. 
> Is that another bug?
> 
> Is there a reason to expect it has been fixed in between? When I do update,
> I will check again.

You can just download it:
http://www.libreoffice.org/download/libreoffice-fresh/

The reason we suspect that is that Bartosz reported it fixed in 5.2.2.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

--- Comment #12 from Andrew  ---
When I clicked on "Help / Check for Updates" it told me I was up to date.  Is
that another bug?

Is there a reason to expect it has been fixed in between? When I do update, I
will check again.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

--- Comment #11 from Buovjaga  ---
(In reply to Andrew from comment #10)
> The problem I identified in Bug 100999, which was redirected to be a
> duplicate of this bug (whether it is or not I don't know), still exists.
> 
> That is:
> 
> 1. save links in .ods file, works fine
> 2. save links in .xls file, works fine
> 3. save links in .xlsx file, fails
> 
> LibreOffice 5.1.5.2
> Windows 10

..and is there a reason you did not test with 5.2.2 like Bartosz?

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

Aron Budea  changed:

   What|Removed |Added

 Status|REOPENED|NEW

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

Andrew  changed:

   What|Removed |Added

 Status|RESOLVED|REOPENED
 Resolution|WORKSFORME  |---

--- Comment #10 from Andrew  ---
The problem I identified in Bug 100999, which was redirected to be a duplicate
of this bug (whether it is or not I don't know), still exists.

That is:

1. save links in .ods file, works fine
2. save links in .xls file, works fine
3. save links in .xlsx file, fails

LibreOffice 5.1.5.2
Windows 10

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

Bartosz  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |WORKSFORME

--- Comment #9 from Bartosz  ---
It is working for me with LibreOffice 5.2.2 (Ubuntu 16.04

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

m.a.riosv  changed:

   What|Removed |Added

 CC||and...@amos.gs

--- Comment #8 from m.a.riosv  ---
*** Bug 100999 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

Beluga  changed:

   What|Removed |Added

 CC||todven...@suomi24.fi

--- Comment #7 from Beluga  ---
XLSX still losing links.

Win 7 Pro 64-bit Version: 5.1.0.0.alpha1+
Build ID: b216cc1b8096eb60c27f67e8c27b7cd756c75e38
TinderBox: Win-x86@62-merge-TDF, Branch:MASTER, Time: 2015-11-12_00:06:20
Locale: fi-FI (fi_FI)

-- 
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 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=76047

--- Comment #6 from QA Administrators  ---
** 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 on a currently supported version of
LibreOffice (5.0.0.5 or later)
   https://www.libreoffice.org/download/

   If the bug is present, please leave a comment that includes the version of
LibreOffice and your operating system, and any changes you see in the bug
behavior

 If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a short comment that includes your version of
LibreOffice and Operating System

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)

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:
http://webchat.freenode.net/?channels=libreoffice-qa

Thank you for your help!

-- The LibreOffice QA Team This NEW Message was generated on: 2015-09-03

-- 
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 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=76047

--- Comment #5 from Alex xfac...@gmail.com ---
I can confirm that I am no longer experiencing the update frequency issue in
version 4.3.0.4. XLS files also now retain the external data link, and the only
problem remaining is with XLSX, as explained in comments 3 and 4.

-- 
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 76047] FILESAVE: Links to external data not preserved for XLSX

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=76047

Owen Genat owen.ge...@gmail.com changed:

   What|Removed |Added

 OS|Windows (All)   |All
 Status|UNCONFIRMED |NEW
   See Also|https://bugs.freedesktop.or |
   |g/show_bug.cgi?id=57330 |
Summary|FILESAVE: external data |FILESAVE: Links to external
   |links not saved properly|data not preserved for XLSX
   |(.ods, .sxc, .xls, .xlsx)   |
Version|4.2.1.1 release |4.1.6.2 release
 Ever confirmed|0   |1

--- Comment #4 from Owen Genat owen.ge...@gmail.com ---
As a result of comment 3 I am confirming this bug, as there are problems, but
not as many as originally indicated. The main issue is with the XLSX file
format not preserving links to external data (HTML tables). Summary amended for
clarity. Status set to NEW. Version set to v4.1.6.2 (but may be older).
Operating System set to All. Bug 57330 removed from See Also list as it relates
to XLS.

If the update frequency issue (or a problem specific to the XLS format that is
not covered by bug 57330) can be demonstrated in a clear and simple manner,
please open a new bug for this as the policy is: one bug, one issue. Thanks.

-- 
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