Hi,
I have a csv file (name;address;nbr_of_days;price_per_day).
I want to mailmerge this into a Calc document. In that calc document I have a simple formula in cell B1 = A1 * A2. Now I want to create several files : one for each record in the csv (that I already have put in an odb). The value of nbr_of_days should go into cell A1, and will be used in the calculation for B1.
Currently, when I drop a field (after pressing F4) from the ODB to my spreadsheet, I get a Text Editbox. But instead I want that value to go into cell A1, so it gets used in the calculation.
Used to create basic invoices from csv, but with possibility to add stuff before printing.