Hi All,
===========================================
I am using Libreoffice 7.2.1.2 on the following machine and system:

Kubuntu

NAME="Ubuntu"
VERSION="20.04.3 LTS (Focal Fossa)"
ID=ubuntu
ID_LIKE=debian
PRETTY_NAME="Ubuntu 20.04.3 LTS"
VERSION_ID="20.04"

Linux version 5.4.0-88-generic (buildd@lgw01-amd64-008) (gcc version 9.3.0 (Ubuntu 9.3.0-17ubuntu1~20.04)) #99-Ubun
tu SMP Thu Sep 23 17:29:00 UTC 2021

Architecture: *******************x86_64
CPU op-mode(s): *****************32-bit, 64-bit
Byte Order: *********************Little Endian
Address sizes: ******************36 bits physical, 48 bits virtual
CPU(s): *************************4
On-line CPU(s) list: ************0-3
Thread(s) per core: *************1
Core(s) per socket: *************4
Socket(s): **********************1
NUMA node(s): *******************1
Vendor ID: **********************GenuineIntel
CPU family: *********************6
Model: **************************58
Model name: *********************Intel(R) Core(TM) i5-3570 CPU @ 3.40GHz
===========================================

It’s hard to know when to stop adding info.

Created many years ago, I have a ‘Calc’ document that I use regularly as a data base to keep track of my Karate students.

The sheet has many columns. The first, the names and the very last is an internal hyperlink to an odt file in that students name.

All has been well through the twenty years I’ve been using it, even through the change from OpenOffice to LibreOffice.

I have accepted all suggested updates from Libreoffice and now find that the registration of the notes, (last column), and the names, (first columns), has shifted out of kilter by two or three names!
See picture.

I can, of course, go and edit every entry to correct the problem but without knowing what has happened, and why, it is likely to happen again.

If anyone has any ideas concerning this I would appreciate them sharing it with me.

Regards

Chris

Ps. I intended to attach a picture but, oddly enough, this site does not accept the native format of Linux GNU! I can only save files as type xcf'.

What happens when you open the spreadsheet in another application, say Gnumeric, or Windows Word?
Also, take care to not save (overwrite) the original spreadsheet with the new LO version, experiment with a copy instead.

Hi ondoho,

It took time to install Gnumeric but the same problem exists there and in windows too.

Export the xcf file to jpg and post the picture so we can see the problem.

Ugh - jpg is awful to view (here).
Would one be safe to assume there is no (long-term) backup one could use to run tests against ?.

So the question is, did you overwrite the original spreadsheet with something that the updated LO produced?
(You can check the file's timestamps)
And if yes, then the bigger question is, do you still have the original?

Hi syg00, I am unable to see the jpg I posted.

One would NOT be safe in assuming lack of backups. I have many.

Opening any of those backups presents the files in the order I expect.

Ondoho hi,

It is my assumption that I did what you suggest, unwittingly of course.

Accessing the information does not often require me to look at the Last column, and so, any save I may have made could have embedded the error.

I do not back up after every alteration or save.

My question is, How would one cause a shift of the nature I've described?

I have not lost any data, I ha-e restored the file, and all is well.

Now, the day I discovered this occurrence, I noticed one more odd LibreOffice behaviour.

In 'Write', whaen I attempted to use an inverted comma, it appeared at the base of the characters and not at the top.

Being in a hurry, I simply copied and pasted inverted commas from elsewhere, however, next time I opened Write, there were no problems of that nature.

There may be no connection of course, thought it useful to add.

You can only attach files with the formats gif, jpeg, jpg, log, pdf, png or txt. If you click on the "Go Advanced" button you can attach a file.