Bug 152718 - Curve auto numbering on merged cells
Summary: Curve auto numbering on merged cells
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.5.1.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-12-29 12:49 UTC by Ruslan
Modified: 2023-10-27 03:13 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Screenshot of case 1 (6.21 KB, image/png)
2023-03-29 12:31 UTC, Buovjaga
Details
Screenshot of case 2 (4.74 KB, image/png)
2023-03-29 12:32 UTC, Buovjaga
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Ruslan 2022-12-29 12:49:35 UTC
Description:
If you have rows merged into one cell and they are numbered, then if you apply auto-numbering (pull down the selected cells with content 1,2, ...) - the union breaks on one of the cells and the numbering starts to fall out of these cells.

Steps to Reproduce:
GIF: https://drive.google.com/file/d/1_PkByVgrGtxXi6RRfWrokml7dsv2coAv/view?usp=sharing

Actual Results:
Cells with numbering have shifted and the merging of cells next to each other has broken

Expected Results:
All cells remain in their places, only their contents change.


Reproducible: Always


User Profile Reset: No

Additional Info:
.
Comment 1 Lesline 2023-01-30 22:31:51 UTC
Hello Ruslan.

Thank you for reporting the bug.

I'd like to ask if you can kindly provide the written instructions for steps you are taking to merge the cells as it is not entirely apparent from the video.  The rest of the process is understood.  

I'll set the bug's status to 'NEEDINFO'. Please can you change it back to 'UNCONFIRMED' once the steps are provided.  

Many thanks!
Comment 2 Lesline 2023-02-06 22:56:35 UTC
Hello Ruslan.

I was able to merge the cells and test as outlined.  I wasn't able to reproduce the bug using the following versions:

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: a834bbad8295cba0ca88a91a524aad48640271ec
CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded

Version: 7.4.3.2 (x64) / LibreOffice Community
Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890
CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded



I have set the status back to 'UNCONFIRMED'.

Kind Regards
Comment 3 Ruslan 2023-03-03 18:17:27 UTC
Hello. Sorry for the long answer!

Please try to reproduce the steps below.

Case 1:
1.1) Fill in cells A1:A6 and B1:B6 with values from 1 to 6
1.2) Merge in each column cells 2 and 3 with "Keep contents of hidden cells" option
1.3) Merge cells 4 and 5 similarly to paragraph 1.2
1.4) Select cells A1 and A2
1.5) Pull down to A8
1.6) We observe how cell A4 is equal to half of the cell with the value 4 of column B.

Case 2:
2.1) Undo action 1.5
2.2) Select cells A1 and A2
2.3) Drag down to cell A4
2.4) We observe how the values ​​of cell A5 overlap each other

     This is not a completely correct display. In Excel, if this behavior is reproduced, an error occurs "To do this, all merged cells must have the same size"
Comment 4 Buovjaga 2023-03-29 12:31:19 UTC
Created attachment 186283 [details]
Screenshot of case 1
Comment 5 Buovjaga 2023-03-29 12:32:36 UTC
Created attachment 186284 [details]
Screenshot of case 2
Comment 6 Buovjaga 2023-03-29 12:33:07 UTC
Based on the screenshots, I guess you agree that I don't get the problem?

Please copy and paste here the contents of your Help - About (LibreOffice - About on macOS) by clicking the copy button. This allows us to know more about your system.

Set to NEEDINFO.
Change back to UNCONFIRMED after you have provided the information.

Arch Linux 64-bit, X11
Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: f51b220b953ec71fb742f799fbe645a93cf3d944
CPU threads: 8; OS: Linux 6.2; UI render: default; VCL: gtk3
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 29 March 2023
Comment 7 QA Administrators 2023-09-26 03:14:28 UTC Comment hidden (obsolete)
Comment 8 QA Administrators 2023-10-27 03:13:40 UTC
Dear Ruslan,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team

MassPing-NeedInfo-FollowUp