Bug 145649

Summary: Copy-paste 323 columns chrome/mozilla: corrupted result
Product: LibreOffice Reporter: tim <tkomyakov>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED INSUFFICIENTDATA    
Severity: normal CC: 79045_79045, miguelangelrv, raal, tkomyakov
Priority: medium    
Version: unspecified   
Hardware: x86-64 (AMD64)   
OS: Linux (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: unexpected behaviour 323 columns html
321 column example - as expected
no error 321 column
error 323 column

Description tim 2021-11-12 19:37:50 UTC 
Description:
Copy-paste internet-browser <table> contains 323 and more columns to Calc: first row will be ok, other rows will be have strange column joins


Steps to Reproduce:
1. 323 columns html example https://pastebin.com/DeR2AAuL save as raw file
2. open file as html in your browser (chrome, mozilla)
3. select all (ctrl-a) and copy
4. paste at A1
Result: first row will be ok, other rows: first column ok, then joined columns and other data

5. clean behaviour- 321 columns https://pastebin.com/qemBsAd6 save as raw file
6. open file as html in your browser (chrome, mozilla)
7. select all (ctrl-a) and copy
8. paste at A1
Result: correct table, without joins

Actual Results:
Html 323 columns <table> pasted corrupted: unexpected cells joins at 2nd and down rows

Expected Results:
323 and more columns * rows_count = unjoined cells (html does not contains cell joins)


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
[Information automatically included from LibreOffice]
Locale: ru
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes
Comment 1 tim 2021-11-12 19:45:07 UTC 
Created attachment 176219 [details]
unexpected behaviour 323 columns html
Comment 2 tim 2021-11-12 19:47:49 UTC 
Created attachment 176220 [details]
321 column example - as expected
Comment 3 m_a_riosv 2021-11-14 14:20:39 UTC 
The last two columns are in the download htm file but not in the raw data.
2021-04-01	v2021-04-01
127,69	1 126 400
32,23	5 482 100
7,34	1 928 600

So I think there it's not a bug.

And please don't set up yourself as NEW someone else must reproduce the bug and put as new.
Comment 4 tim 2021-11-14 15:35:25 UTC 
Created attachment 176247 [details]
no error 321 column
Comment 5 tim 2021-11-14 15:35:53 UTC 
Created attachment 176248 [details]
error 323 column
Comment 6 tim 2021-11-14 15:40:40 UTC 
You weren't careful enough comparing 2 different files: with an error and without an error: 2 columns difference is to reproduce error.

The essence of the error is that copying and pasting more than 321 columns from the browser is incorrectly perceived by the spreadsheet editor, so I attach 2 files again - with an error (323 columns) and without an error (321 columns) 

I've attached 2 new files, be careful: 
  "no error 321 column" - no error on copy-paste- as expected, 
  "error 323 column" - wrong layout, columns are shifted and merged
Comment 7 Roman Kuznetsov 2022-05-21 12:42:37 UTC 
(In reply to tim from comment #6)
> You weren't careful enough comparing 2 different files: with an error and
> without an error: 2 columns difference is to reproduce error.
> 
> The essence of the error is that copying and pasting more than 321 columns
> from the browser is incorrectly perceived by the spreadsheet editor, so I
> attach 2 files again - with an error (323 columns) and without an error (321
> columns) 
> 
> I've attached 2 new files, be careful: 
>   "no error 321 column" - no error on copy-paste- as expected, 
>   "error 323 column" - wrong layout, columns are shifted and merged

No problem with your "323 column" file in

Version: 7.4.0.0.alpha1+ / LibreOffice Community
Build ID: a2ffd71f20e14f797f30223fe29b3ac1e92eafdf
CPU threads: 4; OS: Linux 5.5; UI render: default; VCL: kf5 (cairo+xcb)
Locale: ru-RU (ru_RU.UTF-8); UI: ru-RU
Calc: threaded

I use Firefox 100.0.2 here
Comment 8 raal 2022-11-13 20:46:15 UTC 
No repro with Version: 7.5.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: cfc8a8f5d841b3f84d207196153be67da7f60652
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded

Please try with version 7.4.
Comment 9 QA Administrators 2023-05-13 03:19:11 UTC Comment hidden (obsolete)
Comment 10 QA Administrators 2023-06-13 03:12:12 UTC 
Dear tim,

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