summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--svl/qa/unit/svl.cxx20
1 files changed, 18 insertions, 2 deletions
diff --git a/svl/qa/unit/svl.cxx b/svl/qa/unit/svl.cxx
index 44878d8565d2..8fb241a940d5 100644
--- a/svl/qa/unit/svl.cxx
+++ b/svl/qa/unit/svl.cxx
@@ -1131,11 +1131,27 @@ void Test::testUserDefinedNumberFormats()
sExpected = "-12.00 ;";
checkPreviewString(aFormatter, sCode, -12.0, eLang, sExpected);
}
- { // tdf#995339: detect SSMM as second minute
- sCode = "SS:MM:HH DD/MM/YY"; // Month not detected by Excel, but we do not follow that.
+ { // tdf#95339: detect SSMM as second minute
+ sCode = "SS:MM:HH DD/MM/YY"; // Month not detected by Excel, but we do not follow that.
sExpected = "54:23:03 02/01/00";
checkPreviewString(aFormatter, sCode, M_PI, eLang, sExpected);
}
+ { // tdf#101147: detect SSMM as second month
+ sCode = "HH:MM:SS MM/DD";
+ sExpected = "03:23:54 01/02";
+ checkPreviewString(aFormatter, sCode, M_PI, eLang, sExpected);
+ }
+ { // tdf#101096: different detection of month/minute with Excel
+ sCode = "HH DD MM"; // month detectected because of previous DD
+ sExpected = "03 02 01";
+ checkPreviewString(aFormatter, sCode, M_PI, eLang, sExpected);
+ sCode = "HH:MM HH DD/MM"; // month detected because of previous DD
+ sExpected = "03:23 03 02/01";
+ checkPreviewString(aFormatter, sCode, M_PI, eLang, sExpected);
+ sCode = "SS:DD-MM-YY SS:MM"; // 1st is month, because of previous DD; 2nd is minute as SS has not minute
+ sExpected = "54:02-01-00 54:23";
+ checkPreviewString(aFormatter, sCode, M_PI, eLang, sExpected);
+ }
{ // tdf#99996: better algorithm for fraction representation
sCode = "# ?/???";
sExpected = "-575 540/697";