← Back to team overview

desktop-packages team mailing list archive

[Bug 1389858] Re: Libreoffice calc 4.2.7-0ubuntu1 not updating references after sort

 

@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='<prop oor:name="UpdateReferenceOnSort" oor:type="xs:boolean" oor:nillable="false"><value>false</value></prop>'
CorrectedLine='<prop oor:name="UpdateReferenceOnSort" oor:type="xs:boolean" oor:nillable="false"><value>true</value></prop>'

mv "$FileToModify" "${FileToModify}.bak"
cat ${FileToModify}.bak | sed 's%'"${OrgLine}"'%'"${CorrectedLine}"'%g' >"$FileToModify"

######### END OF SCRIPT ################

Use it this way:
sudo ./Script

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1389858

Title:
  Libreoffice calc 4.2.7-0ubuntu1 not updating references after sort

Status in “libreoffice” package in Ubuntu:
  Triaged

Bug description:
  Update to LibreOffice 4.2.7 is causing incorrect sort behaviour in
  Calc.

  As initially reported here:

  http://www.reddit.com/r/Ubuntu/comments/2le7qu/libreoffice_calc_update_a_few_hours_ago_is_buggy/

  Attached is sample Calc document. To reproduce, highlight B6 to E14,
  select Sort and sort by Column D, see that column E didn't get sorted.

  ProblemType: Bug
  DistroRelease: Ubuntu 14.10
  Package: libreoffice (not installed)
  ProcVersionSignature: Ubuntu 3.16.0-24.32-generic 3.16.4
  Uname: Linux 3.16.0-24-generic x86_64
  ApportVersion: 2.14.7-0ubuntu8
  Architecture: amd64
  CurrentDesktop: Unity
  Date: Wed Nov  5 15:49:03 2014
  InstallationDate: Installed on 2013-11-26 (344 days ago)
  InstallationMedia: Ubuntu 13.10 "Saucy Salamander" - Release amd64 (20131016.1)
  SourcePackage: libreoffice
  UpgradeStatus: Upgraded to utopic on 2014-10-08 (27 days ago)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1389858/+subscriptions


References