Bug 87687

Summary: Merging cells does not move references in equations (Comment 6)
Product: LibreOffice Reporter: dazky <dazky>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: gerard.fargeot, jmadero.dev, mahfiaz, miguelangelrv, raal, xiscofauli
Priority: medium    
Version: Inherited From OOo   
Hardware: All   
OS: All   
See Also: https://bugs.documentfoundation.org/show_bug.cgi?id=89951
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 108320, 108917    
Attachments: example merging cells
Ssmple file
sample with comment
Simple Merge Example

Description dazky 2014-12-24 20:56:35 UTC
Created attachment 111298 [details]
example merging cells

When I merged cells, some formula stopped working.
I send an example in attachment.


Similar as Bug 72121
Comment 1 m_a_riosv 2014-12-25 22:25:57 UTC
Created attachment 111337 [details]
Ssmple file

Please @dazky, what is stopping?
D18=sum(D14:D17)=0
cells in D14:D17 are empty.

When merging cells having values/formulas in cells to be hide a question about move the content of hidden cells to the first is showed, answering not hidden cells keep their values/formulas.

See in columns K+J in your modified sample file.
Comment 2 raal 2014-12-28 18:23:51 UTC Comment hidden (obsolete)
Comment 3 dazky 2015-01-01 11:54:33 UTC Comment hidden (obsolete)
Comment 4 dazky 2015-01-01 12:00:02 UTC
Created attachment 111607 [details]
sample with comment

I added an sample, if this is a bug, then I will come this behavior inappropriate and a possible source of error. MS Excel works a little differently ...
Comment 5 Joel Madero 2015-10-16 03:32:04 UTC Comment hidden (obsolete)
Comment 6 mahfiaz 2016-04-19 05:54:51 UTC
Created attachment 124484 [details]
Simple Merge Example

To reproduce:

1. Type something in B1
2. Type =B1 in B2
3. Merge A1:B1
4. Notice that Calc does not move reference in B2 from =B1 to =A1 while Excel does.

See the attached Simple Merge Example document.
Comment 7 QA Administrators 2017-05-22 13:26:16 UTC Comment hidden (obsolete)
Comment 8 Xisco FaulĂ­ 2017-07-13 11:00:29 UTC Comment hidden (obsolete)
Comment 9 QA Administrators 2018-07-14 02:46:32 UTC Comment hidden (obsolete)
Comment 10 mahfiaz 2018-07-24 13:01:38 UTC Comment hidden (obsolete)
Comment 11 QA Administrators 2019-07-30 03:13:50 UTC Comment hidden (obsolete)
Comment 12 mahfiaz 2019-07-30 11:24:18 UTC
Still not working in 6.2.4.2
Comment 13 Tex2002ans 2022-09-26 01:14:41 UTC
Still not working. Followed steps in comment #6.

Version: 7.4.1.2 (x64) / LibreOffice Community
Build ID: 3c58a8f3a960df8bc8fd77b461821e42c061c5f0
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