Bug 158218 - Document is not saved if solely text is pasted since last save
Summary: Document is not saved if solely text is pasted since last save
Status: RESOLVED DUPLICATE of bug 154339
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.5.8.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-11-14 21:20 UTC by jasperh
Modified: 2023-11-28 13:09 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Demonstration of bug 158218 (13.22 MB, video/mp4)
2023-11-17 21:34 UTC, jasperh
Details

Note You need to log in before you can comment on or make changes to this bug.
Description jasperh 2023-11-14 21:20:42 UTC
Description:
When solely text is pasted into LibreOffice Calc since the last save, not all of the changes are saved to the file

Steps to Reproduce:
1. Create an empty document document
2. Save the document
3. Copy some text
4. Paste text to LibreOffice Calc (Notice that the 'document has been modified' is active in the bottom bar) (copy it to every cell apart from A1)
5. Save the document (CTRL + S or Save via the menu) (Notice that the 'document has been modified' is inactive in the bottom bar)
6. Reopen the document (with LibreOffice Calc or a text editor)

Actual Results:
The recent changes are not saved

Expected Results:
The opened document should match the saved the document, and include the pasted text


Reproducible: Always


User Profile Reset: No

Additional Info:
A few observations:

- Only when the changes since the last save solely consist of pasted text, the changes are not saved. Once it contains a mix of pasted text and changed fields, the changes save fine
- Sometimes the file is correctly saved, this seems to be related if the pasted cell is within the range of the previously saved document
For example. The csv already contains a value in cell A5. When a value is copied to both A4(within the range) and A6 (outside of the range). On save only A4 is written to the file, the value of A6 is ignored
Comment 1 m_a_riosv 2023-11-14 22:40:45 UTC
I can not reproduce
Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: c60a9db1f2a8e2a088c6b89bcdff4901b28f2864
CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: default; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded

Please test in safe mode, Menu/Help/Restart in Safe Mode
Please can you paste the information in Menu/Help/About LibreOffice, there is an icon to copy.
Comment 2 jasperh 2023-11-15 20:59:49 UTC
Thanks for the quick reply m.a.riosv, really appreciated

I just tested in the safe mode as you described, and I'm still able to reproduce the issue

Would a video showing the issue be helpful?

The build / system info as requested:
Version: 7.5.8.2 (X86_64) / LibreOffice Community
Build ID: 50(Build:2)
CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: kf5 (cairo+xcb)
Locale: en-US (C); UI: en-US
7.5.8-1
Calc: threaded
Comment 3 m_a_riosv 2023-11-15 23:35:43 UTC
Could be, just try.
Comment 4 jasperh 2023-11-17 21:34:07 UTC
Created attachment 190893 [details]
Demonstration of bug 158218

This is a demonstration of this bug

Please note that I saved to a .csv file. I'm not able to reproduce the bug when writing to a .ods file for example
The program on the right automatically updates when the file is updated

(when re watching the video it was really hard to watch how I struggled with finding the "paste" button through the interface)

The version to reproduce this bug was:
Version: 7.5.8.2 (X86_64) / LibreOffice Community
Build ID: 50(Build:2)
CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: kf5 (cairo+xcb)
Locale: en-US (C); UI: en-US
7.5.8-1
Calc: threaded
Comment 5 m_a_riosv 2023-11-18 12:32:06 UTC
It works fine for me if after save I use Menu/File/Reload.

Maybe if after the file is saved, and not closed, it is not modified in the system, and the other program can see it was change.
Comment 6 jasperh 2023-11-18 13:27:48 UTC
When I close the file and reopen it (instead of using another program to view the contents of the file) the pasted text is also missing.

The meta data of the document is however updated (I see a new "recently edited" date). The other program also refreshes when I save the document.

I only used the other program to show the problem a bit easier

I also noticed that it makes a difference if the pasted text is "another cell" or if it's plain text from outside of libreoffice calc
If the content of another cell is copied, the document is saved correctly
Comment 7 Buovjaga 2023-11-28 13:08:46 UTC

*** This bug has been marked as a duplicate of bug 154339 ***