Hi Ferdinando,
Just tested v16.5 (on Mac, but that should not differ from Windows). IMHO there
are no changes in number formatting between v16 and v17.
Created a 1 column array based list box on a form. Populated the array with
some random real numbers.
The column is set to variable type
Dňa ut, 6. aug 2019, 0:31 Chuck Miller via 4D_Tech <4d_tech@lists.4d.com>
napísal(a):
> Read my previous note. You will need to convert the array to text array
> and fill as a formatted number using code I already supplied
>
Format "### ###. 00;### ###. 00;" (format for positive, negative, zero)
Read my previous note. You will need to convert the array to text array and
fill as a formatted number using code I already supplied
Regards
Chuck
Sent from my iPhone
> On Aug 5, 2019, at 5:59 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>
> if ###,## does not display a
if ###,## does not display a blank for 0 you may have to convert back
and forth to/from text to get the formatting you want
Chip
On Mon, 5 Aug 2019 23:24:26 +0200, stardata.info via 4D_Tech wrote:
> Sorry i use 4D V16 on Windows.
>
> I need to display a number in an array real displayed in a
/08/19 21:00, 4d_tech-requ...@lists.4d.com ha scritto:
Message: 3
Date: Mon, 5 Aug 2019 11:48:46 -0400
From: Chuck Miller
To: 4DTechList Tech<4d_tech@lists.4d.com>
Subject: Re: FORMAT NUMBER
Message-ID:
<95863d81-6b67-400e-98a0-96534e372...@informed-solutions.com>
Content-Type
That is why I asked about version and what you show is truncated not rounded
Also I would suppose ###.## would take care of all
Didn’t think of that one
Regards
Chuck
Chuck Miller Voice: (617)
This ##0.###; ; produces good results for the example of 0.5
There are some things to watch for in the display detail event
4D v17
0 as blank
1 as 1
.5 as 0.5
.007 as 0.007
.0007 as 0 <- not blank
10.12345 as 10.123
10.1237 as 10.123 <- rounding
Keith - CDI
> On Aug 5, 2019, at 9:58 AM,
First of all. what version of 4D
I would think you can not do all you want with a number. You could do it with a
text variable
for example
in the in display detail form event
If $YourNumber_R (is a real)
$YourNumber_R:= 100.5
$YourText:=string($YourNumber_R;”###.0”)
$YourNumber_R:= 100.52
Hi All,
I need to format one column in a list box.
The column contains numeric values.
The values can have tre decimal digits.
I want a blank if number is zero.
I need to display 0,5 value for examples and i use ##0,00;; as a format
but not work.
Does someone have a suggestion?
Thanks
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
16 matches
Mail list logo