Hi,
I am using CALC in LO 5.0.3.2 on a Fedora 23 (formally 22) system. The
version of LO I use is a version I downloaded from the LO site, not the
version that installs with Fedora.
I had to implement something in CALC that looked more or less like
this:
F(X) = (X+5)*6 + (((25+(X+5)*6-6) MOD 14)
If X is equal to 25, the result is 183. If I place this formula in a
cell (where cell A2 contains 25): =(A2+5)*6+MOD(25+(A2+5)*6-6;14), CALC
indeed provides 183 as the answer. However, the following thing happens
when I try to use the CURRENT() function in that calculation:
=(A2+5)*6+MOD(25+CURRENT()-6;14): The result provided is 182
=(A2+5)*6+MOD(25-6+CURRENT();14): The result provided is 190
=(A2+5)*6+MOD(CURRENT()+25-6;14): The result provided is 183
=(A2+5)*6+MOD(-6+CURRENT()+25;14): The result provided is 193
It is my understanding that the CURRENT() function returns the current
value of the formula being calculated. In the examples above, because
the call to CURRENT() is inside the MOD(), the value of the formula at
that point should be the same (180=(25+5)*6 in my example) regardless
of where CURRENT() is placed since the MOD cannot be calculated before
the two arguments are evaluated.
Is there something I am missing?
Thanking you in advance for any insights/information about this.
Rémy Gauthier.
--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Context
- [libreoffice-users] Help with the CALC CURRENT() function · Remy Gauthier
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.