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
i915 platform: i915 features:
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.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.