Bug 121798 - cell/100 = 0
Summary: cell/100 = 0
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.1.3.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-11-29 10:54 UTC by Uwe Hartwig
Modified: 2019-01-13 14:22 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 Uwe Hartwig 2018-11-29 10:54:49 UTC
Description:
In cells with the formula =cell/100 ist the solution 0
/10 works correkt, /1000 works correct, also /1000*10 works correct.


6.13.2 (x64) and 6.2.0 (x64) Version

In Version 6.0.7.3 (x64) everything is OK

Steps to Reproduce:
1.For example 

A1 is 500. B1 is =A1/100 

Actual Results:
B1 is 0!

Expected Results:
B1 should be 5


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 raal 2018-11-29 11:06:25 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 Xavier Van Wijmeersch 2018-11-29 15:29:01 UTC
no repro in lunix

Version: 6.1.2.1
Build ID: 65905a128db06ba48db947242809d14d3f9a93fe
CPU threads: 8; OS: Linux 4.19; UI render: default; VCL: kde4; 
Locale: en-GB (en_US.UTF-8); Calc: group threaded

Version: 6.1.4.0.0+
Build ID: b3af23568f9b9b444ae09f2a1ab4a61d212b422a
CPU threads: 8; OS: Linux 4.19; UI render: default; VCL: kde4; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:libreoffice-6-1, Time: 2018-11-23_09:38:29
Locale: nl-BE (en_US.UTF-8); Calc: group threaded
Comment 3 Uwe Hartwig 2019-01-13 13:23:35 UTC
(In reply to Uwe Hartwig from comment #0)
> Description:
> In cells with the formula =cell/100 ist the solution 0
> /10 works correkt, /1000 works correct, also /1000*10 works correct.
> 
> 
> 6.13.2 (x64) and 6.2.0 (x64) Version
> 
> In Version 6.0.7.3 (x64) everything is OK
> 
> Steps to Reproduce:
> 1.For example 
> 
> A1 is 500. B1 is =A1/100 
> 
> Actual Results:
> B1 is 0!
> 
> Expected Results:
> B1 should be 5
> 
> 
> Reproducible: Always
> 
> 
> User Profile Reset: No
> 
> 
> 
> Additional Info:

I checked this again January, 13th 2019:
First from actual 6.0.7.3 installed 6.1.4 -> Test /100 works allright.
After that installed same Version 6.2.00 beta 1 from HDD as reported.
The problem is not reproductible?! Everything OK ;-)