1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
|
/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
/*************************************************************************
*
* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
*
* Copyright IBM Corporation 2009, 2010.
* Copyright 2000, 2010 Oracle and/or its affiliates.
*
* OpenOffice.org - a multi-platform office productivity suite
*
* This file is part of OpenOffice.org.
*
* OpenOffice.org is free software: you can redistribute it and/or modify
* it under the terms of the GNU Lesser General Public License version 3
* only, as published by the Free Software Foundation.
*
* OpenOffice.org is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Lesser General Public License version 3 for more details
* (a copy is included in the LICENSE file that accompanied this code).
*
* You should have received a copy of the GNU Lesser General Public License
* version 3 along with OpenOffice.org. If not, see
* <http://www.openoffice.org/license.html>
* for a copy of the LGPLv3 License.
*
************************************************************************/
#include "vbaquerytable.hxx"
#include "document.hxx"
#include "docsh.hxx"
#include "sfx2/lnkbase.hxx"
#include "sfx2/linkmgr.hxx"
#include "arealink.hxx"
#include "vbarange.hxx"
using namespace com::sun::star;
ScVbaQueryTable::ScVbaQueryTable(const css::uno::Reference< ov::XHelperInterface >& /*xParent*/,
const css::uno::Reference< css::uno::XComponentContext > & /*xContext*/,
ScDocument *pDocument ,
ScVbaRange *pParent
)
//:QueryTable_Base(xParent, xContext)
{
m_pDocument = pDocument;
m_pParent = pParent;
}
ScVbaQueryTable::~ScVbaQueryTable()
{
}
::sal_Bool SAL_CALL
ScVbaQueryTable::Refresh( const ::com::sun::star::uno::Any& /*aBackgroundQuery*/ ) throw (::com::sun::star::uno::RuntimeException)
{
//Get parent Info
SCROW nRow = m_pParent->getRow();
SCCOL nClm = m_pParent->getColumn();
SCTAB nTab = m_pParent->getWorksheet()->getIndex() - 1; //The vba index begin from 1.
ScAddress crrRngAddr(nClm, nRow, nTab);
//Get link info
sfx2::LinkManager *pLinkMng = m_pDocument->GetLinkManager();
const ::sfx2::SvBaseLinks &rLinks = pLinkMng->GetLinks();
sal_uInt16 nCount = rLinks.Count();
for (sal_uInt16 i=0; i<nCount; i++)
{
::sfx2::SvBaseLink* pBase = *rLinks[i];
if (pBase->ISA(ScAreaLink))
{
ScAreaLink *pAreaLink = (ScAreaLink *)pBase;
const ScRange &destRange = pAreaLink->GetDestArea();
if (destRange.In(crrRngAddr))
{
pBase->Update();
}
}
}
return sal_True;
}
/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
|
