sc/qa/unit/data/functions/date_time/fods/timevalue.fods | 19 ++++++++++++++++
1 file changed, 19 insertions(+)
New commits:
commit 9b2d6b36815cbfee8b44b87b7c0b3cb4bab61850
Author: Xisco Fauli <xiscofa...@libreoffice.org>
AuthorDate: Wed Nov 22 15:30:30 2023 +0100
Commit: Xisco Fauli <xiscofa...@libreoffice.org>
CommitDate: Wed Nov 22 16:27:28 2023 +0100
tdf#127498: sc_datetime_functions: Add unittest
it fails with
Sheet2.A9 '=TIMEVALUE(K9)' result: 0.354166666664241, expected:
0.354166666666667
without the fix in place
Change-Id: I4e6faff1b7eb1913ca668ef11b489076e793adc6
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/159820
Tested-by: Jenkins
Reviewed-by: Xisco Fauli <xiscofa...@libreoffice.org>
diff --git a/sc/qa/unit/data/functions/date_time/fods/timevalue.fods
b/sc/qa/unit/data/functions/date_time/fods/timevalue.fods
index 6ce8e134f89b..e465fd2312b8 100644
--- a/sc/qa/unit/data/functions/date_time/fods/timevalue.fods
+++ b/sc/qa/unit/data/functions/date_time/fods/timevalue.fods
@@ -668,6 +668,25 @@
</table:table-cell>
<table:table-cell table:number-columns-repeated="3"/>
</table:table-row>
+ <table:table-row table:style-name="ro2">
+ <table:table-cell table:formula="of:=TIMEVALUE([.K9])"
office:value-type="float" office:value="0.354166666666667"
calcext:value-type="float">
+ <text:p>0.354166666666667</text:p>
+ </table:table-cell>
+ <table:table-cell office:value-type="float"
office:value="0.354166666666667" calcext:value-type="float">
+ <text:p>0.354166666666667</text:p>
+ </table:table-cell>
+ <table:table-cell table:style-name="ce14" table:formula="of:=[.A9]=[.B9]"
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="ce12"
table:formula="of:=FORMULA([.A9])" office:value-type="string"
office:string-value="=TIMEVALUE(K9)" calcext:value-type="string">
+ <text:p>=TIMEVALUE(K9)</text:p>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="6"/>
+ <table:table-cell table:style-name="ce17" office:value-type="string"
calcext:value-type="string">
+ <text:p><text:s/>01/09/2019 08:30:00</text:p>
+ </table:table-cell>
+ <table:table-cell table:number-columns-repeated="3"/>
+ </table:table-row>
<table:table-row table:style-name="ro2">
<table:table-cell table:number-columns-repeated="2"/>
<table:table-cell table:style-name="ce15"/>
