In the field properties window, select the "data" tab. There are two ways to get to the field properties:ġ - right-click on the field and select "control"Ģ - open the form navigator (make the "form design" toolbar visible, it is the compass over a square, sixth icon from the left), right-click on the field name in the form navigator windown, and select "properties" Click on the icon for the type of field you want on your form, and draw it where you want it (it can be resized and moved later if you're not happy with where it's put at first). Click on the pencil with the triangle (second icon from the left) to enter design mode. You'll want to have the "form controls" toolbar visible. May be someone has a better idea? Perhaps someone could share a snippet of code showing how they solved this problem? I am fairly good at writing VBA code so may be this can be solved using macros in some way?Ĭalc can have fields that are linked to cells on the spreadsheet - this might do what you want? If a form cannot be created in Calc, what needs to enable a form in Base to enter data into a spreadsheet? We are currently using Excel but I want to abandon Excel and abandon using Windows operating system altogether. The data needs to be entered using a form because the employees make all kinds of mistakes if they enter the data directly into a spreadsheet.
So thanks to all who wrote LibreOffice to make that possible. I created a Calc spreadsheet and the DDE connection works fine there. The DDE connection only works with spreadsheets. I can get the pricing from my vendor using a DDE connection. The data has to be in a spreadsheet as we need up to the minute pricing. Apparently Base can read from a Calc spreadsheet but not write to it. I have been reading the documentation about Base.
I want to enter data into a Calc spreadsheet using a form.
0 kommentar(er)
