![]() ![]() Note that this could not simply be named Format, as that name conflicts with the other built in function named Format. This Basic Macro adds a new Calc function that can format a number as a string using the Basic (not Calc) format function to do the work, for example you can now format a number as a string with leading zeros or the like: Function FORMAT_(Number As Integer, sFormat As String) As Variant Here is another example to fill in for a missing function in standard Calc: ![]() In Macros Explained - OOME_3_0 by Andrew Pitonyak -669 pages, on page 514 or section 15.7 is ‘Write your own Calc functions’. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |