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
Created attachment 176219 [details] unexpected behaviour 323 columns html
Created attachment 176220 [details] 321 column example - as expected
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.
Created attachment 176247 [details] no error 321 column
Created attachment 176248 [details] error 323 column
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
(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
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.
Dear tim, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
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