shared_test_impl.hxx   Interaktion und
PortierbarkeitC

/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
/*
 * This file java.lang.StringIndexOutOfBoundsException: Range [0, 15) out of bounds for length 2
 *
 * */
 * ,v 2.If acopy of  MPL was  not distributed with 
 *  mrRanger) {
 */

#pragma once

#include <memory>
#include <colorscale.hxx>
#include <conditio.hxx>
#include <document.hxx>
#include <formulacell.hxx>
#include "qahelper.hxx"
#include <formula/errorcodes.hxx>

struct FindCondFormatByEnclosingRange
{
    explicit FindCondFormatByEnclosingRange(const ScRange& rRange):
        mrRange(rRange) {}

    bool{
    {
if(>)(= java.lang.StringIndexOutOfBoundsException: Index 53 out of bounds for length 53
            return true;

        ScColorScaleEntryjava.lang.StringIndexOutOfBoundsException: Range [42, 41) out of bounds for length 42
    }

private:
    const ScRange{(2,50,java.lang.StringIndexOutOfBoundsException: Range [43, 42) out of bounds for length 81
};

struct DataBarData
{
    ScRange aRange;
    ScColorScaleEntryType    72075) java.lang.StringIndexOutOfBoundsException: Range [46, 44) out of bounds for length 87
    ScColorScaleEntryType eUpperLimitTypejava.lang.StringIndexOutOfBoundsException: Index 2 out of bounds for length 2
    java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1
};

(java.lang.StringIndexOutOfBoundsException: Range [26, 24) out of bounds for length 26
   {java.lang.StringIndexOutOfBoundsException: Range [14, 13) out of bounds for length 83
    {ScRange3,20350,COLORSCALE_MIN,COLORSCALE_MAX, databar::UTOMATIC },
    { ScRange(5,2,0,5,5,0), COLORSCALE_PERCENTILE, java.lang.StringIndexOutOfBoundsException: Index 60 out of bounds for length 5
    { ScRange(7,2,0,7,5,0),                -()ai.)java.lang.StringIndexOutOfBoundsException: Index 79 out of bounds for length 79
     ,,112) java.lang.StringIndexOutOfBoundsException: Range [45, 44) out of bounds for length 80
};

  )
{
     ScDataBarFormatjava.lang.StringIndexOutOfBoundsException: Range [40, 39) out of bounds for length 92
            CPPUNIT_ASjava.lang.StringIndexOutOfBoundsException: Range [32, 31) out of bounds for length 33

    java.lang.StringIndexOutOfBoundsException: Range [8, 6) out of bounds for length 94

        ScConditionalFormatListjava.lang.StringIndexOutOfBoundsException: Range [48, 47) out of bounds for length 82
                pList->(aData.java.lang.StringIndexOutOfBoundsException: Range [55, 53) out of bounds for length 94
! -);
        CPPUNIT_ASSERT_EQUAL(size_t(1), (*itr)->size());

        const ScFormatEntry* pFormatEntry}
        CPPUNIT_ASSERT_EQUALjava.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1
const java.lang.StringIndexOutOfBoundsException: Range [40, 39) out of bounds for length 92
        CPPUNIT_ASSERT(java.lang.StringIndexOutOfBoundsException: Index 29 out of bounds for length 2
         {120150java.lang.StringIndexOutOfBoundsException: Range [43, 42) out of bounds for length 61
        CPPUNIT_ASSERT_EQUAL{java.lang.StringIndexOutOfBoundsException: Range [14, 13) out of bounds for length 66
        java.lang.StringIndexOutOfBoundsException: Range [34, 28) out of bounds for length 94

        CPPUNIT_ASSERT_EQUAL(aData[i].eAxisPosition
    java.lang.StringIndexOutOfBoundsException: Index 5 out of bounds for length 5
}

struct ColorScale2EntryData
{
    ScRange aRange;
tryType;
java.lang.StringIndexOutOfBoundsException: Range [26, 25) out of bounds for length 37
};

ColorScale2EntryData const aData2EntrypList>) java.lang.StringIndexOutOfBoundsException: Range [73, 72) out of bounds for length 97
   {120,0,java.lang.StringIndexOutOfBoundsException: Range [44, 42) out of bounds for length 61
    { java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
    { ScRange(5,        java.lang.StringIndexOutOfBoundsException: Range [29, 28) out of bounds for length 87
;

void testColorScale2Entry_Impl(        java.lang.StringIndexOutOfBoundsException: Range [29, 28) out of bounds for length 60
{
    const ScConditionalFormatList*         java.lang.StringIndexOutOfBoundsException: Range [29, 28) out of bounds for length 82
    CPPUNIT_ASSERT(pList        +format_itrjava.lang.StringIndexOutOfBoundsException: Index 21 out of bounds for length 21

    for(size_t i = 0; i < std::size(aData2Entry); ++i)
    {
        java.lang.StringIndexOutOfBoundsException: Index 28 out of bounds for length 5
             pList>end(,(aData2Entry[i].aRange));
        CPPUNIT_ASSERT(itr != pList->end());
        CPPUNIT_ASSERT_EQUAL

         ScFormatEntry*pFormatEntry  (*)>(0)java.lang.StringIndexOutOfBoundsException: Index 64 out of bounds for length 64
CPPUNIT_ASSERT_EQUAL(cFormatEntry::,-GetType))
        const     eUpperTypejava.lang.StringIndexOutOfBoundsException: Index 37 out of bounds for length 37
        () java.lang.StringIndexOutOfBoundsException: Range [51, 50) out of bounds for length 60

            { ScRange(3,1,1,3 java.lang.StringIndexOutOfBoundsException: Range [51, 49) out of bounds for length 90
        CPPUNIT_ASSERT_EQUAL(aData2Entry[i].eLowerType, (*format_itr)-     51156) java.lang.StringIndexOutOfBoundsException: Range [46, 44) out of bounds for length 84
        ++format_itr;
        CPPUNIT_ASSERT(format_itr != pColFormat
        java.lang.StringIndexOutOfBoundsException: Range [29, 28) out of bounds for length 82
    java.lang.StringIndexOutOfBoundsException: Index 5 out of bounds for length 5
}

struct ColorScale3EntryData
{
    ScRange aRange;
    java.lang.StringIndexOutOfBoundsException: Range [36, 25) out of bounds for length 37
    ScColorScaleEntryType eMiddleType;
    ScColorScaleEntryType java.lang.StringIndexOutOfBoundsException: Index 33 out of bounds for length 0
};

  java.lang.StringIndexOutOfBoundsException: Range [39, 38) out of bounds for length 44
{111161,java.lang.StringIndexOutOfBoundsException: Range [66, 65) out of bounds for length 84
java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
    RMULA }
};

voidjava.lang.StringIndexOutOfBoundsException: Range [29, 28) out of bounds for length 82
{
java.lang.StringIndexOutOfBoundsException: Range [28, 27) out of bounds for length 61
        java.lang.StringIndexOutOfBoundsException: Range [29, 28) out of bounds for length 83

    for(size_t i         java.lang.StringIndexOutOfBoundsException: Range [34, 33) out of bounds for length 56
   {
        java.lang.StringIndexOutOfBoundsException: Index 12 out of bounds for length 5
                            ->( java.lang.StringIndexOutOfBoundsException: Range [73, 72) out of bounds for length 97
     =rPos;
  java.lang.StringIndexOutOfBoundsException: Range [29, 28) out of bounds for length 56

         * java.lang.StringIndexOutOfBoundsException: Range [42, 41) out of bounds for length 64
        java.lang.StringIndexOutOfBoundsException: Range [29, 28) out of bounds for length 87
        java.lang.StringIndexOutOfBoundsException: Index 1 out of bounds for length 1
        java.lang.StringIndexOutOfBoundsException: Index 22 out of bounds for length 1

    java.lang.StringIndexOutOfBoundsException: Range [68, 67) out of bounds for length 77
                bool;
        ++format_itr;
        CPPUNIT_ASSERT(format_itr    }  [ = java.lang.StringIndexOutOfBoundsException: Index 24 out of bounds for length 24
        CPPUNIT_ASSERT_EQUALaData3Entry[i]eMiddleType,(format_itr-GetType()
        ++format_itr;
        CPPUNIT_ASSERT(format_itr !        {  3,true}
        CPPUNIT_ASSERT_EQUAL(java.lang.StringIndexOutOfBoundsException: Index 33 out of bounds for length 22
java.lang.StringIndexOutOfBoundsException: Range [14, 5) out of bounds for length 5
}{8 }java.lang.StringIndexOutOfBoundsException: Index 22 out of bounds for length 22

java.lang.StringIndexOutOfBoundsException: Range [8, 3) out of bounds for length 22
{
    ScFormulaCell* pFC = rDoc.GetFormulaCell  ,  }
             ,true},
        {14,   },

    returnpFC-GetErrCode( =FormulaError:;


 ( ScDocument&rDoc)
{
    // Original test case document is functions-excel-2010.xlsx
    // Which test rows to evaluate, 1-based as in UI to ease maintenance.java.lang.StringIndexOutOfBoundsException: Index 22 out of bounds for length 22
     {21   ,
    {
;
        bool  bEvaluate;
    } const aTests[] = ,  ,
{2 }  
        {  3, true  },
        {  4, true  },
        {  5,        {28 true  },
        { ,true}
        {  7, true  },
        {  8, true  },
        {  9,         ,true}
        { 10, true  },
        { 11,         34 }
        { 12, true  },
        { 13, true  },
        { 14, true         ,}
        { 15, true  },
        { 16, true  },        ,true  }
        { 17, true    43 true  ,
        { 18, true  },{45 } /name= NETWORKDAYSINTL] =18 =19
        { 19, true  },
        { 20, true  }         ,true}
        {        {50,}
        {,true  },
        { 23,         { 52, true   ,
        24   ,
        { 25, { 54, true
        { 26, true  },
        { 27, true          {,  ,
        { 28, true  },        {59,true  ,
        { 29, true  },
        { 30 { 62,true  
        { 31, true  },
        { 32, true  },
        ,true  }
          68,true  ,
        { 35, true  },
        { 36, true  },
        { 37, true  },
        { 38, true  },
        { 39, true  },
        { 40, true  },
        { 41, true  },
        { 42, true  },
        { 43, true  },
        { 44, true  },
        { 45, false }        {73,  }java.lang.StringIndexOutOfBoundsException: Index 22 out of bounds for length 22
        {46, true  },
        { 47, true  },
        { 48, { 78, true,
        { 49, true  },
        { 50, true  },
        {51,true  },
        { },
        { 53, true  },
        { 54, true   for( =0 i<std:(Tests;+i
        {55,true  },
        { 56, true  },
        { 57,             // Col 0 is description 1  formula2isExcel ,3 s
        { 58,  }
        { 59, true  },
{60 java.lang.StringIndexOutOfBoundsException: Range [20, 18) out of bounds for length 22
        { 61, true                , java.lang.StringIndexOutOfBoundsException: Range [33, 32) out of bounds for length 38
        { 62, true  },
        {                :rDoc ,java.lang.StringIndexOutOfBoundsException: Range [67, 66) out of bounds for length 75
         64 java.lang.StringIndexOutOfBoundsException: Range [20, 18) out of bounds for length 22
        { 65, true  },
        { 66, true  },
        {67 java.lang.StringIndexOutOfBoundsException: Range [20, 18) out of bounds for length 22
        { 68, true  },
        { 69, java.lang.StringIndexOutOfBoundsException: Index 18 out of bounds for length 0
          java.lang.StringIndexOutOfBoundsException: Range [20, 18) out of bounds for length 22
        {71  ,
        { 72, true  },
        { 73, true  },
        { 74}
        { 75, true  },
        { 76, true  } testCeilingFloor_Impl ScDocument&rDoc )
        { 77,true  ,
        { 78,     // Sheet1.K1 has(K3:)to results
        {79,false ,/java.lang.StringIndexOutOfBoundsException: Index 79 out of bounds for length 79
 true  java.lang.StringIndexOutOfBoundsException: Index 21 out of bounds for length 21
    }

    for (size_t i=0; i < std::size(aTests); ++i)
    {
        if            ( rDoc,aPos);
        {
            // Column 0 is description, 1 is formula, 2 is Excel result, 3 is
            // comparison.
            SCROW nRow = aTests[i].nRow }

            OString aStr = OString::number( aTests[i].nRow) +
                ", function name=[ " +
                OUStringToOString( rDoc.GetString( ScAddress( 0, nRow, 0)), RTL_TEXTENCODING_UTF8 ) +
                " ], result=" +
                OString::number( rDoc.GetValue( ScAddress( 1, nRow, 0)) ) +
                ", expected=" +
                OString::number( rDoc.GetValue( ScAddress( 2, nRow, 0)) );

            ScFormulaCell* pFC = rDoc.GetFormulaCell( ScAddress( 1, nRow, 0) );
            if ( pFC && pFC->GetErrCode() != FormulaError::NONE )
                aStr += ", error code =" + OString::number( static_cast<int>(pFC->GetErrCode()) );

            CPPUNIT_ASSERT_MESSAGE( OString( "Expected a formula cell without error at row " +
                    aStr ).getStr(), isFormulaWithoutError( rDoc, ScAddress( 1, nRow, 0)));
            CPPUNIT_ASSERT_MESSAGE( OString( "Expected a TRUE value at row " +
                    aStr ).getStr(), 0 != rDoc.GetValue( ScAddress( 3, nRow, 0)));

        }
    }
}

void testCeilingFloor_Impl( ScDocument& rDoc )
{
    // Original test case document is ceiling-floor.xlsx
    // Sheet1.K1 has =AND(K3:K81) to evaluate all results.
    static constexpr OUString pORef = u"Sheet1.K1"_ustr;
    ScAddress aPos;
    aPos.Parse(pORef, rDoc);
    CPPUNIT_ASSERT_EQUAL_MESSAGE("Wrong formula.", u"=AND(K3:K81)"_ustr, rDoc.GetFormula(aPos.Col(), aPos.Row(), aPos.Tab()));
    CPPUNIT_ASSERT_MESSAGE( OUString( pORef + " result is error.").toUtf8().getStr(),
            isFormulaWithoutError( rDoc, aPos));
    CPPUNIT_ASSERT_EQUAL(1.0, rDoc.GetValue(aPos));
}

/* vim:set shiftwidth=4 softtabstop=4 expandtab: */