Bug 116649 - Function Wizard Error for FREQUENCY data range selection
Summary: Function Wizard Error for FREQUENCY data range selection
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.4.5.1 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-03-27 09:41 UTC by Colin
Modified: 2018-03-27 18:20 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Small spreadsheet with appropriate data (11.36 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-03-27 09:41 UTC, Colin 		Details
Screen Dump, of the error condition (177.74 KB, image/jpeg)
2018-03-27 09:43 UTC, Colin 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Colin 2018-03-27 09:41:27 UTC 
Created attachment 140903 [details]
Small spreadsheet with appropriate data

Similar to Previous report 72440 claiming to be "VERIFIED FIXED"
Two sheets with random data table on sheet one
Sheet two contains the list of Elements
place cursor alongside the first element
Select function wizard [FREQUENCY] check [Array]
attempt to select the range on sheet one
Ref error produced
Attached is a small spreadsheet with the random data on sheet 1 and the elements on sheet 2
Will attach a screen grab showing the impact in a further comment -upload limit ONE file.
Comment 1 Colin 2018-03-27 09:43:20 UTC 
Created attachment 140904 [details]
Screen Dump, of the error condition
Comment 2 m_a_riosv 2018-03-27 15:50:07 UTC 
Reproducible
Versión: 5.4.5.1
Id. de compilación: 79c9829dd5d8054ec39a82dc51cd9eff340dbee8
Subprocs. CPU: 4; SO: Windows 6.2; Repres. IU: GL; 
Configuración regional: es-ES (es_ES); Calc: CL

but works for me with
Version: 5.4.6.2 (x64)
Build ID: 4014ce260a04f1026ba855d3b8d91541c224eab8
CPU threads: 4; OS: Windows 6.19; UI render: default; 
Locale: es-ES (es_ES); Calc: group

Please update to 5.4.6 or 6.0.3
Comment 3 Colin 2018-03-27 16:27:00 UTC 
(In reply to m.a.riosv from comment #2)
> Reproducible
> Versión: 5.4.5.1
> Id. de compilación: 79c9829dd5d8054ec39a82dc51cd9eff340dbee8
> Subprocs. CPU: 4; SO: Windows 6.2; Repres. IU: GL; 
> Configuración regional: es-ES (es_ES); Calc: CL
> 
> but works for me with
> Version: 5.4.6.2 (x64)
> Build ID: 4014ce260a04f1026ba855d3b8d91541c224eab8
> CPU threads: 4; OS: Windows 6.19; UI render: default; 
> Locale: es-ES (es_ES); Calc: group
> 
> Please update to 5.4.6 or 6.0.3

Works for me now on 6.0.2.1
Interestingly, my report version 5.4.5.1, when asked to check for updates, claimed it was the latest version.
Is it worth reporting that as a potential bug or just assume people will move on anyway?
Comment 4 m_a_riosv 2018-03-27 18:20:55 UTC 
I think not because it will not receive more patches.