Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


Am 10.08.2011 09:23, toto wrote:
I'm using macro's function and it doesn't start when the document start.
It would start if I change the value of the variabel at the function.
The code is to change numeric value to string. If I execute the code:
ubah(123) the result is "seratus dua puluh tiga". Any idea how to make
the function executed when I open the document?

The code is:

Public Function ubah(x as currency) as String

Currency is not a valid type to be used in a spreadsheet.
From the Basic perspective all spreadsheet values are doubles or string, errors are Null, empty cells are empty strings. There are no "date values" in particular.

This function works as expected:
Function DOUBLE(n as Double)
 DOUBLE = n *2
End Function

This function returns a text value.
Function DOUBLE_CURR(n as Currency)
 DOUBLE_CURR = n *2
End Function

I can not reproduce the recalculation problem, though.
Both versions of the above functions recalculate when I load the document or when I modify A1 with auto-cacluation enabled.
A1 =PI()
=DOUBLE(A1) => 6.2832 (number)
=DOUBLE_CURR(A1) => 6.2832 (text)


--
For unsubscribe instructions e-mail to: users+help@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


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.