Bug 117985 - Cell comment created in row 66054 (or lower) appears at row 198160
Summary: Cell comment created in row 66054 (or lower) appears at row 198160
Status: VERIFIED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.0.3 release
Hardware: All Windows (All)
: high major
Assignee: Not Assigned
URL:
Whiteboard: target:7.2.0 target:7.1.0
Keywords: preBibisect, regression
Depends on:
Blocks: Calc-Comments
  Show dependency treegraph
 
Reported: 2018-06-03 18:46 UTC by slavaf2000
Modified: 2021-06-04 13:51 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:


Attachments
Video demonstrating behvaior (3.17 MB, video/mp4)
2018-06-04 19:32 UTC, slavaf2000
Details

Note You need to log in before you can comment on or make changes to this bug.
Description slavaf2000 2018-06-03 18:46:13 UTC
Description:
When creating a comment in row row 66054 or further below, the comment actually appears at row 198160. Creating a comment below 66054 will result in the comment box appearing below row 198160.

Steps to Reproduce:
1. Create a new spreadsheet
2. Righ-click on cell A66054 and click "Insert Comment"

Actual Results:  
Comment box appears at cell A198160

Expected Results:
Comment box appears at cell A66054


Reproducible: Always


User Profile Reset: No



Additional Info:
Appears to affect all rows below 66054 (inclusive)


User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:60.0) Gecko/20100101 Firefox/60.0
Comment 1 Xisco Faulí 2018-06-03 22:43:58 UTC
I can't reproduce it in

Version: 6.1.0.0.beta1+
Build ID: 2a0d8106a558845357d39648656e08ec6f091cf8
CPU threads: 4; OS: Linux 4.13; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); Calc: group threaded

nor in


Version: 6.0.4.2
Build ID: 1:6.0.4~rc2-0ubuntu0.16.04.1
CPU threads: 4; OS: Linux 4.13; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); Calc: group


Could you please try to reproduce it with the latest version of LibreOffice
from https://www.libreoffice.org/download/libreoffice-fresh/ ?
I have set the bug's status to 'NEEDINFO'. Please change it back to
'UNCONFIRMED' if the bug is still present in the latest version.
Comment 2 Xavier Van Wijmeersch 2018-06-04 07:24:19 UTC
no repro with

Version: 5.4.8.0.0+
Build ID: cc68977f1be22ac0f4a15eb37e05ccba13a7a554
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:libreoffice-5-4, Time: 2018-05-12_11:32:19
Locale: nl-BE (en_US.UTF-8); Calc: group
Comment 3 slavaf2000 2018-06-04 19:32:29 UTC
Created attachment 142525 [details]
Video demonstrating behvaior
Comment 4 slavaf2000 2018-06-04 19:56:42 UTC
Exactly the same behavior in version 6.0.4.2. See video demonstrating issue in my previous comment.
Comment 5 Xisco Faulí 2018-06-04 22:29:26 UTC
Thank you very much for the video.

I can't reproduce it on Linux but I can on Windows

Versión: 6.0.4.2
Id. de compilación: 9b0d9b32d5dcda91d2f1a96dc04c645c450872bf
Subprocs. CPU: 1; SO: Windows 6.1; Repres. IU: predet.; 
Configuración regional: es-ES (es_ES); Calc: group

and

Version: 6.1.0.0.alpha1+
Build ID: ecf50fe71596c3edba8ce437481ab80ae1cd8935
CPU threads: 1; OS: Windows 6.1; UI render: default; 
TinderBox: Win-x86@42, Branch:master, Time: 2018-05-07_23:52:08
Locale: es-ES (es_ES); Calc: group

and

Versión: 4.4.0.3
Id. de compilación: de093506bcdc5fafd9023ee680b8c60e3e0645d7
Configuración regional: es_ES

but not in

LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
Comment 6 Xisco Faulí 2018-06-04 22:30:10 UTC
@Eike, would you mind taking a look at this issue. It seems it has been around for some time and it's only happening on Win
Comment 7 Eike Rathke 2018-06-05 11:39:12 UTC
If it happens only on Windows I'm the wrong person to ask ;-)
Comment 8 Xisco Faulí 2018-06-05 16:16:04 UTC
Also reproducible in

Versión: 4.1.6.2
Id. de compilación: 40ff705089295be5be0aae9b15123f687c05b0a
Comment 9 arthur13 2018-11-29 09:37:00 UTC
Bug confirmed
Version: 6.3.0.0.alpha0+ (x64)
Build ID: 0f25a3c36f27fd51453b9a9115f236b83c143684
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2018-11-27_20:06:55
Locale: zh-TW (zh_TW); UI-Language: en-US
Calc: threaded
Comment 10 Aron Budea 2018-12-09 06:16:02 UTC
Bug is already in 4.0.0.3, and not in 3.6.0.4, but since it's Win-only, it's not bibisectable due to no bibisect repo existing this far back.
Comment 11 Marqeaux 2019-04-29 23:43:19 UTC
Still present in LibreOffice 6.2.3.2. on Windows 7. Tried to reproduce it on LibreOffice 6.2.3.2 on Linux (Manjaro 18.0.4), but this behaviour wasn't there. adding a comment in row 66054 behaved correctly.

Seems like only the Windows build of LibreOffice is still affected?
Comment 12 Xisco Faulí 2019-04-30 06:28:28 UTC
(In reply to Marqeaux from comment #11)
> Still present in LibreOffice 6.2.3.2. on Windows 7. Tried to reproduce it on
> LibreOffice 6.2.3.2 on Linux (Manjaro 18.0.4), but this behaviour wasn't
> there. adding a comment in row 66054 behaved correctly.
> 
> Seems like only the Windows build of LibreOffice is still affected?

Yes, this is a win only problem
Comment 13 Telesto 2020-04-12 17:03:45 UTC
No change
Version: 7.0.0.0.alpha0+ (x64)
Build ID: 95ec2e9b024ff12a3005777c902d7e0975460b1d
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win; 
Locale: nl-NL (nl_NL); UI-Language: en-US
Calc: CL

For the record. Add a comment in A1048576 and the sheet expands with gray area
Comment 14 Andreas Heinisch 2021-04-07 20:13:21 UTC
Reproducible in:
Version: 7.0.0.3 (x64)
Build ID: 8061b3e9204bef6b321a21033174034a5e2ea88e
CPU-Threads: 6; BS: Windows 10.0 Build 19042; UI-Render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: CL

but not reproducible in:
Version: 7.1.0.3 (x64) / LibreOffice Community
Build ID: f6099ecf3d29644b5008cc8f48f42f4a40986e4c
CPU threads: 6; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: CL

nor in 

Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: bcdd9145d487d5b162a360f3adb1eaf7250c18c9
CPU threads: 6; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: en-US
Calc: CL
Comment 15 Xisco Faulí 2021-04-09 07:53:36 UTC
This issue got fixed by 

https://cgit.freedesktop.org/libreoffice/core/commit/?id=3d90997fb6f232d8008df4d166d7b97b869c200f

author	Noel Grandin <noel@peralex.com>	2020-10-28 08:30:36 +0200
committer	Noel Grandin <noel.grandin@collabora.co.uk>	2020-11-11 06:34:17 +0100
commit 3d90997fb6f232d8008df4d166d7b97b869c200f (patch)
tree d26a1756dac5b7b55fac0f4322fe25ea02e9017e
parent 3de38e95561ab7ca114d9f3307702ba89c4e3e9a (diff)
make tools::Long 64-bit on Windows platform


@Noel, thanks for fixing this issue!!
Comment 16 BogdanB 2021-06-04 13:51:51 UTC
It's ok now.

Verified in
Version: 7.2.0.0.alpha1+ (x64) / LibreOffice Community
Build ID: 3b57ebb445df8a2bc3d916ea79f8af45e20e4e62
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: ro-RO (ro_RO); UI: en-US
Calc: threaded