Problem display of number in calculate-field

#1

I have a field calculating VAT. I want it to show with two decimals and
thousand separator. But when I go to the actual layout the field jumps
between showing correct and cutting away the last digits

If correct number should f.i. be "693,33", and it suddenly just show
"69" ??. When I click on the field it shows the correct number, but goes
back to "69" again. Changed than to a text-format and putting the field
in as a "merge"-field. And than it looked OK. But just for a while, -
now it starts with cutting the right digits again.

I am using OS X 10.3.9 and FileMaker 8.0 v3.

Hope someone can help me with this.

Lorentz Hjelle

#2

In article <1hnmpch.7de6szkok9naN%hotel (AT) fjern_hjelle (DOT) com>,
hotel (AT) fjern_hjelle (DOT) com (Lorentz Hjelle) wrote:

Quote:

I have a field calculating VAT. I want it to show with two decimals and
thousand separator. But when I go to the actual layout the field jumps
between showing correct and cutting away the last digits

If correct number should f.i. be "693,33", and it suddenly just show
"69" ??. When I click on the field it shows the correct number, but goes
back to "69" again. Changed than to a text-format and putting the field
in as a "merge"-field. And than it looked OK. But just for a while, -
now it starts with cutting the right digits again.

I am using OS X 10.3.9 and FileMaker 8.0 v3.

Hope someone can help me with this.

Lorentz Hjelle

When you click in a number field, what you see is the data as actually
entered.

Two things:

Is the field on the layout actually formatted to show two decimal places
and the thousands separator?

Is the layout object large enough to display the entire desired format?

Matt

#3

Matt Wills <Im (AT) Witz (DOT) End> wrote:

Quote:

When you click in a number field, what you see is the data as actually
entered.

Two things:

Is the field on the layout actually formatted to show two decimal places
and the thousands separator?
Yes, it is.

Is the layout object large enough to display the entire desired format?

Yes, I have enlarged it, and even made another copy of the field on the

same layout, - and the same thing happens!?

#4

Lorentz Hjelle <hotel (AT) fjern_hjelle (DOT) com> wrote:

Quote:

Matt Wills <Im (AT) Witz (DOT) End> wrote:

When you click in a number field, what you see is the data as actually
entered.

Two things:

Is the field on the layout actually formatted to show two decimal places
and the thousands separator?
Yes, it is.

Is the layout object large enough to display the entire desired format?

Yes, I have enlarged it, and even made another copy of the field on the
same layout, - and the same thing happens!?

I forgot to say that I had the field set as right justificated when this
happens. But when I change it to lef-justification, it shows correct
again. So if I can't solve the problem, it looks like I have to leave it
as left-justificated, although it doesn't look perfect.

#5

Lorentz Hjelle <hotel (AT) fjern_hjelle (DOT) com> wrote:

Quote:

Lorentz Hjelle <hotel (AT) fjern_hjelle (DOT) com> wrote:

Matt Wills <Im (AT) Witz (DOT) End> wrote:

When you click in a number field, what you see is the data as actually
entered.

Two things:

Is the field on the layout actually formatted to show two decimal places
and the thousands separator?
Yes, it is.

Is the layout object large enough to display the entire desired format?

Yes, I have enlarged it, and even made another copy of the field on the
same layout, - and the same thing happens!?

I forgot to say that I had the field set as right justificated when this
happens. But when I change it to lef-justification, it shows correct
again. So if I can't solve the problem, it looks like I have to leave it
as left-justificated, although it doesn't look perfect.

It looks like the right-justification aligns it to long to the right, so
the 3 right-most digits doesn't show. When I centre, the number shows on
the right side of the field. So there must be an error in the
layout-tools??

I had the problem also under 8.0 v2, and hoped the v3 would fix the
problem. I have never had this problem before, and I have used this
program since the first versions 10-15 years ago (or maybe longer?).

#6

Do you have the same trouble when changing the font? Some fonts have metrics
that FileMaker doesn't like, or have been corrupted. Is the numeral type set
to half-width or full-width?

"Lorentz Hjelle" <hotel (AT) fjern_hjelle (DOT) com> wrote

Quote:

Lorentz Hjelle <hotel (AT) fjern_hjelle (DOT) com> wrote:

Matt Wills <Im (AT) Witz (DOT) End> wrote:

When you click in a number field, what you see is the data as actually
entered.

Two things:

Is the field on the layout actually formatted to show two decimal
places
and the thousands separator?
Yes, it is.

Is the layout object large enough to display the entire desired format?

Yes, I have enlarged it, and even made another copy of the field on the
same layout, - and the same thing happens!?

I forgot to say that I had the field set as right justificated when this
happens. But when I change it to lef-justification, it shows correct
again. So if I can't solve the problem, it looks like I have to leave it
as left-justificated, although it doesn't look perfect.

#7

This is a bug that was fixed in FileMaker 8.5. It has to do with the
right justification of this field in conjunction with another object on
your layout having custom tab justification settings.

Lorentz Hjelle wrote:

Quote:

It looks like the right-justification aligns it to long to the right, so
the 3 right-most digits doesn't show. When I centre, the number shows on
the right side of the field. So there must be an error in the
layout-tools??

I had the problem also under 8.0 v2, and hoped the v3 would fix the
problem. I have never had this problem before, and I have used this
program since the first versions 10-15 years ago (or maybe longer?).

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Professional Solutions, Inc. Los Angeles

FileMaker 8 Certified Developer
Associate Member, FileMaker Solutions Alliance

#8

Howard Schlossberg <howard (AT) antispahm (DOT) fmprosolutions.com> wrote:

Quote:

This is a bug that was fixed in FileMaker 8.5. It has to do with the
right justification of this field in conjunction with another object on
your layout having custom tab justification settings.

I feel you are right. But shouldn't Filemaker correct this, without

having to buy a new version? Or maybe the will correct it in v4, or have
they stopped supporting older versions?

Lorentz

#9

Bill Marriott <wjm (AT) wjm (DOT) org> wrote:

Quote:

Do you have the same trouble when changing the font? Some fonts have metrics
that FileMaker doesn't like, or have been corrupted. Is the numeral type set
to half-width or full-width?

They are set to half-width. Tried some other fonts, too, - no change!

Looks like a bug, to me.

#10

There are always bug fixes with every new version. Sometimes we get the
fixes free, and sometimes they are bundled up with new features and cost
money. When FileMaker releases a new paid upgrade they don't continue to
provide free updates to prior versions, at least none that I can remember.
It would require development and testing on too many things at once.

You might have some success requesting a complimentary upgrade, or at least
a discount on the upgrade, by contacting FileMaker customer support.

Best of luck!

"Lorentz Hjelle" <hotel (AT) fjern_hjelle (DOT) com> wrote

Quote:

Howard Schlossberg <howard (AT) antispahm (DOT) fmprosolutions.com> wrote:

This is a bug that was fixed in FileMaker 8.5. It has to do with the
right justification of this field in conjunction with another object on
your layout having custom tab justification settings.

I feel you are right. But shouldn't Filemaker correct this, without
having to buy a new version? Or maybe the will correct it in v4, or have
they stopped supporting older versions?

Lorentz