[Solved] Enter data using form to write into spreadsheet
Posted: Sun Aug 04, 2013 5:05 am
I am a LibreOffice novice.
I want to enter data into a Calc spreadsheet using a form. I was told Calc does not have forms.
I have been reading the documentation about Base. Apparently Base can read from a Calc spreadsheet but not write to it.
The data has to be in a spreadsheet as we need up to the minute pricing. I can get the pricing from my vendor using a DDE connection. The DDE connection only works with spreadsheets. I created a Calc spreadsheet and the DDE connection works fine there. So thanks to all who wrote LibreOffice to make that possible.
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. Excel has forms. We are currently using Excel but I want to abandon Excel and abandon using Windows operating system altogether.
Others must have faced the same problem. If a form cannot be created in Calc, what needs to enable a form in Base to enter data into a spreadsheet?
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?
Thank you.
I want to enter data into a Calc spreadsheet using a form. I was told Calc does not have forms.
I have been reading the documentation about Base. Apparently Base can read from a Calc spreadsheet but not write to it.
The data has to be in a spreadsheet as we need up to the minute pricing. I can get the pricing from my vendor using a DDE connection. The DDE connection only works with spreadsheets. I created a Calc spreadsheet and the DDE connection works fine there. So thanks to all who wrote LibreOffice to make that possible.
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. Excel has forms. We are currently using Excel but I want to abandon Excel and abandon using Windows operating system altogether.
Others must have faced the same problem. If a form cannot be created in Calc, what needs to enable a form in Base to enter data into a spreadsheet?
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?
Thank you.