addressconverter.hxx

Go to the documentation of this file.

/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
/*
 * This file is part of the LibreOffice project.
 *
 * This Source Code Form is subject to the terms of the Mozilla Public
 * License, v. 2.0. If a copy of the MPL was not distributed with this
 * file, You can obtain one at http://mozilla.org/MPL/2.0/.
 *
 * This file incorporates work covered by the following license notice:
 *
 *   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 .
 */
 
#pragma once
 
#include <vector>
#include <rangelst.hxx>
#include "workbookhelper.hxx"
#include <com/sun/star/uno/Sequence.h>
 
namespace com::sun::star::table { struct CellRangeAddress; }
namespace oox { class SequenceInputStream; }
 
namespace oox {
namespace xls {
 
struct BinAddress
{
    sal_Int32           mnCol;
    sal_Int32           mnRow;
 
    explicit     BinAddress() : mnCol( 0 ), mnRow( 0 ) {}
    explicit     BinAddress( sal_Int32 nCol, sal_Int32 nRow ) : mnCol( nCol ), mnRow( nRow ) {}
    explicit     BinAddress( const ScAddress& rAddr ) : mnCol( rAddr.Col() ), mnRow( rAddr.Row() ) {}
 
    void                read( SequenceInputStream& rStrm );
};
 
inline bool operator<( const BinAddress& rL, const BinAddress& rR )
{
    return (rL.mnCol < rR.mnCol) || ((rL.mnCol == rR.mnCol) && (rL.mnRow < rR.mnRow));
}
 
inline SequenceInputStream& operator>>( SequenceInputStream& rStrm, BinAddress& orPos )
{
    orPos.read( rStrm );
    return rStrm;
}
 
struct BinRange
{
    BinAddress          maFirst;
    BinAddress          maLast;
 
    void                read( SequenceInputStream& rStrm );
};
 
inline SequenceInputStream& operator>>( SequenceInputStream& rStrm, BinRange& orRange )
{
    orRange.read( rStrm );
    return rStrm;
}
 
class BinRangeList
{
public:
    explicit     BinRangeList() : mvRanges() {}
 
    ::std::vector< BinRange >::const_iterator begin() const { return mvRanges.begin(); }
    ::std::vector< BinRange >::const_iterator end() const { return mvRanges.end(); }
 
    void                read( SequenceInputStream& rStrm );
 
private:
    ::std::vector< BinRange > mvRanges;
};
 
inline SequenceInputStream& operator>>( SequenceInputStream& rStrm, BinRangeList& orRanges )
{
    orRanges.read( rStrm );
    return rStrm;
}
 
class AddressConverter final : public WorkbookHelper
{
public:
    explicit            AddressConverter( const WorkbookHelper& rHelper );
 
    static bool         parseOoxAddress2d(
                            sal_Int32& ornColumn, sal_Int32& ornRow,
                            const OUString& rString,
                            sal_Int32 nStart = 0,
                            sal_Int32 nLength = SAL_MAX_INT32 );
 
    static bool parseOoxAddress2d(
        sal_Int32& ornColumn, sal_Int32& ornRow, std::string_view pStr );
 
    static bool         parseOoxRange2d(
                            sal_Int32& ornStartColumn, sal_Int32& ornStartRow,
                            sal_Int32& ornEndColumn, sal_Int32& ornEndRow,
                            const OUString& rString,
                            sal_Int32 nStart = 0 );
 
    const ScAddress&
                        getMaxApiAddress() const { return maMaxApiPos; }
 
    const ScAddress&
                        getMaxXlsAddress() const { return maMaxXlsPos; }
 
    const ScAddress&
                        getMaxAddress() const { return maMaxPos; }
 
    bool                checkCol( sal_Int32 nCol, bool bTrackOverflow );
 
    bool                checkRow( sal_Int32 nRow, bool bTrackOverflow );
 
    bool                checkTab( sal_Int16 nSheet, bool bTrackOverflow );
 
    bool                checkCellAddress(
                            const ScAddress& rAddress,
                            bool bTrackOverflow );
 
    static bool        convertToCellAddressUnchecked(
                            ScAddress& orAddress,
                            const OUString& rString,
                            sal_Int16 nSheet );
 
    static bool convertToCellAddressUnchecked(
        ScAddress& orAddress, std::string_view pStr, sal_Int16 nSheet );
 
    bool                convertToCellAddress(
                            ScAddress& orAddress,
                            const OUString& rString,
                            sal_Int16 nSheet,
                            bool bTrackOverflow );
 
    bool convertToCellAddress(
        ScAddress& rAddress,
        std::string_view pStr, sal_Int16 nSheet, bool bTrackOverflow );
 
    ScAddress           createValidCellAddress(
                            const OUString& rString,
                            sal_Int16 nSheet,
                            bool bTrackOverflow );
 
    static void        convertToCellAddressUnchecked(
                            ScAddress& orAddress,
                            const BinAddress& rBinAddress,
                            sal_Int16 nSheet );
 
    bool                convertToCellAddress(
                            ScAddress& orAddress,
                            const BinAddress& rBinAddress,
                            sal_Int16 nSheet,
                            bool bTrackOverflow );
 
    ScAddress           createValidCellAddress(
                            const BinAddress& rBinAddress,
                            sal_Int16 nSheet,
                            bool bTrackOverflow );
 
    bool                checkCellRange(
                            const ScRange& rRange,
                            bool bAllowOverflow, bool bTrackOverflow );
 
    bool                validateCellRange(
                            ScRange& orRange,
                            bool bAllowOverflow, bool bTrackOverflow );
 
    static bool         convertToCellRangeUnchecked(
                            ScRange& orRange,
                            const OUString& rString,
                            sal_Int16 nSheet );
 
    bool                convertToCellRange(
                            ScRange& orRange,
                            const OUString& rString,
                            sal_Int16 nSheet,
                            bool bAllowOverflow, bool bTrackOverflow );
 
    static void         convertToCellRangeUnchecked(
                            ScRange& orRange,
                            const BinRange& rBinRange,
                            sal_Int16 nSheet );
 
    bool                convertToCellRange(
                            ScRange& orRange,
                            const BinRange& rBinRange,
                            sal_Int16 nSheet,
                            bool bAllowOverflow, bool bTrackOverflow );
 
 
    void                validateCellRangeList(
                            ScRangeList& orRanges,
                            bool bTrackOverflow );
 
    void                convertToCellRangeList(
                            ScRangeList& orRanges,
                            const OUString& rString,
                            sal_Int16 nSheet,
                            bool bTrackOverflow );
 
    void                convertToCellRangeList(
                            ScRangeList& orRanges,
                            const BinRangeList& rBinRanges,
                            sal_Int16 nSheet,
                            bool bTrackOverflow );
 
    static css::uno::Sequence<css::table::CellRangeAddress>
                        toApiSequence(const ScRangeList& orRanges);
 
    bool                isColOverflow() const { return mbColOverflow; }
    bool                isRowOverflow() const { return mbRowOverflow; }
    bool                isTabOverflow() const { return mbTabOverflow; }
 
private:
    void                initializeMaxPos(
                            sal_Int16 nMaxXlsTab, sal_Int32 nMaxXlsCol, sal_Int32 nMaxXlsRow );
 
private:
    ScAddress maMaxApiPos;     
    ScAddress maMaxXlsPos;     
    ScAddress maMaxPos;        
    bool                    mbColOverflow;   
    bool                    mbRowOverflow;   
    bool                    mbTabOverflow;   
};
 
} // namespace xls
} // namespace oox
 
 
/* vim:set shiftwidth=4 softtabstop=4 expandtab: */