xref: /aoo41x/main/basic/source/sbx/sbxdbl.cxx (revision cdf0e10c)
1*cdf0e10cSrcweir /*************************************************************************
2*cdf0e10cSrcweir  *
3*cdf0e10cSrcweir  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
4*cdf0e10cSrcweir  *
5*cdf0e10cSrcweir  * Copyright 2000, 2010 Oracle and/or its affiliates.
6*cdf0e10cSrcweir  *
7*cdf0e10cSrcweir  * OpenOffice.org - a multi-platform office productivity suite
8*cdf0e10cSrcweir  *
9*cdf0e10cSrcweir  * This file is part of OpenOffice.org.
10*cdf0e10cSrcweir  *
11*cdf0e10cSrcweir  * OpenOffice.org is free software: you can redistribute it and/or modify
12*cdf0e10cSrcweir  * it under the terms of the GNU Lesser General Public License version 3
13*cdf0e10cSrcweir  * only, as published by the Free Software Foundation.
14*cdf0e10cSrcweir  *
15*cdf0e10cSrcweir  * OpenOffice.org is distributed in the hope that it will be useful,
16*cdf0e10cSrcweir  * but WITHOUT ANY WARRANTY; without even the implied warranty of
17*cdf0e10cSrcweir  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
18*cdf0e10cSrcweir  * GNU Lesser General Public License version 3 for more details
19*cdf0e10cSrcweir  * (a copy is included in the LICENSE file that accompanied this code).
20*cdf0e10cSrcweir  *
21*cdf0e10cSrcweir  * You should have received a copy of the GNU Lesser General Public License
22*cdf0e10cSrcweir  * version 3 along with OpenOffice.org.  If not, see
23*cdf0e10cSrcweir  * <http://www.openoffice.org/license.html>
24*cdf0e10cSrcweir  * for a copy of the LGPLv3 License.
25*cdf0e10cSrcweir  *
26*cdf0e10cSrcweir  ************************************************************************/
27*cdf0e10cSrcweir 
28*cdf0e10cSrcweir // MARKER(update_precomp.py): autogen include statement, do not remove
29*cdf0e10cSrcweir #include "precompiled_basic.hxx"
30*cdf0e10cSrcweir #include <tools/errcode.hxx>
31*cdf0e10cSrcweir #include <basic/sbx.hxx>
32*cdf0e10cSrcweir #include "sbxconv.hxx"
33*cdf0e10cSrcweir #include "runtime.hxx"
34*cdf0e10cSrcweir 
35*cdf0e10cSrcweir double ImpGetDouble( const SbxValues* p )
36*cdf0e10cSrcweir {
37*cdf0e10cSrcweir 	double nRes;
38*cdf0e10cSrcweir 	switch( +p->eType )
39*cdf0e10cSrcweir 	{
40*cdf0e10cSrcweir 		case SbxNULL:
41*cdf0e10cSrcweir 			SbxBase::SetError( SbxERR_CONVERSION );
42*cdf0e10cSrcweir 		case SbxEMPTY:
43*cdf0e10cSrcweir 			nRes = 0; break;
44*cdf0e10cSrcweir 		case SbxCHAR:
45*cdf0e10cSrcweir 			nRes = p->nChar; break;
46*cdf0e10cSrcweir 		case SbxBYTE:
47*cdf0e10cSrcweir 			nRes = p->nByte; break;
48*cdf0e10cSrcweir 		case SbxINTEGER:
49*cdf0e10cSrcweir 		case SbxBOOL:
50*cdf0e10cSrcweir 			nRes = p->nInteger; break;
51*cdf0e10cSrcweir 		case SbxERROR:
52*cdf0e10cSrcweir 		case SbxUSHORT:
53*cdf0e10cSrcweir 			nRes = p->nUShort; break;
54*cdf0e10cSrcweir 		case SbxLONG:
55*cdf0e10cSrcweir 			nRes = p->nLong; break;
56*cdf0e10cSrcweir 		case SbxULONG:
57*cdf0e10cSrcweir 			nRes = p->nULong; break;
58*cdf0e10cSrcweir 		case SbxSINGLE:
59*cdf0e10cSrcweir 			nRes = p->nSingle; break;
60*cdf0e10cSrcweir 		case SbxDATE:
61*cdf0e10cSrcweir 		case SbxDOUBLE:
62*cdf0e10cSrcweir 			nRes = p->nDouble; break;
63*cdf0e10cSrcweir 		case SbxCURRENCY:
64*cdf0e10cSrcweir 			nRes = ImpCurrencyToDouble( p->nLong64 ); break;
65*cdf0e10cSrcweir 		case SbxSALINT64:
66*cdf0e10cSrcweir             nRes = static_cast< double >(p->nInt64); break;
67*cdf0e10cSrcweir 		case SbxSALUINT64:
68*cdf0e10cSrcweir             nRes = ImpSalUInt64ToDouble( p->uInt64 ); break;
69*cdf0e10cSrcweir 		case SbxDECIMAL:
70*cdf0e10cSrcweir 		case SbxBYREF | SbxDECIMAL:
71*cdf0e10cSrcweir 			if( p->pDecimal )
72*cdf0e10cSrcweir 				p->pDecimal->getDouble( nRes );
73*cdf0e10cSrcweir 			else
74*cdf0e10cSrcweir 				nRes = 0.0;
75*cdf0e10cSrcweir 			break;
76*cdf0e10cSrcweir 		case SbxBYREF | SbxSTRING:
77*cdf0e10cSrcweir 		case SbxSTRING:
78*cdf0e10cSrcweir 		case SbxLPSTR:
79*cdf0e10cSrcweir 			if( !p->pOUString )
80*cdf0e10cSrcweir 			{
81*cdf0e10cSrcweir 				nRes = 0;
82*cdf0e10cSrcweir 				if ( SbiRuntime::isVBAEnabled() )// VBA only behaviour
83*cdf0e10cSrcweir 					SbxBase::SetError( SbxERR_CONVERSION );
84*cdf0e10cSrcweir 			}
85*cdf0e10cSrcweir 			else
86*cdf0e10cSrcweir 			{
87*cdf0e10cSrcweir 				double d;
88*cdf0e10cSrcweir 				SbxDataType t;
89*cdf0e10cSrcweir 				if( ImpScan( *p->pOUString, d, t, NULL ) != SbxERR_OK )
90*cdf0e10cSrcweir 				{
91*cdf0e10cSrcweir 					nRes = 0;
92*cdf0e10cSrcweir 					if ( SbiRuntime::isVBAEnabled() )// VBA only behaviour
93*cdf0e10cSrcweir 						SbxBase::SetError( SbxERR_CONVERSION );
94*cdf0e10cSrcweir 				}
95*cdf0e10cSrcweir 				else
96*cdf0e10cSrcweir 					nRes = d;
97*cdf0e10cSrcweir 			}
98*cdf0e10cSrcweir 			break;
99*cdf0e10cSrcweir 		case SbxOBJECT:
100*cdf0e10cSrcweir 		{
101*cdf0e10cSrcweir 			SbxValue* pVal = PTR_CAST(SbxValue,p->pObj);
102*cdf0e10cSrcweir 			if( pVal )
103*cdf0e10cSrcweir 				nRes = pVal->GetDouble();
104*cdf0e10cSrcweir 			else
105*cdf0e10cSrcweir 			{
106*cdf0e10cSrcweir 				SbxBase::SetError( SbxERR_NO_OBJECT ); nRes = 0;
107*cdf0e10cSrcweir 			}
108*cdf0e10cSrcweir 			break;
109*cdf0e10cSrcweir 		}
110*cdf0e10cSrcweir 
111*cdf0e10cSrcweir 		case SbxBYREF | SbxCHAR:
112*cdf0e10cSrcweir 			nRes = *p->pChar; break;
113*cdf0e10cSrcweir 		case SbxBYREF | SbxBYTE:
114*cdf0e10cSrcweir 			nRes = *p->pByte; break;
115*cdf0e10cSrcweir 		case SbxBYREF | SbxINTEGER:
116*cdf0e10cSrcweir 		case SbxBYREF | SbxBOOL:
117*cdf0e10cSrcweir 			nRes = *p->pInteger; break;
118*cdf0e10cSrcweir 		case SbxBYREF | SbxLONG:
119*cdf0e10cSrcweir 			nRes = *p->pLong; break;
120*cdf0e10cSrcweir 		case SbxBYREF | SbxULONG:
121*cdf0e10cSrcweir 			nRes = *p->pULong; break;
122*cdf0e10cSrcweir 		case SbxBYREF | SbxERROR:
123*cdf0e10cSrcweir 		case SbxBYREF | SbxUSHORT:
124*cdf0e10cSrcweir 			nRes = *p->pUShort; break;
125*cdf0e10cSrcweir 		case SbxBYREF | SbxSINGLE:
126*cdf0e10cSrcweir 			nRes = *p->pSingle; break;
127*cdf0e10cSrcweir 		case SbxBYREF | SbxDATE:
128*cdf0e10cSrcweir 		case SbxBYREF | SbxDOUBLE:
129*cdf0e10cSrcweir 			nRes = *p->pDouble; break;
130*cdf0e10cSrcweir 		case SbxBYREF | SbxCURRENCY:
131*cdf0e10cSrcweir 			nRes = ImpCurrencyToDouble( *p->pLong64 ); break;
132*cdf0e10cSrcweir 		case SbxBYREF | SbxSALINT64:
133*cdf0e10cSrcweir             nRes = static_cast< double >(*p->pnInt64); break;
134*cdf0e10cSrcweir 		case SbxBYREF | SbxSALUINT64:
135*cdf0e10cSrcweir             nRes = ImpSalUInt64ToDouble( *p->puInt64 ); break;
136*cdf0e10cSrcweir 
137*cdf0e10cSrcweir 		default:
138*cdf0e10cSrcweir 			SbxBase::SetError( SbxERR_CONVERSION ); nRes = 0;
139*cdf0e10cSrcweir 	}
140*cdf0e10cSrcweir 	return nRes;
141*cdf0e10cSrcweir }
142*cdf0e10cSrcweir 
143*cdf0e10cSrcweir void ImpPutDouble( SbxValues* p, double n, sal_Bool bCoreString )
144*cdf0e10cSrcweir {
145*cdf0e10cSrcweir 	SbxValues aTmp;
146*cdf0e10cSrcweir start:
147*cdf0e10cSrcweir 	switch( +p->eType )
148*cdf0e10cSrcweir 	{
149*cdf0e10cSrcweir 		// Hier sind Tests notwendig
150*cdf0e10cSrcweir 		case SbxCHAR:
151*cdf0e10cSrcweir 			aTmp.pChar = &p->nChar; goto direct;
152*cdf0e10cSrcweir 		case SbxBYTE:
153*cdf0e10cSrcweir 			aTmp.pByte = &p->nByte; goto direct;
154*cdf0e10cSrcweir 		case SbxINTEGER:
155*cdf0e10cSrcweir 		case SbxBOOL:
156*cdf0e10cSrcweir 			aTmp.pInteger = &p->nInteger; goto direct;
157*cdf0e10cSrcweir 		case SbxLONG:
158*cdf0e10cSrcweir 		case SbxCURRENCY:
159*cdf0e10cSrcweir 			aTmp.pLong = &p->nLong; goto direct;
160*cdf0e10cSrcweir 		case SbxULONG:
161*cdf0e10cSrcweir 			aTmp.pULong = &p->nULong; goto direct;
162*cdf0e10cSrcweir 		case SbxERROR:
163*cdf0e10cSrcweir 		case SbxUSHORT:
164*cdf0e10cSrcweir 			aTmp.pUShort = &p->nUShort; goto direct;
165*cdf0e10cSrcweir 		case SbxSINGLE:
166*cdf0e10cSrcweir 			aTmp.pSingle = &p->nSingle; goto direct;
167*cdf0e10cSrcweir 		case SbxDECIMAL:
168*cdf0e10cSrcweir 		case SbxBYREF | SbxDECIMAL:
169*cdf0e10cSrcweir 			{
170*cdf0e10cSrcweir 			SbxDecimal* pDec = ImpCreateDecimal( p );
171*cdf0e10cSrcweir 			if( !pDec->setDouble( n ) )
172*cdf0e10cSrcweir 				SbxBase::SetError( SbxERR_OVERFLOW );
173*cdf0e10cSrcweir 			break;
174*cdf0e10cSrcweir 			}
175*cdf0e10cSrcweir 		direct:
176*cdf0e10cSrcweir 			aTmp.eType = SbxDataType( p->eType | SbxBYREF );
177*cdf0e10cSrcweir 			p = &aTmp; goto start;
178*cdf0e10cSrcweir 
179*cdf0e10cSrcweir 			// ab hier nicht mehr
180*cdf0e10cSrcweir 		case SbxSALINT64:
181*cdf0e10cSrcweir             p->nInt64 = ImpDoubleToSalInt64( n ); break;
182*cdf0e10cSrcweir 		case SbxSALUINT64:
183*cdf0e10cSrcweir 			p->uInt64 = ImpDoubleToSalUInt64( n ); break;
184*cdf0e10cSrcweir 		case SbxDATE:
185*cdf0e10cSrcweir 		case SbxDOUBLE:
186*cdf0e10cSrcweir 			p->nDouble = n; break;
187*cdf0e10cSrcweir 
188*cdf0e10cSrcweir 		case SbxBYREF | SbxSTRING:
189*cdf0e10cSrcweir 		case SbxSTRING:
190*cdf0e10cSrcweir 		case SbxLPSTR:
191*cdf0e10cSrcweir 			if( !p->pOUString )
192*cdf0e10cSrcweir 				p->pOUString = new ::rtl::OUString;
193*cdf0e10cSrcweir 			ImpCvtNum( (double) n, 14, *p->pOUString, bCoreString );
194*cdf0e10cSrcweir 			break;
195*cdf0e10cSrcweir 		case SbxOBJECT:
196*cdf0e10cSrcweir 		{
197*cdf0e10cSrcweir 			SbxValue* pVal = PTR_CAST(SbxValue,p->pObj);
198*cdf0e10cSrcweir 			if( pVal )
199*cdf0e10cSrcweir 				pVal->PutDouble( n );
200*cdf0e10cSrcweir 			else
201*cdf0e10cSrcweir 				SbxBase::SetError( SbxERR_NO_OBJECT );
202*cdf0e10cSrcweir 			break;
203*cdf0e10cSrcweir 		}
204*cdf0e10cSrcweir 		case SbxBYREF | SbxCHAR:
205*cdf0e10cSrcweir 			if( n > SbxMAXCHAR )
206*cdf0e10cSrcweir 			{
207*cdf0e10cSrcweir 				SbxBase::SetError( SbxERR_OVERFLOW ); n = SbxMAXCHAR;
208*cdf0e10cSrcweir 			}
209*cdf0e10cSrcweir 			else if( n < SbxMINCHAR )
210*cdf0e10cSrcweir 			{
211*cdf0e10cSrcweir 				SbxBase::SetError( SbxERR_OVERFLOW ); n = SbxMINCHAR;
212*cdf0e10cSrcweir 			}
213*cdf0e10cSrcweir 			*p->pChar = (xub_Unicode) n; break;
214*cdf0e10cSrcweir 		case SbxBYREF | SbxBYTE:
215*cdf0e10cSrcweir 			if( n > SbxMAXBYTE )
216*cdf0e10cSrcweir 			{
217*cdf0e10cSrcweir 				SbxBase::SetError( SbxERR_OVERFLOW ); n = SbxMAXBYTE;
218*cdf0e10cSrcweir 			}
219*cdf0e10cSrcweir 			else if( n < 0 )
220*cdf0e10cSrcweir 			{
221*cdf0e10cSrcweir 				SbxBase::SetError( SbxERR_OVERFLOW ); n = 0;
222*cdf0e10cSrcweir 			}
223*cdf0e10cSrcweir 			*p->pByte = (sal_uInt8) n; break;
224*cdf0e10cSrcweir 		case SbxBYREF | SbxINTEGER:
225*cdf0e10cSrcweir 		case SbxBYREF | SbxBOOL:
226*cdf0e10cSrcweir 			if( n > SbxMAXINT )
227*cdf0e10cSrcweir 			{
228*cdf0e10cSrcweir 				SbxBase::SetError( SbxERR_OVERFLOW ); n = SbxMAXINT;
229*cdf0e10cSrcweir 			}
230*cdf0e10cSrcweir 			else if( n < SbxMININT )
231*cdf0e10cSrcweir 			{
232*cdf0e10cSrcweir 				SbxBase::SetError( SbxERR_OVERFLOW ); n = SbxMININT;
233*cdf0e10cSrcweir 			}
234*cdf0e10cSrcweir 			*p->pInteger = (sal_Int16) n; break;
235*cdf0e10cSrcweir 		case SbxBYREF | SbxERROR:
236*cdf0e10cSrcweir 		case SbxBYREF | SbxUSHORT:
237*cdf0e10cSrcweir 			if( n > SbxMAXUINT )
238*cdf0e10cSrcweir 			{
239*cdf0e10cSrcweir 				SbxBase::SetError( SbxERR_OVERFLOW ); n = SbxMAXUINT;
240*cdf0e10cSrcweir 			}
241*cdf0e10cSrcweir 			else if( n < 0 )
242*cdf0e10cSrcweir 			{
243*cdf0e10cSrcweir 				SbxBase::SetError( SbxERR_OVERFLOW ); n = 0;
244*cdf0e10cSrcweir 			}
245*cdf0e10cSrcweir 			*p->pUShort = (sal_uInt16) n; break;
246*cdf0e10cSrcweir 		case SbxBYREF | SbxLONG:
247*cdf0e10cSrcweir 			if( n > SbxMAXLNG )
248*cdf0e10cSrcweir 			{
249*cdf0e10cSrcweir 				SbxBase::SetError( SbxERR_OVERFLOW ); n = SbxMAXLNG;
250*cdf0e10cSrcweir 			}
251*cdf0e10cSrcweir 			else if( n < SbxMINLNG )
252*cdf0e10cSrcweir 			{
253*cdf0e10cSrcweir 				SbxBase::SetError( SbxERR_OVERFLOW ); n = SbxMINLNG;
254*cdf0e10cSrcweir 			}
255*cdf0e10cSrcweir 			*p->pLong = (sal_Int32) n; break;
256*cdf0e10cSrcweir 		case SbxBYREF | SbxULONG:
257*cdf0e10cSrcweir 			if( n > SbxMAXULNG )
258*cdf0e10cSrcweir 			{
259*cdf0e10cSrcweir 				SbxBase::SetError( SbxERR_OVERFLOW ); n = SbxMAXULNG;
260*cdf0e10cSrcweir 			}
261*cdf0e10cSrcweir 			else if( n < 0 )
262*cdf0e10cSrcweir 			{
263*cdf0e10cSrcweir 				SbxBase::SetError( SbxERR_OVERFLOW ); n = 0;
264*cdf0e10cSrcweir 			}
265*cdf0e10cSrcweir 			*p->pULong = (sal_uInt32) n; break;
266*cdf0e10cSrcweir 		case SbxBYREF | SbxSINGLE:
267*cdf0e10cSrcweir 			if( n > SbxMAXSNG )
268*cdf0e10cSrcweir 			{
269*cdf0e10cSrcweir 				SbxBase::SetError( SbxERR_OVERFLOW ); n = SbxMAXSNG;
270*cdf0e10cSrcweir 			}
271*cdf0e10cSrcweir 			else if( n < SbxMINSNG )
272*cdf0e10cSrcweir 			{
273*cdf0e10cSrcweir 				SbxBase::SetError( SbxERR_OVERFLOW ); n = SbxMINSNG;
274*cdf0e10cSrcweir 			}
275*cdf0e10cSrcweir 			else if( n > 0 && n < SbxMAXSNG2 )
276*cdf0e10cSrcweir 			{
277*cdf0e10cSrcweir 				SbxBase::SetError( SbxERR_OVERFLOW ); n = SbxMAXSNG2;
278*cdf0e10cSrcweir 			}
279*cdf0e10cSrcweir 			else if( n < 0 && n > SbxMINSNG2 )
280*cdf0e10cSrcweir 			{
281*cdf0e10cSrcweir 				SbxBase::SetError( SbxERR_OVERFLOW ); n = SbxMINSNG2;
282*cdf0e10cSrcweir 			}
283*cdf0e10cSrcweir 			*p->pSingle = (float) n; break;
284*cdf0e10cSrcweir 		case SbxBYREF | SbxSALINT64:
285*cdf0e10cSrcweir             *p->pnInt64 = ImpDoubleToSalInt64( n ); break;
286*cdf0e10cSrcweir 		case SbxBYREF | SbxSALUINT64:
287*cdf0e10cSrcweir 			*p->puInt64 = ImpDoubleToSalUInt64( n ); break;
288*cdf0e10cSrcweir 		case SbxBYREF | SbxDATE:
289*cdf0e10cSrcweir 		case SbxBYREF | SbxDOUBLE:
290*cdf0e10cSrcweir 			*p->pDouble = (double) n; break;
291*cdf0e10cSrcweir 		case SbxBYREF | SbxCURRENCY:
292*cdf0e10cSrcweir 			if( n > SbxMAXCURR )
293*cdf0e10cSrcweir 			{
294*cdf0e10cSrcweir 				SbxBase::SetError( SbxERR_OVERFLOW ); n = SbxMAXCURR;
295*cdf0e10cSrcweir 			}
296*cdf0e10cSrcweir 			else if( n < SbxMINCURR )
297*cdf0e10cSrcweir 			{
298*cdf0e10cSrcweir 				SbxBase::SetError( SbxERR_OVERFLOW ); n = SbxMINCURR;
299*cdf0e10cSrcweir 			}
300*cdf0e10cSrcweir 			*p->pLong64 = ImpDoubleToCurrency( n ); break;
301*cdf0e10cSrcweir 
302*cdf0e10cSrcweir 		default:
303*cdf0e10cSrcweir 			SbxBase::SetError( SbxERR_CONVERSION );
304*cdf0e10cSrcweir 	}
305*cdf0e10cSrcweir }
306*cdf0e10cSrcweir 
307