| /************************************************************** |
| * |
| * 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 "refdata.hxx" |
| |
| |
| void ScSingleRefData::CalcRelFromAbs( const ScAddress& rPos ) |
| { |
| nRelCol = nCol - rPos.Col(); |
| nRelRow = nRow - rPos.Row(); |
| nRelTab = nTab - rPos.Tab(); |
| } |
| |
| |
| void ScSingleRefData::SmartRelAbs( const ScAddress& rPos ) |
| { |
| if ( Flags.bColRel ) |
| nCol = nRelCol + rPos.Col(); |
| else |
| nRelCol = nCol - rPos.Col(); |
| |
| if ( Flags.bRowRel ) |
| nRow = nRelRow + rPos.Row(); |
| else |
| nRelRow = nRow - rPos.Row(); |
| |
| if ( Flags.bTabRel ) |
| nTab = nRelTab + rPos.Tab(); |
| else |
| nRelTab = nTab - rPos.Tab(); |
| } |
| |
| |
| void ScSingleRefData::CalcAbsIfRel( const ScAddress& rPos ) |
| { |
| if ( Flags.bColRel ) |
| { |
| nCol = nRelCol + rPos.Col(); |
| if ( !VALIDCOL( nCol ) ) |
| Flags.bColDeleted = sal_True; |
| } |
| if ( Flags.bRowRel ) |
| { |
| nRow = nRelRow + rPos.Row(); |
| if ( !VALIDROW( nRow ) ) |
| Flags.bRowDeleted = sal_True; |
| } |
| if ( Flags.bTabRel ) |
| { |
| nTab = nRelTab + rPos.Tab(); |
| if ( !VALIDTAB( nTab ) ) |
| Flags.bTabDeleted = sal_True; |
| } |
| } |
| |
| //UNUSED2008-05 void ScSingleRefData::OldBoolsToNewFlags( const OldSingleRefBools& rBools ) |
| //UNUSED2008-05 { |
| //UNUSED2008-05 switch ( rBools.bRelCol ) |
| //UNUSED2008-05 { |
| //UNUSED2008-05 case SR_DELETED : |
| //UNUSED2008-05 Flags.bColRel = sal_True; // der war verlorengegangen |
| //UNUSED2008-05 Flags.bColDeleted = sal_True; |
| //UNUSED2008-05 break; |
| //UNUSED2008-05 case SR_ABSOLUTE : |
| //UNUSED2008-05 Flags.bColRel = sal_False; |
| //UNUSED2008-05 Flags.bColDeleted = sal_False; |
| //UNUSED2008-05 break; |
| //UNUSED2008-05 case SR_RELABS : |
| //UNUSED2008-05 case SR_RELATIVE : |
| //UNUSED2008-05 default: |
| //UNUSED2008-05 Flags.bColRel = sal_True; |
| //UNUSED2008-05 Flags.bColDeleted = sal_False; |
| //UNUSED2008-05 } |
| //UNUSED2008-05 switch ( rBools.bRelRow ) |
| //UNUSED2008-05 { |
| //UNUSED2008-05 case SR_DELETED : |
| //UNUSED2008-05 Flags.bRowRel = sal_True; // der war verlorengegangen |
| //UNUSED2008-05 Flags.bRowDeleted = sal_True; |
| //UNUSED2008-05 break; |
| //UNUSED2008-05 case SR_ABSOLUTE : |
| //UNUSED2008-05 Flags.bRowRel = sal_False; |
| //UNUSED2008-05 Flags.bRowDeleted = sal_False; |
| //UNUSED2008-05 break; |
| //UNUSED2008-05 case SR_RELABS : |
| //UNUSED2008-05 case SR_RELATIVE : |
| //UNUSED2008-05 default: |
| //UNUSED2008-05 Flags.bRowRel = sal_True; |
| //UNUSED2008-05 Flags.bRowDeleted = sal_False; |
| //UNUSED2008-05 } |
| //UNUSED2008-05 switch ( rBools.bRelTab ) |
| //UNUSED2008-05 { |
| //UNUSED2008-05 case SR_DELETED : |
| //UNUSED2008-05 Flags.bTabRel = sal_True; // der war verlorengegangen |
| //UNUSED2008-05 Flags.bTabDeleted = sal_True; |
| //UNUSED2008-05 break; |
| //UNUSED2008-05 case SR_ABSOLUTE : |
| //UNUSED2008-05 Flags.bTabRel = sal_False; |
| //UNUSED2008-05 Flags.bTabDeleted = sal_False; |
| //UNUSED2008-05 break; |
| //UNUSED2008-05 case SR_RELABS : |
| //UNUSED2008-05 case SR_RELATIVE : |
| //UNUSED2008-05 default: |
| //UNUSED2008-05 Flags.bTabRel = sal_True; |
| //UNUSED2008-05 Flags.bTabDeleted = sal_False; |
| //UNUSED2008-05 } |
| //UNUSED2008-05 Flags.bFlag3D = (rBools.bOldFlag3D & SRF_3D ? sal_True : sal_False); |
| //UNUSED2008-05 Flags.bRelName = (rBools.bOldFlag3D & SRF_RELNAME ? sal_True : sal_False); |
| //UNUSED2008-05 if ( !Flags.bFlag3D ) |
| //UNUSED2008-05 Flags.bTabRel = sal_True; // ist bei einigen aelteren Dokumenten nicht gesetzt |
| //UNUSED2008-05 } |
| //UNUSED2008-05 |
| //UNUSED2008-05 |
| //UNUSED2008-05 /* |
| //UNUSED2008-05 bis Release 3.1 sah Store so aus |
| //UNUSED2008-05 |
| //UNUSED2008-05 sal_uInt8 n = ( ( r.bOldFlag3D & 0x03 ) << 6 ) // RelName, 3D |
| //UNUSED2008-05 | ( ( r.bRelTab & 0x03 ) << 4 ) // Relative, RelAbs |
| //UNUSED2008-05 | ( ( r.bRelRow & 0x03 ) << 2 ) |
| //UNUSED2008-05 | ( r.bRelCol & 0x03 ); |
| //UNUSED2008-05 |
| //UNUSED2008-05 bis Release 3.1 sah Load so aus |
| //UNUSED2008-05 |
| //UNUSED2008-05 r.bRelCol = ( n & 0x03 ); |
| //UNUSED2008-05 r.bRelRow = ( ( n >> 2 ) & 0x03 ); |
| //UNUSED2008-05 r.bRelTab = ( ( n >> 4 ) & 0x03 ); |
| //UNUSED2008-05 r.bOldFlag3D = ( ( n >> 6 ) & 0x03 ); |
| //UNUSED2008-05 |
| //UNUSED2008-05 bRelCol == SR_DELETED war identisch mit bRelCol == (SR_RELATIVE | SR_RELABS) |
| //UNUSED2008-05 leider.. |
| //UNUSED2008-05 3.1 liest Zukunft: Deleted wird nicht unbedingt erkannt, nur wenn auch Relativ. |
| //UNUSED2008-05 Aber immer noch nCol > MAXCOL und gut sollte sein.. |
| //UNUSED2008-05 */ |
| //UNUSED2008-05 |
| //UNUSED2008-05 sal_uInt8 ScSingleRefData::CreateStoreByteFromFlags() const |
| //UNUSED2008-05 { |
| //UNUSED2008-05 return (sal_uInt8)( |
| //UNUSED2008-05 ( (Flags.bRelName & 0x01) << 7 ) |
| //UNUSED2008-05 | ( (Flags.bFlag3D & 0x01) << 6 ) |
| //UNUSED2008-05 | ( (Flags.bTabDeleted & 0x01) << 5 ) |
| //UNUSED2008-05 | ( (Flags.bTabRel & 0x01) << 4 ) |
| //UNUSED2008-05 | ( (Flags.bRowDeleted & 0x01) << 3 ) |
| //UNUSED2008-05 | ( (Flags.bRowRel & 0x01) << 2 ) |
| //UNUSED2008-05 | ( (Flags.bColDeleted & 0x01) << 1 ) |
| //UNUSED2008-05 | (Flags.bColRel & 0x01) |
| //UNUSED2008-05 ); |
| //UNUSED2008-05 } |
| //UNUSED2008-05 |
| //UNUSED2008-05 |
| //UNUSED2008-05 void ScSingleRefData::CreateFlagsFromLoadByte( sal_uInt8 n ) |
| //UNUSED2008-05 { |
| //UNUSED2008-05 Flags.bColRel = (n & 0x01 ); |
| //UNUSED2008-05 Flags.bColDeleted = ( (n >> 1) & 0x01 ); |
| //UNUSED2008-05 Flags.bRowRel = ( (n >> 2) & 0x01 ); |
| //UNUSED2008-05 Flags.bRowDeleted = ( (n >> 3) & 0x01 ); |
| //UNUSED2008-05 Flags.bTabRel = ( (n >> 4) & 0x01 ); |
| //UNUSED2008-05 Flags.bTabDeleted = ( (n >> 5) & 0x01 ); |
| //UNUSED2008-05 Flags.bFlag3D = ( (n >> 6) & 0x01 ); |
| //UNUSED2008-05 Flags.bRelName = ( (n >> 7) & 0x01 ); |
| //UNUSED2008-05 } |
| |
| |
| sal_Bool ScSingleRefData::operator==( const ScSingleRefData& r ) const |
| { |
| return bFlags == r.bFlags && |
| (Flags.bColRel ? nRelCol == r.nRelCol : nCol == r.nCol) && |
| (Flags.bRowRel ? nRelRow == r.nRelRow : nRow == r.nRow) && |
| (Flags.bTabRel ? nRelTab == r.nRelTab : nTab == r.nTab); |
| } |
| |
| bool ScSingleRefData::operator!=( const ScSingleRefData& r ) const |
| { |
| return !operator==(r); |
| } |
| |
| static void lcl_putInOrder( ScSingleRefData & rRef1, ScSingleRefData & rRef2 ) |
| { |
| SCCOL nCol1, nCol2; |
| SCROW nRow1, nRow2; |
| SCTAB nTab1, nTab2; |
| sal_Bool bTmp; |
| sal_uInt8 nRelState1, nRelState2; |
| if ( rRef1.Flags.bRelName ) |
| nRelState1 = |
| ((rRef1.Flags.bTabRel & 0x01) << 2) |
| | ((rRef1.Flags.bRowRel & 0x01) << 1) |
| | ((rRef1.Flags.bColRel & 0x01)); |
| else |
| nRelState1 = 0; |
| if ( rRef2.Flags.bRelName ) |
| nRelState2 = |
| ((rRef2.Flags.bTabRel & 0x01) << 2) |
| | ((rRef2.Flags.bRowRel & 0x01) << 1) |
| | ((rRef2.Flags.bColRel & 0x01)); |
| else |
| nRelState2 = 0; |
| if ( (nCol1 = rRef1.nCol) > (nCol2 = rRef2.nCol) ) |
| { |
| rRef1.nCol = nCol2; |
| rRef2.nCol = nCol1; |
| nCol1 = rRef1.nRelCol; |
| rRef1.nRelCol = rRef2.nRelCol; |
| rRef2.nRelCol = nCol1; |
| if ( rRef1.Flags.bRelName && rRef1.Flags.bColRel ) |
| nRelState2 |= 1; |
| else |
| nRelState2 &= ~1; |
| if ( rRef2.Flags.bRelName && rRef2.Flags.bColRel ) |
| nRelState1 |= 1; |
| else |
| nRelState1 &= ~1; |
| bTmp = rRef1.Flags.bColRel; |
| rRef1.Flags.bColRel = rRef2.Flags.bColRel; |
| rRef2.Flags.bColRel = bTmp; |
| bTmp = rRef1.Flags.bColDeleted; |
| rRef1.Flags.bColDeleted = rRef2.Flags.bColDeleted; |
| rRef2.Flags.bColDeleted = bTmp; |
| } |
| if ( (nRow1 = rRef1.nRow) > (nRow2 = rRef2.nRow) ) |
| { |
| rRef1.nRow = nRow2; |
| rRef2.nRow = nRow1; |
| nRow1 = rRef1.nRelRow; |
| rRef1.nRelRow = rRef2.nRelRow; |
| rRef2.nRelRow = nRow1; |
| if ( rRef1.Flags.bRelName && rRef1.Flags.bRowRel ) |
| nRelState2 |= 2; |
| else |
| nRelState2 &= ~2; |
| if ( rRef2.Flags.bRelName && rRef2.Flags.bRowRel ) |
| nRelState1 |= 2; |
| else |
| nRelState1 &= ~2; |
| bTmp = rRef1.Flags.bRowRel; |
| rRef1.Flags.bRowRel = rRef2.Flags.bRowRel; |
| rRef2.Flags.bRowRel = bTmp; |
| bTmp = rRef1.Flags.bRowDeleted; |
| rRef1.Flags.bRowDeleted = rRef2.Flags.bRowDeleted; |
| rRef2.Flags.bRowDeleted = bTmp; |
| } |
| if ( (nTab1 = rRef1.nTab) > (nTab2 = rRef2.nTab) ) |
| { |
| rRef1.nTab = nTab2; |
| rRef2.nTab = nTab1; |
| nTab1 = rRef1.nRelTab; |
| rRef1.nRelTab = rRef2.nRelTab; |
| rRef2.nRelTab = nTab1; |
| if ( rRef1.Flags.bRelName && rRef1.Flags.bTabRel ) |
| nRelState2 |= 4; |
| else |
| nRelState2 &= ~4; |
| if ( rRef2.Flags.bRelName && rRef2.Flags.bTabRel ) |
| nRelState1 |= 4; |
| else |
| nRelState1 &= ~4; |
| bTmp = rRef1.Flags.bTabRel; |
| rRef1.Flags.bTabRel = rRef2.Flags.bTabRel; |
| rRef2.Flags.bTabRel = bTmp; |
| bTmp = rRef1.Flags.bTabDeleted; |
| rRef1.Flags.bTabDeleted = rRef2.Flags.bTabDeleted; |
| rRef2.Flags.bTabDeleted = bTmp; |
| } |
| rRef1.Flags.bRelName = ( nRelState1 ? sal_True : sal_False ); |
| rRef2.Flags.bRelName = ( nRelState2 ? sal_True : sal_False ); |
| } |
| |
| |
| void ScComplexRefData::PutInOrder() |
| { |
| lcl_putInOrder( Ref1, Ref2); |
| } |
| |
| |
| static void lcl_adjustInOrder( ScSingleRefData & rRef1, ScSingleRefData & rRef2, bool bFirstLeader ) |
| { |
| // a1:a2:a3, bFirstLeader: rRef1==a1==r1, rRef2==a3==r2 |
| // else: rRef1==a3==r2, rRef2==a2==r1 |
| ScSingleRefData& r1 = (bFirstLeader ? rRef1 : rRef2); |
| ScSingleRefData& r2 = (bFirstLeader ? rRef2 : rRef1); |
| if (r1.Flags.bFlag3D && !r2.Flags.bFlag3D) |
| { |
| // [$]Sheet1.A5:A6 on Sheet2 do still refer only Sheet1. |
| r2.nTab = r1.nTab; |
| r2.nRelTab = r1.nRelTab; |
| r2.Flags.bTabRel = r1.Flags.bTabRel; |
| } |
| lcl_putInOrder( rRef1, rRef2); |
| } |
| |
| |
| ScComplexRefData& ScComplexRefData::Extend( const ScSingleRefData & rRef, const ScAddress & rPos ) |
| { |
| CalcAbsIfRel( rPos); |
| ScSingleRefData aRef = rRef; |
| aRef.CalcAbsIfRel( rPos); |
| bool bInherit3D = Ref1.IsFlag3D() && !Ref2.IsFlag3D(); |
| bool bInherit3Dtemp = bInherit3D && !rRef.IsFlag3D(); |
| if (aRef.nCol < Ref1.nCol || aRef.nRow < Ref1.nRow || aRef.nTab < Ref1.nTab) |
| { |
| lcl_adjustInOrder( Ref1, aRef, true); |
| aRef = rRef; |
| aRef.CalcAbsIfRel( rPos); |
| } |
| if (aRef.nCol > Ref2.nCol || aRef.nRow > Ref2.nRow || aRef.nTab > Ref2.nTab) |
| { |
| if (bInherit3D) |
| Ref2.SetFlag3D( true); |
| lcl_adjustInOrder( aRef, Ref2, false); |
| if (bInherit3Dtemp) |
| Ref2.SetFlag3D( false); |
| aRef = rRef; |
| aRef.CalcAbsIfRel( rPos); |
| } |
| // In Ref2 use absolute/relative addressing from non-extended parts if |
| // equal and therefor not adjusted. |
| // A$5:A5 => A$5:A$5:A5 => A$5:A5, and not A$5:A$5 |
| // A$6:$A5 => A$6:A$6:$A5 => A5:$A$6 |
| if (Ref2.nCol == aRef.nCol) |
| Ref2.SetColRel( aRef.IsColRel()); |
| if (Ref2.nRow == aRef.nRow) |
| Ref2.SetRowRel( aRef.IsRowRel()); |
| // $Sheet1.$A$5:$A$6 => $Sheet1.$A$5:$A$5:$A$6 => $Sheet1.$A$5:$A$6, and |
| // not $Sheet1.$A$5:Sheet1.$A$6 (with invisible second 3D, but relative). |
| if (Ref2.nTab == aRef.nTab) |
| Ref2.SetTabRel( bInherit3Dtemp ? Ref1.IsTabRel() : aRef.IsTabRel()); |
| Ref2.CalcRelFromAbs( rPos); |
| // Force 3D if necessary. References to other sheets always. |
| if (Ref1.nTab != rPos.Tab()) |
| Ref1.SetFlag3D( true); |
| // In the second part only if different sheet thus not inherited. |
| if (Ref2.nTab != Ref1.nTab) |
| Ref2.SetFlag3D( true); |
| // Merge Flag3D to Ref2 in case there was nothing to inherit and/or range |
| // wasn't extended as in A5:A5:Sheet1.A5 if on Sheet1. |
| if (rRef.IsFlag3D()) |
| Ref2.SetFlag3D( true); |
| return *this; |
| } |
| |
| |
| ScComplexRefData& ScComplexRefData::Extend( const ScComplexRefData & rRef, const ScAddress & rPos ) |
| { |
| return Extend( rRef.Ref1, rPos).Extend( rRef.Ref2, rPos); |
| } |
