office-gobmx/sc/source/ui/docshell/editable.cxx
Balazs Varga 8391024604 tdf#160404 tdf#160535 tdf#160536 - sc improve sheet protection
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>
2024-11-14 23:53:24 +01:00

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: */