https://bugs.documentfoundation.org/show_bug.cgi?id=106641
--- Comment #3 from John ---
In response to email request for the affected file, my bounced email response
was:
Sadly I only use spreadsheets nowadays, except for simulation purposes on rare
occasions, saved as xls files, for my financial records and as an address book,
so it is not practical to send you these without confidential information.
Also, an attempt to do so in affected cells normally removes all content from
the cell, but not always.
On the day of creating my bug report, I had to save my open updated xls address
book in ods format so as to retrieve an accidentally ‘deleted’ cell entry
(because of the LibreOffice odd behaviour). Sadly, only to find that all the
work I had done and 'saved' in the ods format had gone.
Further oddities include:
1) I added numerous phone numbers to my address book, manually, by copying from
my mobile phone and saving frequently. However, afterwards when looking up at
least three entries that were made, they could not be found: they simply were
not saved. I made one entry just now, saved and closed and re-opened the
spreadsheet and that entry was present. This has happened a few times in the
past that I know about. I of course normally assume a save is successful. The
only impression I have at the moment is that multiple new entries / updates
when saved may not be saved, a few every so often may or may not, but one may
be.
2) When I searched for one of the new entries by looking up the old phone
number, the old phone number was found in the formulae bar as wrapped text, but
after leaving the formulae bar, the entry in the formulae bar became a single
line with grey background just as it appears in the cell itself. So a search
result can locate an item that will open as wrapped in the formulae bar, but
will revert to a link style entry on leaving it. Re-selecting the cell does not
change the link style un-editable entry in the formulae bar or cell itself.
3) When I selected a person’s name in the formulae bar to copy it, my MacBook
Pro ‘Edit’ button in the menu bar ‘flashed' to confirm that I had supposedly
copied it, but it only pasted the phone number that I had previously copied to
try and find that person’s new phone number. Repeated copy-paste failed to copy
and past the selection, only pasting the previously copied phone number!
4) Worse still, today one sheet of my spreadsheet has become completely greyed
out-out with no lines or entries visible even after quoting the application and
re-opening it.
One particular sheet has a different problem: about ten years ago I started
using OpenOffice but reverted back to Microsoft Office as a result of a form of
corruption that I have not yet cleared up: some original xls row entries with
multiple paragraphs in a single wrapped text cell after being saved resulted in
some cells with multiple paragraphs, but not all cells like this, becoming
separate cells, one for each paragraph, so messing up the possibility of using
the Sort facility to bring together similar entries. What is particularly odd
about this is that these multiple cells one below the other corresponding to
the separate paragraphs in the original xls file appear adjacent to a single
cell on their left or right, as if the single cell were a merged cell but is
not!
Sorry I can’t help further.
--
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
