Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Possible to set invalid values through macro and automation

I'm trying to automate LibreOffice and noticed I could set invalid values for certain cells.

I set one cell to only accept whole numbers (through Data>Validity>Whole Numbers) and even though it works when entering these values manually (when entering 1,5 or 1.5 I get the error), I can set it through a macro or automation.

This is also the case for validation LIST where I can set an invalid value for a cell (not in the list given).

Is there a function or method I can use to receive an error or check for validity for a cell before I push a value to it?

B.T.W. Even using Data>Form, where all rows are presented in Form-view, I can enter invalid values. So Data>Validity isn't really checked in lots of places.