• Data formatting: decimal digits does not permit 0

    From Martin =?UTF-8?Q?=CE=A4rautmann?=@21:1/5 to All on Wed May 1 19:51:07 2019
    On Wed, 1 May 2019 19:40:53 -0000 (UTC), Martin Τrautmann wrote:
    Any idea how to set the number of decimal digits to zero?

    I neither do want to round it to zero digits, nor to use a separate
    display field.

    I think I could set the number field formattig to show zero digits - but
    this does not work any longer here, FMP advanced 11. It does jump back
    to the last used definition.

    The online docu names that you can use both negative number of digits,
    as well as zero - but that's for other versions only?

    Or any idea what changed - e.g. a difference between system's number
    format and file format (MacOS)

    currently I can define 1 to 99 digits only

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Martin =?UTF-8?Q?=CE=A4rautmann?=@21:1/5 to All on Wed May 1 19:40:53 2019
    Any idea how to set the number of decimal digits to zero?

    I neither do want to round it to zero digits, nor to use a separate
    display field.

    I think I could set the number field formattig to show zero digits - but
    this does not work any longer here, FMP advanced 11. It does jump back
    to the last used definition.

    The online docu names that you can use both negative number of digits,
    as well as zero - but that's for other versions only?

    Or any idea what changed - e.g. a difference between system's number
    format and file format (MacOS)

    - Martin

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Helpful Harry@21:1/5 to All on Thu May 2 19:31:28 2019
    On 2019-05-01 19:51:07 +0000, Martin Τrautmann said:
    On Wed, 1 May 2019 19:40:53 -0000 (UTC), Martin Trautmann wrote:

    Any idea how to set the number of decimal digits to zero?

    I neither do want to round it to zero digits, nor to use a separate
    display field.

    I think I could set the number field formatting to show zero digits - but
    this does not work any longer here, FMP advanced 11. It does jump back
    to the last used definition.

    The online docu names that you can use both negative number of digits,
    as well as zero - but that's for other versions only?

    Or any idea what changed - e.g. a difference between system's number
    format and file format (MacOS)

    currently I can define 1 to 99 digits only

    I can't think of any reason it wouldn't work with zero, but I can't try
    it at the moment. I don't want to risk installing the FileMaker 11
    trial in case it causes problems with FileMaker 17 that I need right
    now.

    One possibility is the silly, but often easily done, error of pressing
    the letter O instead of the number 0.

    Try creating a brand new database file and see if the problem happens
    with that. If not, then it's a problem / corruption with the file
    you're using.


    Helpful Harry :o)

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Martin =?UTF-8?Q?=CE=A4rautmann?=@21:1/5 to Helpful Harry on Thu May 2 08:34:58 2019
    On Thu, 2 May 2019 19:31:28 +1200, Helpful Harry wrote:
    currently I can define 1 to 99 digits only

    I can't think of any reason it wouldn't work with zero, but I can't try
    it at the moment. I don't want to risk installing the FileMaker 11
    trial in case it causes problems with FileMaker 17 that I need right
    now.

    Welcome Harry, that's very reasonable.

    One possibility is the silly, but often easily done, error of pressing
    the letter O instead of the number 0.

    nope

    Try creating a brand new database file and see if the problem happens
    with that. If not, then it's a problem / corruption with the file
    you're using.

    I can't use it now within any database, neither old or new.

    I *feel* I could use it before - but I'm not sure any more now.

    Thanks,
    Martin

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Martin =?UTF-8?Q?=CE=A4rautmann?=@21:1/5 to All on Thu May 2 09:25:30 2019
    On Thu, 2 May 2019 08:34:58 -0000 (UTC), Martin Τrautmann wrote:
    On Thu, 2 May 2019 19:31:28 +1200, Helpful Harry wrote:
    currently I can define 1 to 99 digits only

    I can't think of any reason it wouldn't work with zero, but I can't try
    it at the moment. I don't want to risk installing the FileMaker 11
    trial in case it causes problems with FileMaker 17 that I need right
    now.

    Welcome Harry, that's very reasonable.

    One possibility is the silly, but often easily done, error of pressing
    the letter O instead of the number 0.

    nope

    Try creating a brand new database file and see if the problem happens
    with that. If not, then it's a problem / corruption with the file
    you're using.

    I can't use it now within any database, neither old or new.

    I *feel* I could use it before - but I'm not sure any more now.

    The docu names:

    https://fmhelp.filemaker.com/help/11/fmp/en/html/edit_layout.10.17.html
    +++
    To specify that each value be displayed with the same number of places,
    select Fixed number of decimals and type a value. (A positive value
    specifies places to the right of the decimal place, a negative value
    specifies places to the left.)

    [...]
    (For example, if you enter 789.78 and you specify 3 fixed digits, you see 789.780 in the field; if you specify 0 fixed digits, you see 790; if you specify -2 fixed digits, you see 800.)
    +++

    I can use only positive numbers from 1 to 99, neither 0 nor negative
    numbers.

    - Martin

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Martin =?UTF-8?Q?=CE=A4rautmann?=@21:1/5 to All on Thu May 2 09:27:57 2019
    On Thu, 2 May 2019 09:25:30 -0000 (UTC), Martin Τrautmann wrote:
    The docu names:

    https://fmhelp.filemaker.com/help/11/fmp/en/html/edit_layout.10.17.html
    +++
    To specify that each value be displayed with the same number of places, select Fixed number of decimals and type a value. (A positive value
    specifies places to the right of the decimal place, a negative value specifies places to the left.)

    [...]
    (For example, if you enter 789.78 and you specify 3 fixed digits, you see 789.780 in the field; if you specify 0 fixed digits, you see 790; if you specify -2 fixed digits, you see 800.)
    +++

    ... and that's the same docu both for FMP 6, 11 or 17

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Martin =?UTF-8?Q?=CE=A4rautmann?=@21:1/5 to All on Thu May 2 09:38:23 2019
    On Thu, 2 May 2019 09:27:57 -0000 (UTC), Martin Τrautmann wrote:
    On Thu, 2 May 2019 09:25:30 -0000 (UTC), Martin Τrautmann wrote:
    The docu names:

    https://fmhelp.filemaker.com/help/11/fmp/en/html/edit_layout.10.17.html
    +++
    To specify that each value be displayed with the same number of places,
    select Fixed number of decimals and type a value. (A positive value
    specifies places to the right of the decimal place, a negative value
    specifies places to the left.)

    [...]
    (For example, if you enter 789.78 and you specify 3 fixed digits, you see
    789.780 in the field; if you specify 0 fixed digits, you see 790; if you
    specify -2 fixed digits, you see 800.)
    +++

    ... and that's the same docu both for FMP 6, 11 or 17

    It must be a bug. Versions before FMP9 do not work on my computer, but
    FMP9 still does, as well as FMP 10.

    FMP11 introduced the new layout inspector - and this seems to be broken
    for that special feature.

    It must be a bug. Versions before FMP9 do not work on my computer, but
    FMP9 still does, as well as FMP 10.

    FMP11 introduced the new layout inspector - and this seems to be broken
    for that special feature.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Helpful Harry@21:1/5 to All on Fri May 3 08:35:18 2019
    On 2019-05-02 09:38:23 +0000, Martin Τrautmann said:

    It must be a bug. Versions before FMP9 do not work on my computer, but
    FMP9 still does, as well as FMP 10.

    FMP11 introduced the new layout inspector - and this seems to be broken
    for that special feature.

    It must be a bug. Versions before FMP9 do not work on my computer, but
    FMP9 still does, as well as FMP 10.

    FMP11 introduced the new layout inspector - and this seems to be broken
    for that special feature.

    The notes for the last update (11.0v4) for FileMaker Pro 11 does
    specifically say:

    OS X Lion only: Addressed an issue with not being
    able to use zero or negative numbers in data
    formatting in the Inspector and in some controls
    in the Chart Setup dialog.

    Looks like you need to download and install that update from <https://support.filemaker.com/s/answerview?language=en_US&anum=9910>


    Helpful Harry :o)

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)