diff options
| author | Xisco Fauli <xiscofauli@libreoffice.org> | 2023-10-16 17:07:35 +0200 |
|---|---|---|
| committer | Xisco Fauli <xiscofauli@libreoffice.org> | 2023-10-17 08:51:15 +0200 |
| commit | 07a80b8940a16ba1b7fd047865179809bd74a563 (patch) | |
| tree | 540219b6b43314e71fbeb315fdf70f771d6a9a75 | |
| parent | a55e2ad714ff941a2aa2c725ffbc1057fbd9baf5 (diff) | |
tdf#157786: sc_datetime_functions: Add unittest
Change-Id: I94f2d40ced8e59aea5875831289368722a58c42a
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/158056
Tested-by: Jenkins
Reviewed-by: Xisco Fauli <xiscofauli@libreoffice.org>
| -rw-r--r-- | sc/qa/unit/data/functions/date_time/fods/day.fods | 17 |
1 files changed, 16 insertions, 1 deletions
diff --git a/sc/qa/unit/data/functions/date_time/fods/day.fods b/sc/qa/unit/data/functions/date_time/fods/day.fods index 61bf753c24fa..88898d5c9349 100644 --- a/sc/qa/unit/data/functions/date_time/fods/day.fods +++ b/sc/qa/unit/data/functions/date_time/fods/day.fods @@ -659,6 +659,21 @@ </table:table-cell> <table:table-cell table:number-columns-repeated="9"/> </table:table-row> + <table:table-row table:style-name="ro5"> + <table:table-cell table:style-name="ce29" table:formula="of:=DAY("1899-12-29T15:26:14")" office:value-type="float" office:value="29" calcext:value-type="float"> + <text:p>29</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce31" office:value-type="float" office:value="29" calcext:value-type="float"> + <text:p>29</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce32" table:formula="of:=[.A5]=[.B5]" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce33" office:value-type="string" calcext:value-type="string"> + <text:p>DAY("1899-12-29T15:26:14")</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="10"/> + </table:table-row> <table:table-row table:style-name="ro2"> <table:table-cell table:number-columns-repeated="9"/> <table:table-cell table:style-name="ce34" table:number-columns-repeated="5"/> @@ -698,7 +713,7 @@ <table:table-cell table:number-columns-repeated="14"/> </table:table-row> <calcext:conditional-formats> - <calcext:conditional-format calcext:target-range-address="Sheet2.C2:Sheet2.C4"> + <calcext:conditional-format calcext:target-range-address="Sheet2.C2:Sheet2.C10"> <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C2"/> <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C2"/> <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C2"/> |