Bug 144898 - EDITING: Using Alt+Enter to input multiple cells overwrites comments
Summary: EDITING: Using Alt+Enter to input multiple cells overwrites comments
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.8.2 release
Hardware: All Windows (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Comments
  Show dependency treegraph
 
Reported: 2021-10-03 17:41 UTC by Ming Hua
Modified: 2024-09-11 09:45 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Sample file with comments in three cells (8.94 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-10-03 17:41 UTC, Ming Hua
Details
Screencast (7.28 MB, video/mp4)
2021-10-04 11:40 UTC, Ming Hua
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Ming Hua 2021-10-03 17:41:13 UTC
Created attachment 175482 [details]
Sample file with comments in three cells

Description:
Calc provides Alt+Enter shortcut to input content for multiple cells, propagating the input of the current cell to all the selected cell range.  However it seems this way of inputting would delete/overwrite the existing comments for the selected cells.

Steps to Reproduce:
1. Open attached sample file.  It has three non-empty cells, A1 to A3, all having comments attached;
2. (Optional) Click on cell A1, type some text to change the cell content, press Enter key.  The cell content is replaced, the comment stays intact;
3. Use mouse to select all three cells A1 to A3.  Depending on how one selects the range, the "active" cell for editing may be A1 or A3, it doesn't matter.  Now type some text, it should change the content of the active cell.  Press Alt+Enter, all three cells now have the new text, but the comments attached to them are all gone.

Expected Result:
In step 3, Alt+Enter should change the cell contents, but leave the comments intact, just like using Enter to change a single cell's content in step 2.

Version Information:
Reproduced in both 7.0.6 and 7.3/master daily build:
Version: 7.0.6.2 (x64)
Build ID: 144abb84a525d8e30c9dbbefa69cbbf2d8d4ae3b
CPU threads: 2; OS: Windows 10.0 Build 19043; UI render: default; VCL: win
Locale: zh-CN (zh_CN); UI: en-US
Calc: threaded
and
Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: a9cc066a86c6bd3423c5802c5a4eded55a50c754
CPU threads: 2; OS: Windows 10.0 Build 19043; UI render: default; VCL: win
Locale: zh-CN (zh_CN); UI: zh-CN
Calc: threaded
Comment 1 Xisco Faulí 2021-10-04 09:49:14 UTC
I can't reproduce it in

Version: 7.3.0.0.alpha0+ / LibreOffice Community
Build ID: af291666b3316aba2b35d3b8358f4cd42c553587
CPU threads: 4; OS: Linux 5.10; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

nor in

Version: 7.2.0.4 (x86) / LibreOffice Community
Build ID: 9a9c6381e3f7a62afc1329bd359cc48accb6435b
CPU threads: 2; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default; VCL: win
Locale: ar-DZ (es_ES); UI: es-ES
Calc: threaded
Comment 2 Ming Hua 2021-10-04 11:06:24 UTC
(In reply to Xisco Faulí from comment #1)
> I can't reproduce it in
> 
> Version: 7.3.0.0.alpha0+ / LibreOffice Community
> 
> nor in
> 
> Version: 7.2.0.4 (x86) / LibreOffice Community
Hmm.  Re-tested 7.3/master with a fresh user profile and still reproduce:

Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: a9cc066a86c6bd3423c5802c5a4eded55a50c754
CPU threads: 2; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: zh-CN (zh_CN); UI: zh-CN
Calc: threaded

If any more information is needed from me to help reproducing (maybe I'm missing a key step?), let me know.
Comment 3 Xisco Faulí 2021-10-04 11:24:29 UTC
Could you please attach a screencast showing the problem ?
Comment 4 Ming Hua 2021-10-04 11:40:56 UTC
Created attachment 175497 [details]
Screencast

(In reply to Xisco Faulí from comment #3)
> Could you please attach a screencast showing the problem ?
Sure, attached.  I captured it using Windows's built-in Game Bar program, which doesn't seem to able to catch pop-up menus.  Hope it's good enough to show the problem.
Comment 5 yellowplane 2021-10-13 15:40:33 UTC
Following the exact steps provided, I could reproduce in

Version: 7.3.0.0.alpha0+ (x86) / LibreOffice Community
Build ID: d5e55d204b71710eb5eb5d2c683dd6698626df3c
CPU threads: 8; OS: Windows 10.0 Build 19042; UI render: Skia/Vulkan; VCL: win
Locale: en-GB (en_US); UI: en-US
Calc: threaded
Comment 6 Ming Hua 2021-10-15 05:49:28 UTC
Tested 6.2.8 and also reproducible:
Version: 6.2.8.2 (x64)
Build ID: f82ddfca21ebc1e222a662a32b25c0c9d20169ee
CPU threads: 2; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: zh-CN (zh_CN); UI-Language: en-US
Calc: threaded
Comment 7 Galuxttor 2022-09-11 16:54:20 UTC
Reproducible in:

Version: 7.3.6.2 (x86) / LibreOffice Community
Build ID: c28ca90fd6e1a19e189fc16c05f8f8924961e12e
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default; VCL: win
Calc: threaded


Version: 7.4.0.0.beta1 (x86) / LibreOffice Community
Build ID: cec1fe9b57a55c032f9f118c907f34e22a63d040
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Calc: threaded
Comment 8 QA Administrators 2024-09-11 03:16:14 UTC Comment hidden (obsolete)
Comment 9 Ming Hua 2024-09-11 09:45:12 UTC
I've changed my computer since reporting this bug. However, on the new computer, I can reproduce with version 7.0:

Version: 7.0.6.2 (x64)
Build ID: 144abb84a525d8e30c9dbbefa69cbbf2d8d4ae3b
CPU threads: 12; OS: Windows 10.0 Build 22631; UI render: default; VCL: win
Locale: zh-CN (zh_CN); UI: en-US
Calc: CL

But I can NOT reproduce with version 7.6, where Alt-Enter works as expected, changing all contents in three cells and leaving the comments intact.

Version: 7.6.7.2 (X86_64) / LibreOffice Community
Build ID: dd47e4b30cb7dab30588d6c79c651f218165e3c5
CPU threads: 12; OS: Windows 10.0 Build 22631; UI render: Skia/Vulkan; VCL: win
Locale: zh-CN (zh_CN); UI: en-US
Calc: CL threaded

I'll resolve this as WORKSFORME.