| /************************************************************** |
| * |
| * Licensed to the Apache Software Foundation (ASF) under one |
| * or more contributor license agreements. See the NOTICE file |
| * distributed with this work for additional information |
| * regarding copyright ownership. The ASF licenses this file |
| * to you under the Apache License, Version 2.0 (the |
| * "License"); you may not use this file except in compliance |
| * with the License. You may obtain a copy of the License at |
| * |
| * http://www.apache.org/licenses/LICENSE-2.0 |
| * |
| * Unless required by applicable law or agreed to in writing, |
| * software distributed under the License is distributed on an |
| * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| * KIND, either express or implied. See the License for the |
| * specific language governing permissions and limitations |
| * under the License. |
| * |
| *************************************************************/ |
| |
| |
| |
| // MARKER(update_precomp.py): autogen include statement, do not remove |
| #include "precompiled_sc.hxx" |
| |
| #include "addinhelpid.hxx" |
| #include "sc.hrc" |
| |
| // ============================================================================ |
| |
| // A struct containing the built-in function name and the built-in help ID. |
| struct ScUnoAddInHelpId |
| { |
| const sal_Char* pFuncName; |
| const sal_Char* sHelpId; |
| }; |
| |
| |
| // ---------------------------------------------------------------------------- |
| |
| // Help IDs for Analysis AddIn. MUST BE SORTED for binary search. |
| const ScUnoAddInHelpId pAnalysisHelpIds[] = |
| { |
| { "getAccrint" , HID_AAI_FUNC_ACCRINT }, |
| { "getAccrintm" , HID_AAI_FUNC_ACCRINTM }, |
| { "getAmordegrc" , HID_AAI_FUNC_AMORDEGRC }, |
| { "getAmorlinc" , HID_AAI_FUNC_AMORLINC }, |
| { "getBesseli" , HID_AAI_FUNC_BESSELI }, |
| { "getBesselj" , HID_AAI_FUNC_BESSELJ }, |
| { "getBesselk" , HID_AAI_FUNC_BESSELK }, |
| { "getBessely" , HID_AAI_FUNC_BESSELY }, |
| { "getBin2Dec" , HID_AAI_FUNC_BIN2DEC }, |
| { "getBin2Hex" , HID_AAI_FUNC_BIN2HEX }, |
| { "getBin2Oct" , HID_AAI_FUNC_BIN2OCT }, |
| { "getComplex" , HID_AAI_FUNC_COMPLEX }, |
| { "getConvert" , HID_AAI_FUNC_CONVERT }, |
| { "getCoupdaybs" , HID_AAI_FUNC_COUPDAYBS }, |
| { "getCoupdays" , HID_AAI_FUNC_COUPDAYS }, |
| { "getCoupdaysnc" , HID_AAI_FUNC_COUPDAYSNC }, |
| { "getCoupncd" , HID_AAI_FUNC_COUPNCD }, |
| { "getCoupnum" , HID_AAI_FUNC_COUPNUM }, |
| { "getCouppcd" , HID_AAI_FUNC_COUPPCD }, |
| { "getCumipmt" , HID_AAI_FUNC_CUMIPMT }, |
| { "getCumprinc" , HID_AAI_FUNC_CUMPRINC }, |
| { "getDec2Bin" , HID_AAI_FUNC_DEC2BIN }, |
| { "getDec2Hex" , HID_AAI_FUNC_DEC2HEX }, |
| { "getDec2Oct" , HID_AAI_FUNC_DEC2OCT }, |
| { "getDelta" , HID_AAI_FUNC_DELTA }, |
| { "getDisc" , HID_AAI_FUNC_DISC }, |
| { "getDollarde" , HID_AAI_FUNC_DOLLARDE }, |
| { "getDollarfr" , HID_AAI_FUNC_DOLLARFR }, |
| { "getDuration" , HID_AAI_FUNC_DURATION }, |
| { "getEdate" , HID_AAI_FUNC_EDATE }, |
| { "getEffect" , HID_AAI_FUNC_EFFECT }, |
| { "getEomonth" , HID_AAI_FUNC_EOMONTH }, |
| { "getErf" , HID_AAI_FUNC_ERF }, |
| { "getErfc" , HID_AAI_FUNC_ERFC }, |
| { "getFactdouble" , HID_AAI_FUNC_FACTDOUBLE }, |
| { "getFvschedule" , HID_AAI_FUNC_FVSCHEDULE }, |
| { "getGcd" , HID_AAI_FUNC_GCD }, |
| { "getGestep" , HID_AAI_FUNC_GESTEP }, |
| { "getHex2Bin" , HID_AAI_FUNC_HEX2BIN }, |
| { "getHex2Dec" , HID_AAI_FUNC_HEX2DEC }, |
| { "getHex2Oct" , HID_AAI_FUNC_HEX2OCT }, |
| { "getImabs" , HID_AAI_FUNC_IMABS }, |
| { "getImaginary" , HID_AAI_FUNC_IMAGINARY }, |
| { "getImargument" , HID_AAI_FUNC_IMARGUMENT }, |
| { "getImconjugate" , HID_AAI_FUNC_IMCONJUGATE }, |
| { "getImcos" , HID_AAI_FUNC_IMCOS }, |
| { "getImcosh" , HID_AAI_FUNC_IMCOSH }, |
| { "getImcot" , HID_AAI_FUNC_IMCOT }, |
| { "getImcsc" , HID_AAI_FUNC_IMCSC }, |
| { "getImcsch" , HID_AAI_FUNC_IMCSCH }, |
| { "getImdiv" , HID_AAI_FUNC_IMDIV }, |
| { "getImexp" , HID_AAI_FUNC_IMEXP }, |
| { "getImln" , HID_AAI_FUNC_IMLN }, |
| { "getImlog10" , HID_AAI_FUNC_IMLOG10 }, |
| { "getImlog2" , HID_AAI_FUNC_IMLOG2 }, |
| { "getImpower" , HID_AAI_FUNC_IMPOWER }, |
| { "getImproduct" , HID_AAI_FUNC_IMPRODUCT }, |
| { "getImreal" , HID_AAI_FUNC_IMREAL }, |
| { "getImsec" , HID_AAI_FUNC_IMSEC }, |
| { "getImsech" , HID_AAI_FUNC_IMSECH }, |
| { "getImsin" , HID_AAI_FUNC_IMSIN }, |
| { "getImsinh" , HID_AAI_FUNC_IMSINH }, |
| { "getImsqrt" , HID_AAI_FUNC_IMSQRT }, |
| { "getImsub" , HID_AAI_FUNC_IMSUB }, |
| { "getImsum" , HID_AAI_FUNC_IMSUM }, |
| { "getImtan" , HID_AAI_FUNC_IMTAN }, |
| { "getIntrate" , HID_AAI_FUNC_INTRATE }, |
| { "getIseven" , HID_AAI_FUNC_ISEVEN }, |
| { "getIsodd" , HID_AAI_FUNC_ISODD }, |
| { "getLcm" , HID_AAI_FUNC_LCM }, |
| { "getMduration" , HID_AAI_FUNC_MDURATION }, |
| { "getMround" , HID_AAI_FUNC_MROUND }, |
| { "getMultinomial" , HID_AAI_FUNC_MULTINOMIAL }, |
| { "getNetworkdays" , HID_AAI_FUNC_NETWORKDAYS }, |
| { "getNominal" , HID_AAI_FUNC_NOMINAL }, |
| { "getOct2Bin" , HID_AAI_FUNC_OCT2BIN }, |
| { "getOct2Dec" , HID_AAI_FUNC_OCT2DEZ }, |
| { "getOct2Hex" , HID_AAI_FUNC_OCT2HEX }, |
| { "getOddfprice" , HID_AAI_FUNC_ODDFPRICE }, |
| { "getOddfyield" , HID_AAI_FUNC_ODDFYIELD }, |
| { "getOddlprice" , HID_AAI_FUNC_ODDLPRICE }, |
| { "getOddlyield" , HID_AAI_FUNC_ODDLYIELD }, |
| { "getPrice" , HID_AAI_FUNC_PRICE }, |
| { "getPricedisc" , HID_AAI_FUNC_PRICEDISC }, |
| { "getPricemat" , HID_AAI_FUNC_PRICEMAT }, |
| { "getQuotient" , HID_AAI_FUNC_QUOTIENT }, |
| { "getRandbetween" , HID_AAI_FUNC_RANDBETWEEN }, |
| { "getReceived" , HID_AAI_FUNC_RECEIVED }, |
| { "getSeriessum" , HID_AAI_FUNC_SERIESSUM }, |
| { "getSqrtpi" , HID_AAI_FUNC_SQRTPI }, |
| { "getTbilleq" , HID_AAI_FUNC_TBILLEQ }, |
| { "getTbillprice" , HID_AAI_FUNC_TBILLPRICE }, |
| { "getTbillyield" , HID_AAI_FUNC_TBILLYIELD }, |
| { "getWeeknum" , HID_AAI_FUNC_WEEKNUM }, |
| { "getWorkday" , HID_AAI_FUNC_WORKDAY }, |
| { "getXirr" , HID_AAI_FUNC_XIRR }, |
| { "getXnpv" , HID_AAI_FUNC_XNPV }, |
| { "getYearfrac" , HID_AAI_FUNC_YEARFRAC }, |
| { "getYield" , HID_AAI_FUNC_YIELD }, |
| { "getYielddisc" , HID_AAI_FUNC_YIELDDISC }, |
| { "getYieldmat" , HID_AAI_FUNC_YIELDMAT } |
| }; |
| |
| |
| // ---------------------------------------------------------------------------- |
| |
| // Help IDs for DateFunc AddIn. MUST BE SORTED for binary search. |
| const ScUnoAddInHelpId pDateFuncHelpIds[] = |
| { |
| { "getDaysInMonth" , HID_DAI_FUNC_DAYSINMONTH }, |
| { "getDaysInYear" , HID_DAI_FUNC_DAYSINYEAR }, |
| { "getDiffMonths" , HID_DAI_FUNC_DIFFMONTHS }, |
| { "getDiffWeeks" , HID_DAI_FUNC_DIFFWEEKS }, |
| { "getDiffYears" , HID_DAI_FUNC_DIFFYEARS }, |
| { "getRot13" , HID_DAI_FUNC_ROT13 }, |
| { "getWeeksInYear" , HID_DAI_FUNC_WEEKSINYEAR } |
| }; |
| |
| |
| // ============================================================================ |
| |
| //UNUSED2008-05 ScUnoAddInHelpIdGenerator::ScUnoAddInHelpIdGenerator() : |
| //UNUSED2008-05 pCurrHelpIds( NULL ), |
| //UNUSED2008-05 nArrayCount( 0 ) |
| //UNUSED2008-05 { |
| //UNUSED2008-05 } |
| |
| ScUnoAddInHelpIdGenerator::ScUnoAddInHelpIdGenerator( const ::rtl::OUString& rServiceName ) |
| { |
| SetServiceName( rServiceName ); |
| } |
| |
| void ScUnoAddInHelpIdGenerator::SetServiceName( const ::rtl::OUString& rServiceName ) |
| { |
| pCurrHelpIds = NULL; |
| sal_uInt32 nSize = 0; |
| |
| if( rServiceName.equalsAscii( "com.sun.star.sheet.addin.Analysis" ) ) |
| { |
| pCurrHelpIds = pAnalysisHelpIds; |
| nSize = sizeof( pAnalysisHelpIds ); |
| } |
| else if( rServiceName.equalsAscii( "com.sun.star.sheet.addin.DateFunctions" ) ) |
| { |
| pCurrHelpIds = pDateFuncHelpIds; |
| nSize = sizeof( pDateFuncHelpIds ); |
| } |
| |
| nArrayCount = nSize / sizeof( ScUnoAddInHelpId ); |
| } |
| |
| rtl::OString ScUnoAddInHelpIdGenerator::GetHelpId( const ::rtl::OUString& rFuncName ) const |
| { |
| if( !pCurrHelpIds || !nArrayCount ) |
| return rtl::OString(); |
| |
| const ScUnoAddInHelpId* pFirst = pCurrHelpIds; |
| const ScUnoAddInHelpId* pLast = pCurrHelpIds + nArrayCount - 1; |
| |
| while( pFirst <= pLast ) |
| { |
| const ScUnoAddInHelpId* pMiddle = pFirst + (pLast - pFirst) / 2; |
| sal_Int32 nResult = rFuncName.compareToAscii( pMiddle->pFuncName ); |
| if( !nResult ) |
| return pMiddle->sHelpId; |
| else if( nResult < 0 ) |
| pLast = pMiddle - 1; |
| else |
| pFirst = pMiddle + 1; |
| } |
| |
| return rtl::OString(); |
| } |
| |
| |
| // ============================================================================ |
| |
