Bug 147367

Summary: Crash if I paste filtered data in two adjacent cells in selection
Product: LibreOffice Reporter: Aniketg <dilseaniket>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WORKSFORME    
Severity: normal CC: dilseaniket, xiscofauli
Priority: medium    
Version: 7.0.4.2 release   
Hardware: x86-64 (AMD64)   
OS: Linux (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: Sample file where I found mentioned bug as requested.
Video of the bug reproduction

Description Aniketg 2022-02-11 09:03:36 UTC 
Description:
In my CSV file I have time slots in text format in column E & F which I want to convert to time format. So I filtered the first time slot, converted into time. Copied 2 adjacent cells and pasted to all the filtered cells in those columns. 

If I do this for one column (selecting cell and pasting in in selection of one column only), it doesn't crash! It only crashes if I paste it data in selected 2 columns. It also did not happen when it was text format... Only happened in Time Format

Steps to Reproduce:
1. Create a CSV File with 2 columns FROM and TO with time slots 
FROM     TO      
10:00:00 11:00:00
13:00:00 14:00:00
15:00:00 16:00:00
2. Copy these three rows for 100 times (total 300 rows)
3. Close the CSV
4. Open the CSV. If you check the number format it will be text due to CSV extension. Now filter one time slot. Change its format to time. a " ' " will be added as a prefix...
5. Remove it to make its format to TIME. Do the same for next cell in TO column.
6. Select both the cells and copy them.
7. Paste these to cells in all the filtered cells in the 2 columns... 

Actual Results:
LibreOffice crashed.

Expected Results:
It should have pasted data from both the cells to filtered cells.


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes
Comment 1 Xisco Faulí 2022-02-11 09:41:11 UTC 
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
(Please note that the attachment will be public, remove any sensitive information before attaching it. 
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Comment 2 Aniketg 2022-02-11 09:58:01 UTC 
Created attachment 178212 [details]
Sample file where I found mentioned bug as requested.
Comment 3 Xisco Faulí 2022-02-11 10:20:29 UTC 
Thanks for providing the file.
Would it be possible to attach a screencast showing the steps to reproduce the crash?
The current steps are not clear to me.
1. Open the Csv file
2. Select E2:F1652
3. Change format to time

-> now what ?
Comment 4 Aniketg 2022-02-11 10:43:22 UTC 
Created attachment 178217 [details]
Video of the bug reproduction
Comment 5 QA Administrators 2022-02-12 03:38:38 UTC Comment hidden (obsolete)
Comment 6 Xisco Faulí 2022-02-16 15:21:54 UTC 
Thanks for providing the screencast.
I can't reproduce it in

Version: 7.4.0.0.alpha0+ / LibreOffice Community
Build ID: 49746f40b06eaf1f61bb54454408a06a49d73c5e
CPU threads: 8; OS: Linux 5.10; UI render: default; VCL: gtk3
Locale: es-ES (es_ES.UTF-8); UI: en-US
Calc: threaded Jumbo

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 7 QA Administrators 2022-08-16 04:01:35 UTC Comment hidden (obsolete)
Comment 8 Aniketg 2022-08-17 07:23:37 UTC 
In the new version of libreoffice, I am not able to reproduce it. I apologize for not replying earlier. I think, we can close this bug.