Bug 125031

Summary: cell error on Calc
Product: LibreOffice Reporter: IRL <info.rma.lotico>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG    
Severity: normal CC: raal, xiscofauli
Priority: medium    
Version: unspecified   
Hardware: x86-64 (AMD64)   
OS: Linux (All)   
Whiteboard:
Crash report or crash signature: Regression By:

Description IRL 2019-04-29 17:26:06 UTC 
Description:
Bug in libreoffice calc, in the function CORREL, during the matrix constuction. For example see video Correlation https://www.youtube.com/watch?v=uc55cnr8A14 done in excel at time 2:48.
It'isnt possible make the cell with Calc with the same value because appair a cell error #VALUE!

Steps to Reproduce:
Inside of the cell i modify the value as the video example of the time 2:48 and the cell are with this error #VALUE!

Actual Results:
This is the cell error: #VALUE!

Expected Results:
Nothing, i enterrupt the working of this function


Reproducible: Always


User Profile Reset: No



Additional Info:
See the video to time 2:48
Comment 1 raal 2019-04-29 18:23:18 UTC 
Hello,

Thank you for filing the bug. Please send us a sample document, as this makes it easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO', so please do change it back to 'UNCONFIRMED' once you have attached a document.
(Please note that the attachment will be public, remove any sensitive information before attaching it.)
How can I eliminate confidential data from a sample document?
https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F
Thank you
Comment 2 IRL 2019-05-01 13:49:04 UTC 
hi,

I want say you that is been solve the problem.
In realty it'isnt a bug but simply a not correct number visualizzation of the number 1 in the data coloumn, that is 1 more value ' (that is ' plus 1 ), but with visualizing very little because near to the separation coloumn line.

Sorry for this unexpected, my question is finished.

Thank you
Comment 3 QA Administrators 2019-05-08 21:50:54 UTC Comment hidden (obsolete)
Comment 4 Xisco Faulí 2019-05-08 22:03:14 UTC 
Closing as RESOLVED NOTABUG