Hello,
I found some information in the documentation (header files, I can not stress
this enough).
short answer, the library supports it, the plugin doesn't.
---
from format.h
// good resource for format strings:
http://www.mvps.org/dmcritchie/excel/formula.htm
// Good explanation of custom
I don't know anything about the plugin you were attempting to use, but one way
to create formatted documents for Excel is to use XML. You specify the type for
each cell. I'm sure you could figure out the format option you want by saving a
document with Excel and looking at the XML.
John DeSoi,
lity methods component:
https://flury-software.ch/a-swiss-army-knife-for-4d/
Best,
Olivier
-----Ursprüngliche Nachricht-----
Von: 4D_Tech <4d_tech-boun...@lists.4d.com> Im Auftrag von 4dialog via 4D_Tech
Gesendet: Mittwoch, 30. Januar 2019 08:42
An: 4d_tech@lists.4d.com
Cc: 4dialog
Betre
Thanks for all answers.
The problem is not i 4D, i get the leading zero but only in a text cell.
In excel you can format manualy a column as number with fixed numbers
preformated (selfdefined format). In my case, 11 numbers, "000". If
you put 10 numbers in a cell it gets leading zero.
Hilsen:
How about putting the logic in 4D code and then branch to the appropriate
format. Intelligent formats are handy and elegant but don't have the
simplicity, flexibility, or transparency of 4D code.
This sort of code is very quick to code and very easy to understand:
If(length of date=5)
the plugin has no documentation because it is just a wrapper of an existing
free library
which has no documentation other than its header files (which is quite normal
for a C library)
sorry about that.
if that's not good enough for you
then you might to explore commercial options.
I need to build a excel document where born date (6 char) needs to be number
format with leading zero if only 5 chars.
How can i do this in XLS plugin, what command, what params.
There is many format commands but cant find any documentation on them with
explanation?
-
Hilsen
7 matches
Mail list logo