Disappearing Page Reference

users
#1

Folks,

I have a multi-page spread sheet that has page references for selected cells. Lately I have noticed that the page identifier is dropped from the referencing cell. I will include an example:

  Original definition: =Summary.E28
  Resulting entry: =E28

As long as the cell is not updated the resulting value remains what it was when the definition was created; so unless I happen to look at them I am totally unaware that any thing is wrong.

There are about 20 cells that are in single a column on the target page, all of them lose the page reference. This has happened multiple times and in other areas of the spread sheet as well. I am at a loss of what could be the problem.

Ideas are appreciated.

I am using Ubuntu 14.04.1 LTS with a Cinnamon desktop and
  LibreOffice 4.2.72 Build ID: 420m0(Build: 2)

#2

See https://www.libreoffice.org/bugzilla/show_bug.cgi?id=86125 . Update to 4.2.8 or 4.3?

I trust this helps.

Brian Barker

#3

The link says: "2014-12-01 14:20:51 UTC Adjusted in 4.3, 4.4 4.5 master, and now a final 4.2.8 releases."

I can confirm this bug is still in version 4.3.3.2 - the up to date version for Ubuntu 14.10. Dragging cells to another sheet tab gives strange errors and results. I'll wait for an update but if it is a showstopper for Jay he may want to use backports.

#4

As far as I can tell the bug is not present in LibreOffice 4.4.0.1 (under
Linux Mint 17)

Graham