1*b1cdbd2cSJim Jagielski /**************************************************************
2*b1cdbd2cSJim Jagielski *
3*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one
4*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file
5*b1cdbd2cSJim Jagielski * distributed with this work for additional information
6*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file
7*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the
8*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance
9*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at
10*b1cdbd2cSJim Jagielski *
11*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0
12*b1cdbd2cSJim Jagielski *
13*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing,
14*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an
15*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the
17*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations
18*b1cdbd2cSJim Jagielski * under the License.
19*b1cdbd2cSJim Jagielski *
20*b1cdbd2cSJim Jagielski *************************************************************/
21*b1cdbd2cSJim Jagielski
22*b1cdbd2cSJim Jagielski
23*b1cdbd2cSJim Jagielski
24*b1cdbd2cSJim Jagielski // MARKER(update_precomp.py): autogen include statement, do not remove
25*b1cdbd2cSJim Jagielski #include "precompiled_sc.hxx"
26*b1cdbd2cSJim Jagielski
27*b1cdbd2cSJim Jagielski // System - Includes -----------------------------------------------------
28*b1cdbd2cSJim Jagielski
29*b1cdbd2cSJim Jagielski #include "stringutil.hxx"
30*b1cdbd2cSJim Jagielski #include "rtl/ustrbuf.hxx"
31*b1cdbd2cSJim Jagielski #include "rtl/math.hxx"
32*b1cdbd2cSJim Jagielski
33*b1cdbd2cSJim Jagielski using ::rtl::OUString;
34*b1cdbd2cSJim Jagielski using ::rtl::OUStringBuffer;
35*b1cdbd2cSJim Jagielski
parseSimpleNumber(const OUString & rStr,sal_Unicode dsep,sal_Unicode gsep,double & rVal)36*b1cdbd2cSJim Jagielski bool ScStringUtil::parseSimpleNumber(
37*b1cdbd2cSJim Jagielski const OUString& rStr, sal_Unicode dsep, sal_Unicode gsep, double& rVal)
38*b1cdbd2cSJim Jagielski {
39*b1cdbd2cSJim Jagielski if (gsep == 0x00A0)
40*b1cdbd2cSJim Jagielski // unicode space to ascii space
41*b1cdbd2cSJim Jagielski gsep = 0x0020;
42*b1cdbd2cSJim Jagielski
43*b1cdbd2cSJim Jagielski OUStringBuffer aBuf;
44*b1cdbd2cSJim Jagielski sal_Int32 n = rStr.getLength();
45*b1cdbd2cSJim Jagielski const sal_Unicode* p = rStr.getStr();
46*b1cdbd2cSJim Jagielski sal_Int32 nPosDSep = -1, nPosGSep = -1;
47*b1cdbd2cSJim Jagielski sal_uInt32 nDigitCount = 0;
48*b1cdbd2cSJim Jagielski
49*b1cdbd2cSJim Jagielski for (sal_Int32 i = 0; i < n; ++i)
50*b1cdbd2cSJim Jagielski {
51*b1cdbd2cSJim Jagielski sal_Unicode c = p[i];
52*b1cdbd2cSJim Jagielski if (c == 0x00A0)
53*b1cdbd2cSJim Jagielski // unicode space to ascii space
54*b1cdbd2cSJim Jagielski c = 0x0020;
55*b1cdbd2cSJim Jagielski
56*b1cdbd2cSJim Jagielski if (sal_Unicode('0') <= c && c <= sal_Unicode('9'))
57*b1cdbd2cSJim Jagielski {
58*b1cdbd2cSJim Jagielski // this is a digit.
59*b1cdbd2cSJim Jagielski aBuf.append(c);
60*b1cdbd2cSJim Jagielski ++nDigitCount;
61*b1cdbd2cSJim Jagielski }
62*b1cdbd2cSJim Jagielski else if (c == dsep)
63*b1cdbd2cSJim Jagielski {
64*b1cdbd2cSJim Jagielski // this is a decimal separator.
65*b1cdbd2cSJim Jagielski
66*b1cdbd2cSJim Jagielski if (nPosDSep >= 0)
67*b1cdbd2cSJim Jagielski // a second decimal separator -> not a valid number.
68*b1cdbd2cSJim Jagielski return false;
69*b1cdbd2cSJim Jagielski
70*b1cdbd2cSJim Jagielski if (nPosGSep >= 0 && i - nPosGSep != 4)
71*b1cdbd2cSJim Jagielski // the number has a group separator and the decimal sep is not
72*b1cdbd2cSJim Jagielski // positioned correctly.
73*b1cdbd2cSJim Jagielski return false;
74*b1cdbd2cSJim Jagielski
75*b1cdbd2cSJim Jagielski nPosDSep = i;
76*b1cdbd2cSJim Jagielski nPosGSep = -1;
77*b1cdbd2cSJim Jagielski aBuf.append(c);
78*b1cdbd2cSJim Jagielski nDigitCount = 0;
79*b1cdbd2cSJim Jagielski }
80*b1cdbd2cSJim Jagielski else if (c == gsep)
81*b1cdbd2cSJim Jagielski {
82*b1cdbd2cSJim Jagielski // this is a group (thousand) separator.
83*b1cdbd2cSJim Jagielski
84*b1cdbd2cSJim Jagielski if (i == 0)
85*b1cdbd2cSJim Jagielski // not allowed as the first character.
86*b1cdbd2cSJim Jagielski return false;
87*b1cdbd2cSJim Jagielski
88*b1cdbd2cSJim Jagielski if (nPosDSep >= 0)
89*b1cdbd2cSJim Jagielski // not allowed after the decimal separator.
90*b1cdbd2cSJim Jagielski return false;
91*b1cdbd2cSJim Jagielski
92*b1cdbd2cSJim Jagielski if (nPosGSep >= 0 && nDigitCount != 3)
93*b1cdbd2cSJim Jagielski // must be exactly 3 digits since the last group separator.
94*b1cdbd2cSJim Jagielski return false;
95*b1cdbd2cSJim Jagielski
96*b1cdbd2cSJim Jagielski nPosGSep = i;
97*b1cdbd2cSJim Jagielski nDigitCount = 0;
98*b1cdbd2cSJim Jagielski }
99*b1cdbd2cSJim Jagielski else if (c == sal_Unicode('-') || c == sal_Unicode('+'))
100*b1cdbd2cSJim Jagielski {
101*b1cdbd2cSJim Jagielski // A sign must be the first character if it's given.
102*b1cdbd2cSJim Jagielski if (i == 0)
103*b1cdbd2cSJim Jagielski aBuf.append(c);
104*b1cdbd2cSJim Jagielski else
105*b1cdbd2cSJim Jagielski return false;
106*b1cdbd2cSJim Jagielski }
107*b1cdbd2cSJim Jagielski else
108*b1cdbd2cSJim Jagielski return false;
109*b1cdbd2cSJim Jagielski }
110*b1cdbd2cSJim Jagielski
111*b1cdbd2cSJim Jagielski // finished parsing the number.
112*b1cdbd2cSJim Jagielski
113*b1cdbd2cSJim Jagielski if (nPosGSep >= 0 && nDigitCount != 3)
114*b1cdbd2cSJim Jagielski // must be exactly 3 digits since the last group separator.
115*b1cdbd2cSJim Jagielski return false;
116*b1cdbd2cSJim Jagielski
117*b1cdbd2cSJim Jagielski rtl_math_ConversionStatus eStatus = rtl_math_ConversionStatus_Ok;
118*b1cdbd2cSJim Jagielski sal_Int32 nParseEnd = 0;
119*b1cdbd2cSJim Jagielski rVal = ::rtl::math::stringToDouble(aBuf.makeStringAndClear(), dsep, gsep, &eStatus, &nParseEnd);
120*b1cdbd2cSJim Jagielski if (eStatus != rtl_math_ConversionStatus_Ok)
121*b1cdbd2cSJim Jagielski return false;
122*b1cdbd2cSJim Jagielski
123*b1cdbd2cSJim Jagielski return true;
124*b1cdbd2cSJim Jagielski }
125