8391024604
tdf#160404: Fix FILEOPEN XLSX Pivot table is not imported if sheet protection has Pivot table editing enabled - Import correctly the pivot tables, even if the tab protection is not allowing to use them. tdf#160535: Support sheet protection option: Use AutoFilter - Add new option for tab protection to enable/disable to use autofilter on the sheet. Import/export correctly to odf/ooxml. Add new ext-odf attribute: XML_USE_AUTOFILTER tdf#160536: Support sheet protection option: Use PivotTable&PivotChart - Add new option for tab protection to enable/disable to use Pivot table on the sheet. Import/export correctly to odf/ooxml. Add new ext-odf attribute: XML_USE_PIVOT Change-Id: I5d34e3608aed1a3d004ec553f6125b6428e9c05e Reviewed-on: https://gerrit.libreoffice.org/c/core/+/176274 Tested-by: Jenkins Reviewed-by: Balazs Varga <balazs.varga.extern@allotropia.de>
187 lines
5.9 KiB
C++
187 lines
5.9 KiB
C++
/* -*- 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 .
|
|
*/
|
|
|
|
#include <editable.hxx>
|
|
#include <document.hxx>
|
|
#include <viewfunc.hxx>
|
|
#include <globstr.hrc>
|
|
|
|
ScEditableTester::ScEditableTester() :
|
|
mbIsEditable(true),
|
|
mbOnlyMatrix(true)
|
|
{
|
|
}
|
|
|
|
ScEditableTester::ScEditableTester( const ScDocument& rDoc, SCTAB nTab,
|
|
SCCOL nStartCol, SCROW nStartRow, SCCOL nEndCol, SCROW nEndRow, bool bNoMatrixAtAll ) :
|
|
mbIsEditable(true),
|
|
mbOnlyMatrix(true)
|
|
{
|
|
TestBlock( rDoc, nTab, nStartCol, nStartRow, nEndCol, nEndRow, bNoMatrixAtAll );
|
|
}
|
|
|
|
ScEditableTester::ScEditableTester( const ScDocument& rDoc,
|
|
SCCOL nStartCol, SCROW nStartRow, SCCOL nEndCol, SCROW nEndRow,
|
|
const ScMarkData& rMark ) :
|
|
mbIsEditable(true),
|
|
mbOnlyMatrix(true)
|
|
{
|
|
TestSelectedBlock( rDoc, nStartCol, nStartRow, nEndCol, nEndRow, rMark );
|
|
}
|
|
|
|
ScEditableTester::ScEditableTester( const ScDocument& rDoc, const ScRange& rRange, sc::EditAction eAction ) :
|
|
mbIsEditable(true),
|
|
mbOnlyMatrix(true)
|
|
{
|
|
if (eAction == sc::EditAction::Unknown)
|
|
TestRange(rDoc, rRange);
|
|
else
|
|
TestRangeForAction( rDoc, rRange, eAction );
|
|
}
|
|
|
|
ScEditableTester::ScEditableTester( const ScDocument& rDoc, const ScMarkData& rMark ) :
|
|
mbIsEditable(true),
|
|
mbOnlyMatrix(true)
|
|
{
|
|
TestSelection( rDoc, rMark );
|
|
}
|
|
|
|
ScEditableTester::ScEditableTester( ScViewFunc* pView ) :
|
|
mbIsEditable(true),
|
|
mbOnlyMatrix(true)
|
|
{
|
|
bool bThisMatrix;
|
|
if ( !pView->SelectionEditable( &bThisMatrix ) )
|
|
{
|
|
mbIsEditable = false;
|
|
if ( !bThisMatrix )
|
|
mbOnlyMatrix = false;
|
|
}
|
|
}
|
|
|
|
ScEditableTester::ScEditableTester(
|
|
const ScDocument& rDoc, sc::EditAction eAction, SCCOL nStartCol, SCROW nStartRow,
|
|
SCCOL nEndCol, SCROW nEndRow, const ScMarkData& rMark ) :
|
|
ScEditableTester()
|
|
{
|
|
TestBlockForAction(rDoc, eAction, nStartCol, nStartRow, nEndCol, nEndRow, rMark);
|
|
}
|
|
|
|
void ScEditableTester::TestBlock( const ScDocument& rDoc, SCTAB nTab,
|
|
SCCOL nStartCol, SCROW nStartRow, SCCOL nEndCol, SCROW nEndRow, bool bNoMatrixAtAll )
|
|
{
|
|
if (mbIsEditable || mbOnlyMatrix)
|
|
{
|
|
bool bThisMatrix;
|
|
if (!rDoc.IsBlockEditable( nTab, nStartCol, nStartRow, nEndCol, nEndRow, &bThisMatrix, bNoMatrixAtAll ))
|
|
{
|
|
mbIsEditable = false;
|
|
if ( !bThisMatrix )
|
|
mbOnlyMatrix = false;
|
|
}
|
|
}
|
|
}
|
|
|
|
void ScEditableTester::TestBlockForAction( const ScDocument& rDoc, SCTAB nTab,
|
|
SCCOL nStartCol, SCROW nStartRow, SCCOL nEndCol, SCROW nEndRow, sc::EditAction eAction )
|
|
{
|
|
if (mbIsEditable || mbOnlyMatrix)
|
|
{
|
|
mbIsEditable = rDoc.IsEditActionAllowed(eAction, nTab, nStartCol, nStartRow, nEndCol, nEndRow);
|
|
}
|
|
}
|
|
|
|
void ScEditableTester::TestSelectedBlock( const ScDocument& rDoc,
|
|
SCCOL nStartCol, SCROW nStartRow, SCCOL nEndCol, SCROW nEndRow,
|
|
const ScMarkData& rMark )
|
|
{
|
|
SCTAB nTabCount = rDoc.GetTableCount();
|
|
for (const auto& rTab : rMark)
|
|
{
|
|
if (rTab >= nTabCount)
|
|
break;
|
|
|
|
TestBlock( rDoc, rTab, nStartCol, nStartRow, nEndCol, nEndRow, false );
|
|
}
|
|
}
|
|
|
|
void ScEditableTester::TestRange( const ScDocument& rDoc, const ScRange& rRange )
|
|
{
|
|
SCCOL nStartCol = rRange.aStart.Col();
|
|
SCROW nStartRow = rRange.aStart.Row();
|
|
SCTAB nStartTab = rRange.aStart.Tab();
|
|
SCCOL nEndCol = rRange.aEnd.Col();
|
|
SCROW nEndRow = rRange.aEnd.Row();
|
|
SCTAB nEndTab = rRange.aEnd.Tab();
|
|
for (SCTAB nTab=nStartTab; nTab<=nEndTab; nTab++)
|
|
TestBlock( rDoc, nTab, nStartCol, nStartRow, nEndCol, nEndRow, false );
|
|
}
|
|
|
|
void ScEditableTester::TestRangeForAction(const ScDocument& rDoc, const ScRange& rRange, sc::EditAction eAction)
|
|
{
|
|
SCCOL nStartCol = rRange.aStart.Col();
|
|
SCROW nStartRow = rRange.aStart.Row();
|
|
SCTAB nStartTab = rRange.aStart.Tab();
|
|
SCCOL nEndCol = rRange.aEnd.Col();
|
|
SCROW nEndRow = rRange.aEnd.Row();
|
|
SCTAB nEndTab = rRange.aEnd.Tab();
|
|
for (SCTAB nTab = nStartTab; nTab <= nEndTab; nTab++)
|
|
TestBlockForAction(rDoc, nTab, nStartCol, nStartRow, nEndCol, nEndRow, eAction);
|
|
}
|
|
|
|
void ScEditableTester::TestSelection( const ScDocument& rDoc, const ScMarkData& rMark )
|
|
{
|
|
if (mbIsEditable || mbOnlyMatrix)
|
|
{
|
|
bool bThisMatrix;
|
|
if ( !rDoc.IsSelectionEditable( rMark, &bThisMatrix ) )
|
|
{
|
|
mbIsEditable = false;
|
|
if ( !bThisMatrix )
|
|
mbOnlyMatrix = false;
|
|
}
|
|
}
|
|
}
|
|
|
|
void ScEditableTester::TestBlockForAction(
|
|
const ScDocument& rDoc, sc::EditAction eAction, SCCOL nStartCol, SCROW nStartRow,
|
|
SCCOL nEndCol, SCROW nEndRow, const ScMarkData& rMark )
|
|
{
|
|
mbOnlyMatrix = false;
|
|
|
|
for (const auto& rTab : rMark)
|
|
{
|
|
if (!mbIsEditable)
|
|
return;
|
|
|
|
mbIsEditable = rDoc.IsEditActionAllowed(eAction, rTab, nStartCol, nStartRow, nEndCol, nEndRow);
|
|
}
|
|
}
|
|
|
|
TranslateId ScEditableTester::GetMessageId() const
|
|
{
|
|
if (mbIsEditable)
|
|
return {};
|
|
else if (mbOnlyMatrix)
|
|
return STR_MATRIXFRAGMENTERR;
|
|
else
|
|
return STR_PROTECTIONERR;
|
|
}
|
|
|
|
/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
|