Bug 46712

Summary: EDITING: Crash when deleting a function using a data range
Product: LibreOffice Reporter: pierre-yves samyn <pierre-yves.samyn>
Component: SpreadsheetAssignee: Markus Mohrhard <markus.mohrhard>
Status: RESOLVED FIXED QA Contact:
Severity: normal    
Priority: medium CC: jefflibo, jm.zambon, lgodard.libre
Version: 3.5.0 release   
Hardware: Other   
OS: All   
Whiteboard: BSA target:3.6.0 target:3.5.1
Attachments: Spreadsheet with steps 1 to 5 already done

Description pierre-yves samyn 2012-02-28 02:53:14 UTC
Created attachment 57751 [details]
Spreadsheet with steps 1 to 5 already done

Hello 

Problem description: Crash when deleting a function using a data range

Steps to reproduce:
1. File> New> Spreadsheet (same problem with an existing one)
2. Select A1:A5
3. Data> Define range, give a name (MyData for instance)
4. Ok to close the dialog
5. in B1, enter the formula :
=ROWS(MyData)
6. Select B1, Edit> Delete cell (or delete key)

Expected behavior: deletes B1
Current behavior: crash


Platform (if different from the browser): 
Reproduced (fr-discuss) with :
LibO 3.5.0 et 3.5.1 rc1, Linux Mint 12 & Win7 64bit              
LibO 3.5.0 XP
LibO 3.5.0 Vista Sp2

Regards
PYS
Comment 1 Laurent Godard 2012-02-28 03:20:53 UTC
reproduced on 3.5.0 (ubuntu)

note that =Rows(myData) display #Name?
Comment 2 Not Assigned 2012-03-01 04:05:06 UTC
Markus Mohrhard committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=f7fbeac4cbb764ccd153f9aea37a07e66e96b809

use the correct db range for the copy, fdo#46712
Comment 3 Not Assigned 2012-03-01 10:15:41 UTC
Markus Mohrhard committed a patch related to this issue.
It has been pushed to "libreoffice-3-5":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=94d4301ac51589f0f5ae39039c0f1f7379677b3a&g=libreoffice-3-5

use the correct db range for the copy, fdo#46712


It will be available in LibreOffice 3.5.2.
Comment 4 Not Assigned 2012-03-01 13:36:58 UTC
Markus Mohrhard committed a patch related to this issue.
It has been pushed to "libreoffice-3-5-1":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=17322a611dd5add334f15539193dd0090e99ef01&g=libreoffice-3-5-1

use the correct db range for the copy, fdo#46712


It will be available already in LibreOffice 3.5.1.