I have a spreadsheet this is basically an invoice. I need to make sure the user enters a persons phone number into a cell. Currently I have the word ‘Required’ in the field. However, ‘some users’ don’t understand they actually HAVE to enter a phone number into this cell. How can I make sure the user actually enters something into this field before saving / printing the sheet?
As far as I know there is no readymade tool to accomplish what you intend.
You can define mandatory fields, however, for database records …
Actually I would suggest to use a database for business purposes of the kind anyway.
To get Calc do it as you want you will need some somersaults.
-1- Remove all the icons/menu_items for printing and saving from menus and toolbars with the document (template) as the scope.
-2- Insert pushbuttons for printing and saving into your sheet and assign respective Sub to their action events.
-3- Assign a Sub looking for the contents of the mandatory fields (cells now) to the sheet event ‘Content changed’.
-4- You may use a global variable keepimg a Boolean result meaning “All mandatory entries present”…
-5- Use the result of the processes described under 3, 4 to set the pushbuttons enabled/disabled as needed.
I tried it in a playful way (and not at all foolproof), and would assume you need hours (not too few) to accomplish the task - and weeks of learning if you not are already trained in programmimg for LibreOffice.
Thank you for the reply! Not what I was hoping for, but expected.