Bug 86123 - EDITING - Calc does not update cell display value from original boolean result calculation
Summary: EDITING - Calc does not update cell display value from original boolean resul...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) macOS (All)
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2014-11-10 18:46 UTC by Ilya
Modified: 2017-08-26 23:19 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Ilya 2014-11-10 18:46:04 UTC

Comment 1 Ilya 2014-11-10 18:48:58 UTC
If you will put some logical statement to a cell in spreadsheet (e.g. "=B1=B2" to B3), and then you will change formula to something else (e.g. "=B1/B2"), then you will still have boolean data format of cell, which will cause incorrect (for user) display of value.
Comment 2 Alex Thurgood 2014-11-12 10:39:06 UTC
Confirming on 
Build ID: 269b0b40814defe0241e8c79c1834e488ea13bc5
Comment 3 Alex Thurgood 2014-11-12 10:42:00 UTC
Changed title to more accurately reflect behaviour
Comment 4 Alex Thurgood 2014-11-12 10:50:21 UTC
Even a forced cell recalculation does not solve the problem.
Comment 5 QA Administrators 2015-12-20 16:09:33 UTC Comment hidden (obsolete)
Comment 6 Alex Thurgood 2015-12-21 08:14:25 UTC
Confirming on 

Build ID: ce3d3f5543e3e132a3473af27aa2c827336add0f
CPU Threads: 2; OS Version: -; UI Render: default; 
Locale : fr-FR (fr.UTF-8)

This is actually pretty bad.
Comment 7 QA Administrators 2017-01-03 19:55:36 UTC Comment hidden (obsolete)
Comment 8 eisa01 2017-08-26 23:19:39 UTC
This has been fixed now

Setting a cell to 2 and 3, and equating shows FALSE. Editing to division shows 0.6667 as you would expect

Build ID: 7556cbc6811c9d992f4064ab9287069087d7f62c
CPU threads: 2; OS: Mac OS X 10.12.6; UI render: default; 
Locale: en-US (en_US.UTF-8); Calc: group