** Changed in: libreoffice (Ubuntu Trusty)
Importance: Undecided => High
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1389858
Title:
Libreoffice calc 4.2.7-0ubuntu1 not updating references after
** Bug watch removed: freedesktop.org Bugzilla #79441
https://bugs.freedesktop.org/show_bug.cgi?id=79441
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1389858
Title:
Libreoffice calc 4.2.7-0ubunt
@Luke (lukebenes): Thanks.
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1389858
Title:
Libreoffice calc 4.2.7-0ubuntu1 not updating references after sort
To manage notifications about this bug go
** Bug watch removed: freedesktop.org Bugzilla #83765
https://bugs.freedesktop.org/show_bug.cgi?id=83765
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1389858
Title:
Libreoffice calc 4.2.7-0ubunt
** Bug watch removed: freedesktop.org Bugzilla #85614
https://bugs.freedesktop.org/show_bug.cgi?id=85614
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1389858
Title:
Libreoffice calc 4.2.7-0ubunt
** Bug watch removed: freedesktop.org Bugzilla #68566
https://bugs.freedesktop.org/show_bug.cgi?id=68566
** Bug watch removed: freedesktop.org Bugzilla #81309
https://bugs.freedesktop.org/show_bug.cgi?id=81309
--
You received this bug notification because you are a member of Ubuntu
Bugs, w
** Bug watch removed: freedesktop.org Bugzilla #83276
https://bugs.freedesktop.org/show_bug.cgi?id=83276
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1389858
Title:
Libreoffice calc 4.2.7-0ubunt
@Manuel Iglesias Alonso
Both LO 4.1.6.2 and Excel 2013 will change B7=Customer1 after sorting. The
issue is with your spreadsheet NOT with Calc’s sorting function. I have
attached an example of how to correctly design a sortable spreadsheet to meet
your desired goals. By using a lookup function,
Launchpad has imported 74 comments from the remote bug at
https://bugs.freedesktop.org/show_bug.cgi?id=81633.
If you reply to an imported comment from within Launchpad, your comment
will be sent to the remote bug automatically. Read more about
Launchpad's inter-bugtracker facilities at
https://hel
Manuel Iglesias Alonso, as this bug report is closed, and the scope of
it Fix Released as outlined in https://wiki.ubuntu.com/Bugs/Status ,
this report is not scoped to you, your problem, or your attachment.
Hence, please do not attach anything to this report, or make future
comments here.
However
@Luke (lukebenes)
You are probably right but I noticed the described behaviour in existing
spreadsheet documents that behaved as I expected with (OpenOffice) LibreOffice
versions before 4.2.7.
It would be nice if somebody could test the documment, attached to my previous
comment, with Excel and
** Bug watch removed: freedesktop.org Bugzilla #45146
https://bugs.freedesktop.org/show_bug.cgi?id=45146
** Bug watch removed: freedesktop.org Bugzilla #81309
https://bugs.freedesktop.org/show_bug.cgi?id=81309
--
You received this bug notification because you are a member of Ubuntu
Bugs, w
@Manuel Iglesias Alonso
Please refer to:
http://www.dummies.com/how-to/content/looking-up-data-in-excel-2007-with-hlookup-and-vlo.navId-323123.html
Your attached document is designed wrong. This is a classic mistake made
by people who don't understand how spreadsheets function. If you sort it
wit
I know that this bug is closed. But should not you wait for some user
feedback?
In my opinion the updated Libreoffice calc still doesn't work correctly.
As I stated above: "sorting is a tool that allows me to do painlessly what I
could do 'manually' by, laboriously, inserting/removing, cutting an
** Bug watch removed: freedesktop.org Bugzilla #85490
https://bugs.freedesktop.org/show_bug.cgi?id=85490
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1389858
Title:
Libreoffice calc 4.2.7-0ubunt
** Also affects: df-libreoffice via
https://bugs.freedesktop.org/show_bug.cgi?id=81633
Importance: Unknown
Status: Unknown
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1389858
Title:
L
** Bug watch removed: freedesktop.org Bugzilla #85571
https://bugs.freedesktop.org/show_bug.cgi?id=85571
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1389858
Title:
Libreoffice calc 4.2.7-0ubunt
** Changed in: libreoffice (Ubuntu)
Status: Triaged => Fix Released
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1389858
Title:
Libreoffice calc 4.2.7-0ubuntu1 not updating references after
This bug was fixed in the package libreoffice - 1:4.2.7-0ubuntu2
---
libreoffice (1:4.2.7-0ubuntu2) trusty; urgency=medium
* backport search & replace w/ empty performance fix (LP: #1342175)
* add additional backported upstream fixes for fdo#82936, fdo#85282,
fdo#85215, fdo#83
Did verification with the Short test case..
** Tags removed: verification-needed
** Tags added: verification-done
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1389858
Title:
Libreoffice calc 4.2.7
Hello Marc, or anyone else affected,
Accepted libreoffice into trusty-proposed. The package will build now
and be available at
https://launchpad.net/ubuntu/+source/libreoffice/1:4.2.7-0ubuntu2 in a
few hours, and then in the -proposed repository.
Please help us by testing this new package. See
h
** Also affects: libreoffice (Ubuntu Trusty)
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1389858
Title:
Libreoffice calc 4.2.7-0ubuntu1 not updating ref
I just uploaded libreoffice-4.2.7-0ubuntu2~ppa3 with yet another
additional fix for fdo#85215 to the ppa at
https://launchpad.net/~libreoffice/+archive/ubuntu/libreoffice-4-2.
Please test.
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu
@Björn Michaelsen: Thank you.
According to 'Rowan (rwky)', updating to 4.3.4.1 would fix the issue.
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1389858
Title:
Libreoffice calc 4.2.7-0ubuntu1 not u
@Manuel: "Couldn't you update to Libre Office 4.3.4.1?" no, Trusty stays
on LibreOffice 4.2.x.
However this ppa:
https://launchpad.net/~libreoffice/+archive/ubuntu/ppa
usually has the newest upstream LibreOffice available and properly packaged.
While not supported by Canonical, it is clearly bet
@Björn Michaelsen: I said in a previous comment:
> 'Couldn't you update to a (newer) version that has the old sorting style as
> default?'
Couldn't you update to Libre Office 4.3.4.1?
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
h
I downloaded Libre Office 4.3.4.1 from the Libre Office website and that
works as expected.
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1389858
Title:
Libreoffice calc 4.2.7-0ubuntu1 not updating
I've tested the build in the ppa with UpdateReferenceOnSort set to false
and true and it still behaves weirdly. On my precise install which has
3.5.7.2 sorting by the attached spreadsheets 'Days' column keeps
everyting referenced perfectly, with 4.2.7 no matter what I do I can't
get it to keep the
I just uploaded a version with additional fixes for fdo#82936, fdo#85282
to the ppa at
https://launchpad.net/~libreoffice/+archive/ubuntu/libreoffice-4-2. Note
that the configuration switch UpdateReferenceOnSort is still defaulting
to false as I am still waiting for feedback on that.
--
You recei
@Christopher M. Penalver:
Desktop: Cinnamon Mint 17
Libreoffice package: Distro standard update: LO calc 4.2.7.2
OS: 64 bit
apt-show-versions -r libreoffice*
libreoffice-base:amd64/trusty-security 1:4.2.7-0ubuntu1 uptodate
libreoffice-base-core:amd64/trusty-security 1:4.2.7-0ubuntu1 uptodate
libre
@Björn Michaelsen: Sorry it won't happen again.
I thought the article was relevant because it shows that 'new style sorting'
(MANGLING) is a temporary aberration:
SORTING ... MANGLING ... SORTING
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed t
Manuel Iglesias Alonso, in response to
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1389858/comments/30
, thanks for confirming the WORKAROUND works for you. It may very well
be a difference in which combination of packages I have installed, or
desktop environment choice that makes th
@Manuel: Lets not link to articles that dont help triaging or solving
this bug, this is not a mailing list or forum. Thanks.
P.S.: Also note that my fellow ESC and TDF Board member Michael Meeks is
talking in that article about the upstream LibreOffice release, which --
unlike the Ubuntu 4.2.7-0ub
I meant (LO calc 4.2.7.2) in my previous post.
Check this article:
http://www.networkworld.com/article/2845000/opensource-subnet/libreoffice-defends-handling-of-spreadsheet-bug.html
"He stressed that the issue has been corrected – the older sort function will
be enabled by default in future versio
@ Matt Malone & Christopher M. Penalver: I usedthe the script in #17 to
modify (LO calc 4.2.72) '/usr/lib/libreoffice/share/registry/main.xcd'
and it works as expected. Sorting reverted to 'old style sorting'.
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is
Some may arrive here and be confused about that to do, given comments #22 and
#25.
How do I end any possibility of corrupting my spreadsheet with LibreOffice?
This is how
I ended the on-going damage to a years-old spreadsheets. I opened a terminal
and pasted this:
sudo apt-get remove --pur
The longer the current libreoffice calc version stays in popular distros the
more spreadsheet documents will be mangled by sorting. Both distro and
libreoffice will be blamed (and hated).
Couldn't you update to a (newer) version that has the old sorting style as
default?
--
You received this b
@Björn Michaelsen: I would never write something like the example in
http://support2.microsoft.com/kb/40401. I completely agree with 'Matt
Malone': ' If your rows do not represent records that must stay together
and you want a result that cannot be achieved by cutting and pasting
entire rows then y
for reference:
http://support2.microsoft.com/kb/40401
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1389858
Title:
Libreoffice calc 4.2.7-0ubuntu1 not updating references after sort
To manage notif
Björn Michaelsen, to get back to
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1389858/comments/11
, it would appear it is not a a comprehensive WORKAROUND.
In Trusty, after performing the advised edit of main.xcd, and then closing the
file, immediately attempting to open any file, o
My greatest fear now is all those people who still have not realized
this is happening, and, are still in the process or mangling
spreadsheets. Until Libre Office releases a patch retroactively fixes
all 4.2.7.2 installations on all Ubuntu 14.04 installations, AND pops up
a special window when pe
I configured a new machine with Ubuntu 14.04 months ago. I have been gifted
with LibreOffice 4.2.7.2. I was using Ubuntu 12.04 before that, and had
LibreOffice 4.1.something. Before that I was using OpenOffice, before that
Excell, before that Easy-as-123. All of them update references consi
@Björn Michaelsen
> The 4.2.7-0ubuntu1 package should now satisfy the fdo#81633
Please try the attached test file along with the attached test cases in
81633 such as test_offset.ods and Calc bug.ods. None of these work
with Ubuntu's Calc 4.2.7.2, but worked just fine under 4.2.6.
> Apparentl
@Björn Michaelsen: I am reddit OP. I think that distinguishing sorting
behaviour by '(not)adjusting references' is prone to confusion (more
below). I prefer to use 'old' or 'new' style LibreOffice sorting. 'old'
meaning the standard sorting behaviour in all spreadsheet software and
LibreOffice up t
As a clarification TDFs 4.2.7 release _does_ update references, while Ubuntus
4.2.7-0ubuntu1 by default does not (see comment #17 on how to change that). So:
- TDFs 4.2.7 release shows fdo#81633, but not fdo#81309
- Ubuntus 4.2.7-0ubuntu1 by default shows fdo#81309, but not fdo#81633
Both bugs ar
Hi,
this update broke several of my spreadsheets that I use regularly, and
have been using even back with StarOffice, then OpenOffice and finally
LibreOffice for years. While the Ubuntu patch makes it sort in some way
different from the "New LO way of updating References", it still breaks.
This i
Hi Bjoern,
I didn't say the contrary, I said that, with LO 4.3.4.0.0+ and LO
4.4.0.0.alpha1+, it works too as expected if the option is set to false.
It should be the same in LO 4.2.7 because the value false for the option
is intended to be there for backward compatibility. So if it does not
work
@Björn Michaelsen: You are right. As I am not familiar with vim I have
written a bash script to modify
'/usr/lib/libreoffice/share/registry/main.xcd':
#!/bin/bash
FileToModify="/usr/lib/libreoffice/share/registry/main.xcd"
OrgLine='false'
CorrectedLine='true'
mv "$FileToModify" "${FileToModify}.
@JBF: Wrong. If you execute the steps in comment #11 it works as
expected by the proponents of fdo#81309 (Sorting should automatically
adjust references.).
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs
I think that the issue described here has nothing to do with the value
of the option UpdateReferenceOnSort (see bugs fdo#81309 and fdo#81633).
Indeed when tested in the master (version 4.4.0.0.alpha1) it works as
expected (behavior of LO 4.2.6.3) whatever the value of the option is.
Same thing in L
I just want to point out that if sorting (of block in 'test file' above)
were to be done 'by hand' (cutting and pasting rows), the result would
be the same as with the old style LibreOffice sorting.
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed
Björn,
> 1/ LibreOffice did not update references correctly and consistently on sort
> before 4.2.x
You are confusing the issues here. No spreadsheet software consistently updates
or does not update references, because there are many types of references.
However, there is a well established beh
52 matches
Mail list logo
