diff options
| author | Marco Cecchetti <marco.cecchetti@collabora.com> | 2018-02-01 12:28:54 +0100 |
|---|---|---|
| committer | Andras Timar <andras.timar@collabora.com> | 2018-06-01 11:02:09 +0200 |
| commit | bafbc97f56693b3ef0752259d59db37539777305 (patch) | |
| tree | ef6039e20c04d74355015c7bb5908aa29ce4753e /sc/uiconfig | |
| parent | 3f387902682f8215f103d9f1620979e11ea24bab (diff) | |
tdf#96698 - calc: add support for custom validation (through a formula)
Now it is possible to select a `custom` validation in the validation
dialog: this type of validation let's the user to define a formula,
the cell content is valid when the formula is evaluted to true, and
not valid when evaluated to false.
The `cutom` validation is correctly saved and restored for ods
documents, and is correctly imported and exported to xlsx documents
This patch contains an adaptation of a preliminary work of Justin Luth
for importing custom validation from xlsx documents. Thanks Justin!
Change-Id: Idc26654ba69a6f73d1b208d63acdad4b880c776d
Reviewed-on: https://gerrit.libreoffice.org/49084
Reviewed-by: Michael Meeks <michael.meeks@collabora.com>
Tested-by: Jenkins <ci@libreoffice.org>
Reviewed-by: Eike Rathke <erack@redhat.com>
(cherry picked from commit f15c4b0f3c2cdfa7a72c97301ff32cc1764c54da)
Signed-off-by: Andras Timar <andras.timar@collabora.com>
Diffstat (limited to 'sc/uiconfig')
| -rw-r--r-- | sc/uiconfig/scalc/ui/validationcriteriapage.ui | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/sc/uiconfig/scalc/ui/validationcriteriapage.ui b/sc/uiconfig/scalc/ui/validationcriteriapage.ui index 22345e0dfa99..2f36057b9335 100644 --- a/sc/uiconfig/scalc/ui/validationcriteriapage.ui +++ b/sc/uiconfig/scalc/ui/validationcriteriapage.ui @@ -43,6 +43,10 @@ <col id="0" translatable="yes" context="validationcriteriapage|liststore1">Text length</col> <col id="1">7</col> </row> + <row> + <col id="0" translatable="yes" context="validationcriteriapage|liststore1">Custom</col> + <col id="1">8</col> + </row> </data> </object> <object class="GtkListStore" id="liststore2"> |