[Libreoffice-bugs] [Bug 118177] Truncating 8*27/27 equals 7 on FILEOPEN if a cell is formatted other than General

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=118177

--- Comment #4 from Xavier Van Wijmeersch <xv3247 at gmail.com> ---
Created attachment 142770
  --> https://bugs.documentfoundation.org/attachment.cgi?id=142770&action=edit
truncation corrected

Did changed your formula removed one () and when saving and reopen the file, i
have the correct value of 8, see attachment
Formula TRUNC(($A:$A-10*$F$3); when saving and reopen the file give 7 and need
Ctrl+Shift+F9 to have 8

Version: 6.2.0.0.alpha0+
Build ID: 90e4c55d01637178418c33ffe818263114a53374
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
TinderBox: Linux-rpm_deb-x86_64 at 70-TDF, Branch:master, Time:
2018-06-12_00:10:12
Locale: nl-BE (en_US.UTF-8); Calc: group threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180615/500482f2/attachment.html>