Pergunte aqui

Perfil de rvk - atividade

2019-02-21 12:13:13 +0200 Medalha recebida  Entusiasta
2019-02-11 10:20:10 +0200 Resposta comentada Possible to set invalid values through macro and automation

Thank you for your answer. I was hoping there was some interface to the validation but I guess I have to do the validati

2019-02-11 10:18:37 +0200 Marcada como a melhor resposta 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.

2019-02-11 10:18:37 +0200 Medalha recebida  Acadêmico (fonte)
2019-02-09 20:24:01 +0200 Medalha recebida  Pergunta popular (fonte)
2019-02-08 17:36:26 +0200 Perguntou Possible to set invalid values through macro and automation

Possible to set invalid values through macro and automation I'm trying to automate LibreOffice and noticed I could set i