Bug 120655 - EDITING: Shared spreadsheet, after put something in a cell and change cell background in another, format change is saved when it shouldn't
Summary: EDITING: Shared spreadsheet, after put something in a cell and change cell ba...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Sheet
  Show dependency treegraph
 
Reported: 2018-10-17 09:12 UTC by m_a_riosv
Modified: 2023-06-03 19:08 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
screenshot (34.99 KB, image/png)
2023-05-29 16:09 UTC, BogdanB
Details

Note You need to log in before you can comment on or make changes to this bug.
Description m_a_riosv 2018-10-17 09:12:38 UTC
Description:
In shared spreadsheet format changes shouldn't be saved.

But after put something in a cell and change cell background cell to the right, format change is saved.

Steps to Reproduce:
1.Open a new spreadsheet and save with any name.
2.Menu/Tools/Share
3.Introduce 1 in cell A1
4.Change background color in B1
5.Save the file
6.Reload the file
7.B1 background color was saved - bug.
8.Change color in C1
9.Save the file
10.Reload the file
11.C1 background color was not saved - fine.


Actual Results:
With some circumstances format changes can be saved in share mode.

Expected Results:
Format changes not saved in share mode.


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 Durgapriyanka 2018-11-16 18:21:41 UTC
I can confirm that the bug is present.

Version: 6.0.6.2
Build ID: 0c292870b25a325b5ed35f6b45599d2ea4458e77
CPU threads: 2; OS: Windows 6.1; UI render: default; 
Locale: en-US (en_US); Calc: group
Comment 2 QA Administrators 2019-11-17 03:32:34 UTC Comment hidden (obsolete)
Comment 3 m_a_riosv 2019-11-17 23:19:38 UTC
Still
Version: 6.4.0.0.alpha0+ (x64)
Build ID: d744838991594eebe27acc4c7d9fb4579d654853
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2019-09-29_05:12:00
Locale: es-ES (es_ES); UI-Language: en-US Calc: threaded
Comment 4 QA Administrators 2021-11-17 05:12:04 UTC Comment hidden (obsolete)
Comment 5 BogdanB 2023-05-29 16:09:32 UTC
Created attachment 187589 [details]
screenshot

Also in
Version: 7.6.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: 583c3fcea50b69ca9d3cd866050c9e722a8f780b
CPU threads: 16; OS: Linux 5.19; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded

We have a warning, as in the screenshot, that the format will not be saved, so, indeed, the bug is in step 7.