Bug 125031 - cell error on Calc
Summary: cell error on Calc
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-04-29 17:26 UTC by IRL
Modified: 2019-05-08 22:03 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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