[EMAIL PROTECTED] wrote:
On Tue, 31 May 2005 14:32:13 +0200, G. Roderick Singleton
<[EMAIL PROTECTED]> wrote:
On Mon, 2005-05-30 at 23:30 +0200, tomero wrote:
Hello,
I'm novice in Open Office and have some problems with Writer and forms.
I try to create some form in Writer which would be filled in via
computer
and then it will be printing.
This form wouldn't be connect with any database.
I'v got problems with numeric field. This field is dedicated to bank
account number, so it should match with IBAN standards
I want correspond with IBAN account length - in Poland bank
accounts have
34 digits or 42 when you include spaces.
So, I created a conrol with defined format. In control propertise
I have
choosen formatting and defined this user-format:
##_####_####_####_####_####_####_####_####
I think you will find that the above contruct can be handled better as a
string. Try that.
But those format doesn't work and two strange thigs happend:
1) Writer ignore my numbers which I type in when there are more than 15
digits, ie. I type 1234567890123456789 and Writer received me:
1234567890123460000
Please take your attention to last 5 digits. After 4 its 6 instead of 5
and rest of the digits have replaced by zeros.
The underbars make the above a string and I think that OOo is getting
confused.
2) Writer ignore my format - ie. I type 1234567890123456789 and Writer
received me: 1 234 567 890 123 460 000
so it doesn't collect digith in gruops in my scheme (2 4 4 4 etc.)
but in
this one: 1 3 3 3 etc.
As a numeric I think it would. Again try handling it as a string.
Of course the case 1 and 2 are separated by me to show problem in
simplest
way but it happens in the same time.
I checked how does Writer works with numeric control without my own
format
and the same problem as in point 1 appeared too.
I solve this problem in this way - I used text control instead of
formatted control but I'm not happy with that.
I can't define my pattern and operator can do mistakes
And I don't understend why in numeric control I can't put in more than
15 digits? Don't you think it's bug?
A numeric control stores the data in a numeric data type. The numeric
data type can NOT store more than 15 digits. Consider for a moment, how
do you want to extract the data from the control? Is it as a number? If
so, into what data type do you want to store this data? So, no, I do not
consider this a bug.
A "formatted control" is for formatting numbers, so that will not work.
The Pattern Control (page 437 of my book)...
Your edit mask will be
##_####_####_####_####_####_####_####_####
NNLNNNNLNNNNLNNNNLNNNNLNNNNLNNNNLNNNNLNNNN
Your literal mask will probably be the same length and consist entirely
of the character "_".
You probably want to set string checking to true.
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.sxw
My Macro Book: http://www.hentzenwerke.com/catalog/oome.htm
Free Info: http://www.pitonyak.org/oo.php
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
