Hi Jeff,

If your problem is a simple format-number problem, maybe your are missing a , 
in the second definition.

If you need the - after the number, I'd guess the only way is to fake it. 
Either by using two columns, one with the numbers, the other with the sign, or 
by adding a right padding in blocks with positive numbers. I don't think you 
can tell fop to align blocks not based on their border but on a part of their 
content.

Regards,

Georg Datterl

------ Kontakt ------

Georg Datterl

Geneon media solutions gmbh
Gutenstetter Straße 8a
90449 Nürnberg

HRB Nürnberg: 17193
Geschäftsführer: Yong-Harry Steiert

Tel.: 0911/36 78 88 - 26
Fax: 0911/36 78 88 - 20

www.geneon.de<http://www.geneon.de>

Weitere Mitglieder der Willmy MediaGroup:

IRS Integrated Realization Services GmbH:    
www.irs-nbg.de<http://www.irs-nbg.de>
Willmy PrintMedia GmbH:                            
www.willmy.de<http://www.willmy.de>
Willmy Consult & Content GmbH:                 
www.willmycc.de<http://www.willmycc.de>

Von: Steffanina, Jeff [mailto:[email protected]]
Gesendet: Mittwoch, 1. September 2010 16:03
An: [email protected]
Betreff: Placing the minus sign(-) to the RIGHT side of the number

I am using FOP to produce an invoice in a .PDF.   Everything works.
However, when a negative number is produced in my right justified table column, 
the minus sign causes the decimal point to be mis-aligned.
I found the "format-number" function and this addresses the problem.  Now the 
issue is that my system generates a negative value in the form of:
     233.94-
(the minus sign is always to the right of the value)  This cannot be changed.   
When I submit the value to "format-number", it returns a "NaN" error.

select="format-number(inv-amt,'##,###.00;#####.00-')"

In summary, I need to produce a column of numbers, right justified, some of the 
values are negative with the minus sign to the right.  At the same time, the 
vertical alignment of the decimal point is required.

Any ideas?

Thanks.

Jeff

Reply via email to