[Libreoffice-commits] core.git: sc/qa

[Xisco Fauli (via logerrit)]

 sc/qa/unit/data/functions/date_time/fods/day.fods |   17 ++++++++++++++++-
 1 file changed, 16 insertions(+), 1 deletion(-)

New commits:
commit 07a80b8940a16ba1b7fd047865179809bd74a563
Author:     Xisco Fauli <xiscofa...@libreoffice.org>
AuthorDate: Mon Oct 16 17:07:35 2023 +0200
Commit:     Xisco Fauli <xiscofa...@libreoffice.org>
CommitDate: Tue Oct 17 08:51:15 2023 +0200

    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 <xiscofa...@libreoffice.org>

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(&quot;1899-12-29T15:26:14&quot;)" 
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(&quot;1899-12-29T15:26:14&quot;)</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="=&quot;&quot;" 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"/>