Hello Dan:
> I have an .odb data source backed by an .ods spreadsheet with
> several sheets. Every sheet in the spreadsheet has an area (rows
> 150 to 189) with the data I need in my .odt text file. I can print
> merge mail choosing the row range, everything fine.
> The problem is that 3 of my 23 base fields (or sheet columns) do
> not show the appropiate format in the .odt text file: they lack the
> "." separator and the decimal numbers after the separator. Editing
> the Base table I found that all field types are Text[VARCHAR]
> except for those 3, which are Decimal[DECIMAL]. I tried changing
> cell formats in the spreadsheet but could not fix the problem. How
> does Base decide field types? How can I modify that?
>
Could you be more specific about these three fields? In the first
of the three fields, what is contained in the cell of the
spreadsheet? What is contained in the corresponding field in the
database in the source window? What is place in the .odt file for
this field?
Thank you for your hint. Base uses the type of the first cell in each column
that is not empty! The data we need to be in our base is in the rows 150
to 189 of the spreadsheet, but before row 150 I have many other things
(text, integer numbers, decimal numbers, etc). Base was taking the
field format from the first rows of our spreadsheet and in those 3 columns
we had placed integer numbers on row 10. We introduced some text on
row 9 and now everything works fine: all fields are Text[VARCHAR].
Is there a better way to do this? If, for example, somebody adds a integer
number on row 3 of our speadsheet for whatever reason the field format
would be changed again to become an integer and the mail merge would
fail again!
Marcos
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
