https://bz.apache.org/ooo/show_bug.cgi?id=127083
Issue ID: 127083
Issue Type: DEFECT
Summary: mod(whole number;1) = 1
Product: Calc
Version: 4.1.2
Hardware: PC
OS: Windows XP
Status: UNCONFIRMED
Severity: Minor
Priority: P5 (lowest)
Component: editing
Assignee: [email protected]
Reporter: [email protected]
Created attachment 85643
--> https://bz.apache.org/ooo/attachment.cgi?id=85643&action=edit
spreadsheet for calculating size/angles for building gazebo
so i have sheet and some values are whole number, ie 17, say in cell G20. if i
enter =mod(G20;1) i get 1 (should be 0). if i enter =mod(17;1) i get 0
(correct). i copy the value (value only) out of G20 into, say J29, and i enter
=mod(J29;1) i still get 1???? i enter a 17 on I29 and enter a formula
=mod(I29;1) i get 0 (correct). on the attached spreadsheet in sheet "layout
pts", the whole numbers in the upper table have this issue - look at G30
referencing G20. very odd..... i tried changing the table from formulas to
values by copying/special pasting values only, but it still gave the same
issue. very odd....
PS: i picked editing for the component because the issue followed when i copied
the value out of the table.
--
You are receiving this mail because:
You are the assignee for the issue.
