LibreOffice Module sw (master)  1
dbinsdlg.cxx
Go to the documentation of this file.
1 /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
2 /*
3  * This file is part of the LibreOffice project.
4  *
5  * This Source Code Form is subject to the terms of the Mozilla Public
6  * License, v. 2.0. If a copy of the MPL was not distributed with this
7  * file, You can obtain one at http://mozilla.org/MPL/2.0/.
8  *
9  * This file incorporates work covered by the following license notice:
10  *
11  * Licensed to the Apache Software Foundation (ASF) under one or more
12  * contributor license agreements. See the NOTICE file distributed
13  * with this work for additional information regarding copyright
14  * ownership. The ASF licenses this file to you under the Apache
15  * License, Version 2.0 (the "License"); you may not use this file
16  * except in compliance with the License. You may obtain a copy of
17  * the License at http://www.apache.org/licenses/LICENSE-2.0 .
18  */
19 
20 #include <dbinsdlg.hxx>
21 
22 #include <float.h>
23 
24 #include <hintids.hxx>
25 #include <com/sun/star/lang/XMultiServiceFactory.hpp>
26 #include <com/sun/star/container/XNameAccess.hpp>
27 #include <com/sun/star/sdbc/XDataSource.hpp>
28 #include <com/sun/star/sdbc/XRow.hpp>
29 #include <com/sun/star/sdbcx/XTablesSupplier.hpp>
30 #include <com/sun/star/sdbcx/XColumnsSupplier.hpp>
31 #include <com/sun/star/sdbcx/XRowLocate.hpp>
32 #include <com/sun/star/sdb/XQueriesSupplier.hpp>
33 #include <com/sun/star/sdb/CommandType.hpp>
34 #include <com/sun/star/sdb/XColumn.hpp>
35 #include <com/sun/star/sdb/XDatabaseAccess.hpp>
36 #include <com/sun/star/sdbc/DataType.hpp>
37 #include <com/sun/star/sdbc/ResultSetType.hpp>
38 #include <com/sun/star/beans/XPropertySet.hpp>
39 #include <com/sun/star/util/NumberFormatter.hpp>
40 #include <com/sun/star/util/XNumberFormatTypes.hpp>
41 #include <com/sun/star/sdbc/XRowSet.hpp>
42 #include <comphelper/processfactory.hxx>
43 #include <comphelper/sequence.hxx>
44 #include <comphelper/types.hxx>
45 #include <sal/log.hxx>
46 #include <editeng/langitem.hxx>
47 #include <svl/numuno.hxx>
48 #include <svl/stritem.hxx>
49 #include <tools/diagnose_ex.h>
50 #include <vcl/svapp.hxx>
51 #include <vcl/mnemonic.hxx>
52 #include <svl/style.hxx>
53 #include <svl/zformat.hxx>
54 #include <sfx2/htmlmode.hxx>
55 #include <editeng/unolingu.hxx>
56 #include <sfx2/app.hxx>
57 #include <svl/itemset.hxx>
58 #include <editeng/brushitem.hxx>
59 #include <editeng/boxitem.hxx>
60 #include <svx/rulritem.hxx>
61 #include <svx/svxids.hrc>
62 #include <unotools/collatorwrapper.hxx>
63 #include <tabledlg.hxx>
64 #include <fmtclds.hxx>
65 #include <tabcol.hxx>
66 #include <uiitems.hxx>
67 #include <viewopt.hxx>
68 #include <uitool.hxx>
69 #include <wrtsh.hxx>
70 #include <wview.hxx>
71 #include <docsh.hxx>
72 #include <dbmgr.hxx>
73 #include <tblafmt.hxx>
74 #include <cellatr.hxx>
75 #include <swtable.hxx>
76 #include <swtablerep.hxx>
77 #include <dbfld.hxx>
78 #include <fmtcol.hxx>
79 #include <section.hxx>
80 #include <swwait.hxx>
81 #include <modcfg.hxx>
82 #include <swmodule.hxx>
83 #include <poolfmt.hxx>
84 #include <connectivity/dbtools.hxx>
85 
86 #include <dbui.hrc>
87 
88 #include <cmdid.h>
89 #include <SwStyleNameMapper.hxx>
90 #include <tabsh.hxx>
91 #include <swabstdlg.hxx>
92 #include <strings.hrc>
93 #include <unomid.h>
94 #include <IDocumentMarkAccess.hxx>
95 
96 #include <o3tl/any.hxx>
97 
98 #include <memory>
99 #include <swuiexp.hxx>
100 
101 using namespace ::dbtools;
102 using namespace ::com::sun::star;
103 using namespace ::com::sun::star::beans;
104 using namespace ::com::sun::star::container;
105 using namespace ::com::sun::star::lang;
106 using namespace ::com::sun::star::sdb;
107 using namespace ::com::sun::star::sdbc;
108 using namespace ::com::sun::star::sdbcx;
109 using namespace ::com::sun::star::uno;
110 
111 const char cDBFieldStart = '<';
112 const char cDBFieldEnd = '>';
113 
114 // Helper structure for adding database rows as fields or text
115 struct DB_Column
116 {
117  const enum class Type { FILLTEXT, COL_FIELD, COL_TEXT, SPLITPARA } eColType;
118 
119  union {
120  OUString* const pText;
121  SwField* pField;
122  sal_uInt32 const nFormat;
123  };
124  const SwInsDBColumn* pColInfo;
125 
126  DB_Column() : eColType(Type::SPLITPARA),
127  pText(nullptr),
128  pColInfo(nullptr)
129  {}
130 
131  explicit DB_Column( const OUString& rText )
132  : eColType(Type::FILLTEXT),
133  pText(new OUString(rText)),
134  pColInfo(nullptr)
135  {}
136 
137  DB_Column( const SwInsDBColumn& rInfo, sal_uInt32 nFormat_ )
138  : eColType(Type::COL_TEXT),
139  nFormat(nFormat_),
140  pColInfo(&rInfo)
141  {}
142 
143  DB_Column( const SwInsDBColumn& rInfo, SwDBField& rField )
144  : eColType(Type::COL_FIELD),
145  pField(&rField),
146  pColInfo(&rInfo)
147  {}
148 
149  ~DB_Column()
150  {
151  if( Type::COL_FIELD == eColType )
152  delete pField;
153  else if( Type::FILLTEXT == eColType )
154  delete pText;
155  }
156 };
157 
158 struct DB_ColumnConfigData
159 {
160  SwInsDBColumns aDBColumns;
161  OUString sEdit;
162  OUString sTableList;
163  OUString sTmplNm;
164  OUString sTAutoFormatNm;
165  bool bIsTable : 1,
166  bIsField : 1,
167  bIsHeadlineOn : 1,
168  bIsEmptyHeadln : 1;
169 
170  DB_ColumnConfigData(DB_ColumnConfigData const&) = delete;
171  DB_ColumnConfigData& operator=(DB_ColumnConfigData const&) = delete;
172 
173  DB_ColumnConfigData()
174  {
175  bIsTable = bIsHeadlineOn = true;
176  bIsField = bIsEmptyHeadln = false;
177  }
178 };
179 
180 bool SwInsDBColumn::operator<( const SwInsDBColumn& rCmp ) const
181 {
182  return 0 > GetAppCollator().compareString( sColumn, rCmp.sColumn );
183 }
184 
185 SwInsertDBColAutoPilot::SwInsertDBColAutoPilot( SwView& rView,
186  Reference<XDataSource> const & xDataSource,
187  Reference<sdbcx::XColumnsSupplier> const & xColSupp,
188  const SwDBData& rData )
189  : SfxDialogController(rView.GetWindow()->GetFrameWeld(), "modules/swriter/ui/insertdbcolumnsdialog.ui", "InsertDbColumnsDialog")
190  , ConfigItem("Office.Writer/InsertData/DataSet", ConfigItemMode::NONE)
191  , aDBData(rData)
192  , sNoTmpl(SwResId(SW_STR_NONE))
193  , pView(&rView)
194  , m_xRbAsTable(m_xBuilder->weld_radio_button("astable"))
195  , m_xRbAsField(m_xBuilder->weld_radio_button("asfields"))
196  , m_xRbAsText(m_xBuilder->weld_radio_button("astext"))
197  , m_xHeadFrame(m_xBuilder->weld_frame("dbframe"))
198  , m_xLbTableDbColumn(m_xBuilder->weld_tree_view("tabledbcols"))
199  , m_xLbTextDbColumn(m_xBuilder->weld_tree_view("tabletxtcols"))
200  , m_xFormatFrame(m_xBuilder->weld_frame("formatframe"))
201  , m_xRbDbFormatFromDb(m_xBuilder->weld_radio_button("fromdatabase"))
202  , m_xRbDbFormatFromUsr(m_xBuilder->weld_radio_button("userdefined"))
203  , m_xLbDbFormatFromUsr(new NumFormatListBox(m_xBuilder->weld_combo_box("numformat")))
204  , m_xIbDbcolToEdit(m_xBuilder->weld_button("toedit"))
205  , m_xEdDbText(m_xBuilder->weld_text_view("textview"))
206  , m_xFtDbParaColl(m_xBuilder->weld_label("parastylelabel"))
207  , m_xLbDbParaColl(m_xBuilder->weld_combo_box("parastyle"))
208  , m_xIbDbcolAllTo(m_xBuilder->weld_button("oneright"))
209  , m_xIbDbcolOneTo(m_xBuilder->weld_button("allright"))
210  , m_xIbDbcolOneFrom(m_xBuilder->weld_button("oneleft"))
211  , m_xIbDbcolAllFrom(m_xBuilder->weld_button("allleft"))
212  , m_xFtTableCol(m_xBuilder->weld_label("tablecolft"))
213  , m_xLbTableCol(m_xBuilder->weld_tree_view("tablecols"))
214  , m_xCbTableHeadon(m_xBuilder->weld_check_button("tableheading"))
215  , m_xRbHeadlColnms(m_xBuilder->weld_radio_button("columnname"))
216  , m_xRbHeadlEmpty(m_xBuilder->weld_radio_button("rowonly"))
217  , m_xPbTableFormat(m_xBuilder->weld_button("tableformat"))
218  , m_xPbTableAutofmt(m_xBuilder->weld_button("autoformat"))
219 {
220  m_xEdDbText->set_size_request(m_xEdDbText->get_approximate_digit_width() * 40, -1);
221  m_xLbDbParaColl->make_sorted();
222 
223  nGBFormatLen = m_xFormatFrame->get_label().getLength();
224 
225  if (xColSupp.is())
226  {
227  SwWrtShell& rSh = pView->GetWrtShell();
228  SvNumberFormatter* pNumFormatr = rSh.GetNumberFormatter();
229  SvNumberFormatsSupplierObj* pNumFormat = new SvNumberFormatsSupplierObj( pNumFormatr );
230  Reference< util::XNumberFormatsSupplier > xDocNumFormatsSupplier = pNumFormat;
231  Reference< util::XNumberFormats > xDocNumberFormats = xDocNumFormatsSupplier->getNumberFormats();
232  Reference< util::XNumberFormatTypes > xDocNumberFormatTypes(xDocNumberFormats, UNO_QUERY);
233 
234  Reference<XPropertySet> xSourceProps(xDataSource, UNO_QUERY);
235  Reference< util::XNumberFormats > xNumberFormats;
236  if(xSourceProps.is())
237  {
238  Any aFormats = xSourceProps->getPropertyValue("NumberFormatsSupplier");
239  if(aFormats.hasValue())
240  {
241  Reference< util::XNumberFormatsSupplier> xSuppl;
242  aFormats >>= xSuppl;
243  if(xSuppl.is())
244  {
245  xNumberFormats = xSuppl->getNumberFormats( );
246  }
247  }
248  }
249  Reference <XNameAccess> xCols = xColSupp->getColumns();
250  const Sequence<OUString> aColNames = xCols->getElementNames();
251  for (const OUString& rColName : aColNames)
252  {
253  std::unique_ptr<SwInsDBColumn> pNew(new SwInsDBColumn( rColName ));
254  Any aCol = xCols->getByName(rColName);
255  Reference <XPropertySet> xCol;
256  aCol >>= xCol;
257  Any aType = xCol->getPropertyValue("Type");
258  sal_Int32 eDataType = 0;
259  aType >>= eDataType;
260  switch(eDataType)
261  {
262  case DataType::BIT:
263  case DataType::BOOLEAN:
264  case DataType::TINYINT:
265  case DataType::SMALLINT:
266  case DataType::INTEGER:
267  case DataType::BIGINT:
268  case DataType::FLOAT:
269  case DataType::REAL:
270  case DataType::DOUBLE:
271  case DataType::NUMERIC:
272  case DataType::DECIMAL:
273  case DataType::DATE:
274  case DataType::TIME:
275  case DataType::TIMESTAMP:
276  {
277  pNew->bHasFormat = true;
278  Any aFormat = xCol->getPropertyValue("FormatKey");
279  if(aFormat.hasValue())
280  {
281  sal_Int32 nFormat = 0;
282  aFormat >>= nFormat;
283  if(xNumberFormats.is())
284  {
285  try
286  {
287  Reference<XPropertySet> xNumProps = xNumberFormats->getByKey( nFormat );
288  Any aFormatVal = xNumProps->getPropertyValue("FormatString");
289  Any aLocale = xNumProps->getPropertyValue("Locale");
290  OUString sFormat;
291  aFormatVal >>= sFormat;
292  lang::Locale aLoc;
293  aLocale >>= aLoc;
294  sal_Int32 nKey = xDocNumberFormats->queryKey( sFormat, aLoc, true);
295  if(nKey < 0)
296  {
297  nKey = xDocNumberFormats->addNew( sFormat, aLoc );
298  }
299  pNew->nDBNumFormat = nKey;
300  }
301  catch (const Exception&)
302  {
303  OSL_FAIL("illegal number format key");
304  }
305  }
306  }
307  else
308  {
309  pNew->nDBNumFormat = getDefaultNumberFormat(xCol,
310  xDocNumberFormatTypes, LanguageTag( rSh.GetCurLang() ).getLocale());
311  }
312 
313  }
314  break;
315  }
316  if( !aDBColumns.insert( std::move(pNew) ).second )
317  {
318  OSL_ENSURE( false, "Spaltenname mehrfach vergeben?" );
319  }
320  }
321  }
322 
323  // fill paragraph templates-ListBox
324  {
325  SfxStyleSheetBasePool* pPool = pView->GetDocShell()->GetStyleSheetPool();
326  pPool->SetSearchMask( SfxStyleFamily::Para );
327  m_xLbDbParaColl->append_text( sNoTmpl );
328 
329  const SfxStyleSheetBase* pBase = pPool->First();
330  while( pBase )
331  {
332  m_xLbDbParaColl->append_text( pBase->GetName() );
333  pBase = pPool->Next();
334  }
335  m_xLbDbParaColl->set_active( 0 );
336  }
337 
338  // when the cursor is inside of a table, table must NEVER be selectable
339  if( pView->GetWrtShell().GetTableFormat() )
340  {
341  m_xRbAsTable->set_sensitive( false );
342  m_xRbAsField->set_active(true);
343  m_xRbDbFormatFromDb->set_active(true);
344  }
345  else
346  {
347  m_xRbAsTable->set_active(true);
348  m_xRbDbFormatFromDb->set_active(true);
349  m_xIbDbcolOneFrom->set_sensitive( false );
350  m_xIbDbcolAllFrom->set_sensitive( false );
351  }
352 
353  // by default, select header button
354  m_xRbHeadlColnms->set_active(true);
355  m_xRbHeadlEmpty->set_active(false);
356 
357  m_xRbAsTable->connect_clicked( LINK(this, SwInsertDBColAutoPilot, PageHdl ));
358  m_xRbAsField->connect_clicked( LINK(this, SwInsertDBColAutoPilot, PageHdl ));
359  m_xRbAsText->connect_clicked( LINK(this, SwInsertDBColAutoPilot, PageHdl ));
360 
361  m_xRbDbFormatFromDb->connect_clicked( LINK(this, SwInsertDBColAutoPilot, DBFormatHdl ));
362  m_xRbDbFormatFromUsr->connect_clicked( LINK(this, SwInsertDBColAutoPilot, DBFormatHdl ));
363 
364  m_xPbTableFormat->connect_clicked(LINK(this, SwInsertDBColAutoPilot, TableFormatHdl ));
365  m_xPbTableAutofmt->connect_clicked(LINK(this, SwInsertDBColAutoPilot, AutoFormatHdl ));
366 
367  m_xIbDbcolAllTo->connect_clicked( LINK(this, SwInsertDBColAutoPilot, TableToFromHdl ));
368  m_xIbDbcolOneTo->connect_clicked( LINK(this, SwInsertDBColAutoPilot, TableToFromHdl ));
369  m_xIbDbcolOneFrom->connect_clicked( LINK(this, SwInsertDBColAutoPilot, TableToFromHdl ));
370  m_xIbDbcolAllFrom->connect_clicked( LINK(this, SwInsertDBColAutoPilot, TableToFromHdl ));
371  m_xIbDbcolToEdit->connect_clicked( LINK(this, SwInsertDBColAutoPilot, TableToFromHdl ));
372 
373  m_xCbTableHeadon->connect_clicked( LINK(this, SwInsertDBColAutoPilot, HeaderHdl ));
374  m_xRbHeadlColnms->connect_clicked( LINK(this, SwInsertDBColAutoPilot, HeaderHdl ));
375  m_xRbHeadlEmpty->connect_clicked( LINK(this, SwInsertDBColAutoPilot, HeaderHdl ));
376 
377  m_xLbTextDbColumn->connect_changed( LINK( this, SwInsertDBColAutoPilot, TVSelectHdl ));
378  m_xLbTableDbColumn->connect_changed( LINK( this, SwInsertDBColAutoPilot, TVSelectHdl ));
379  m_xLbDbFormatFromUsr->connect_changed( LINK( this, SwInsertDBColAutoPilot, CBSelectHdl ));
380  m_xLbTableCol->connect_changed( LINK( this, SwInsertDBColAutoPilot, TVSelectHdl ));
381 
382  m_xLbTextDbColumn->connect_row_activated( LINK( this, SwInsertDBColAutoPilot, DblClickHdl ));
383  m_xLbTableDbColumn->connect_row_activated( LINK( this, SwInsertDBColAutoPilot, DblClickHdl ));
384  m_xLbTableCol->connect_row_activated( LINK( this, SwInsertDBColAutoPilot, DblClickHdl ));
385 
386  for( size_t n = 0; n < aDBColumns.size(); ++n )
387  {
388  const OUString& rS = aDBColumns[ n ]->sColumn;
389  m_xLbTableDbColumn->append_text(rS);
390  m_xLbTextDbColumn->append_text(rS);
391  }
392  m_xLbTextDbColumn->select(0);
393  m_xLbTableDbColumn->select(0);
394 
395  // read configuration
396  Load();
397 
398  // lock size to widest config
399  m_xHeadFrame->set_size_request(m_xHeadFrame->get_preferred_size().Width(), -1);
400  // initialise Controls:
401  PageHdl(m_xRbAsTable->get_active() ? *m_xRbAsTable : *m_xRbAsField);
402 }
403 
404 SwInsertDBColAutoPilot::~SwInsertDBColAutoPilot()
405 {
406 }
407 
408 IMPL_LINK( SwInsertDBColAutoPilot, PageHdl, weld::Button&, rButton, void )
409 {
410  bool bShowTable = &rButton == m_xRbAsTable.get();
411 
412  m_xHeadFrame->set_label(MnemonicGenerator::EraseAllMnemonicChars(rButton.get_label().replace('_', '~')));
413 
414  m_xLbTextDbColumn->set_visible( !bShowTable );
415  m_xIbDbcolToEdit->set_visible( !bShowTable );
416  m_xEdDbText->set_visible( !bShowTable );
417  m_xFtDbParaColl->set_visible( !bShowTable );
418  m_xLbDbParaColl->set_visible( !bShowTable );
419 
420  m_xLbTableDbColumn->set_visible( bShowTable );
421  m_xIbDbcolAllTo->set_visible( bShowTable );
422  m_xIbDbcolOneTo->set_visible( bShowTable );
423  m_xIbDbcolOneFrom->set_visible( bShowTable );
424  m_xIbDbcolAllFrom->set_visible( bShowTable );
425  m_xFtTableCol->set_visible( bShowTable );
426  m_xLbTableCol->set_visible( bShowTable );
427  m_xCbTableHeadon->set_visible( bShowTable );
428  m_xRbHeadlColnms->set_visible( bShowTable );
429  m_xRbHeadlEmpty->set_visible( bShowTable );
430  m_xPbTableFormat->set_visible( bShowTable );
431  m_xPbTableAutofmt->set_visible( bShowTable );
432 
433  if( bShowTable )
434  m_xPbTableFormat->set_sensitive( 0 != m_xLbTableCol->n_children() );
435 
436  TVSelectHdl( bShowTable ? *m_xLbTableDbColumn : *m_xLbTextDbColumn );
437 }
438 
439 IMPL_LINK( SwInsertDBColAutoPilot, DBFormatHdl, weld::Button&, rButton, void )
440 {
441  weld::TreeView& rBox = m_xRbAsTable->get_active()
442  ? ( m_xLbTableCol->get_id(0).isEmpty()
443  ? *m_xLbTableDbColumn
444  : *m_xLbTableCol )
445  : *m_xLbTextDbColumn;
446 
447  SwInsDBColumn aSrch(rBox.get_selected_text());
448  SwInsDBColumns::const_iterator it = aDBColumns.find( &aSrch );
449 
450  bool bFromDB = m_xRbDbFormatFromDb.get() == &rButton;
451  (*it)->bIsDBFormat = bFromDB;
452  m_xLbDbFormatFromUsr->set_sensitive( !bFromDB );
453 }
454 
455 IMPL_LINK( SwInsertDBColAutoPilot, TableToFromHdl, weld::Button&, rButton, void )
456 {
457  bool bChgEnable = true, bEnableTo = true, bEnableFrom = true;
458 
459  if( &rButton == m_xIbDbcolAllTo.get() )
460  {
461  bEnableTo = false;
462 
463  sal_Int32 n, nInsPos = m_xLbTableCol->get_selected_index(),
464  nCnt = m_xLbTableDbColumn->n_children();
465 
466  m_xLbTableDbColumn->unselect_all();
467 
468  m_xLbTableDbColumn->freeze();
469  m_xLbTableCol->freeze();
470 
471  if (nInsPos == -1)
472  for( n = 0; n < nCnt; ++n )
473  m_xLbTableCol->append_text(m_xLbTableDbColumn->get_text(n));
474  else
475  for( n = 0; n < nCnt; ++n, ++nInsPos )
476  m_xLbTableCol->insert_text(nInsPos, m_xLbTableDbColumn->get_text(n));
477  m_xLbTableDbColumn->clear();
478 
479  m_xLbTableDbColumn->thaw();
480  m_xLbTableCol->thaw();
481 
482  m_xLbTableCol->select(nInsPos);
483  }
484  else if( &rButton == m_xIbDbcolOneTo.get() &&
485  m_xLbTableDbColumn->get_selected_index() != -1 )
486  {
487  sal_Int32 nInsPos = m_xLbTableCol->get_selected_index(),
488  nDelPos = m_xLbTableDbColumn->get_selected_index();
489  m_xLbTableCol->insert_text(nInsPos, m_xLbTableDbColumn->get_text(nDelPos));
490  m_xLbTableDbColumn->remove(nDelPos);
491 
492  m_xLbTableCol->select(nInsPos);
493  if (nDelPos >= m_xLbTableDbColumn->n_children())
494  nDelPos = m_xLbTableDbColumn->n_children() - 1;
495  m_xLbTableDbColumn->select(nDelPos);
496 
497  bEnableTo = 0 != m_xLbTableDbColumn->n_children();
498  }
499  else if( &rButton == m_xIbDbcolOneFrom.get() )
500  {
501  if (m_xLbTableCol->get_selected_index() != -1)
502  {
503  sal_Int32 nInsPos,
504  nDelPos = m_xLbTableCol->get_selected_index();
505 
506  // look for the right InsertPos!!
507  SwInsDBColumn aSrch(m_xLbTableCol->get_text(nDelPos));
508  SwInsDBColumns::const_iterator it = aDBColumns.find( &aSrch );
509  if( it == aDBColumns.begin() || (it+1) == aDBColumns.end() )
510  nInsPos = it - aDBColumns.begin();
511  else
512  {
513  nInsPos = -1;
514  while( ++it != aDBColumns.end() &&
515  -1 == (nInsPos = m_xLbTableDbColumn->
516  find_text( (*it)->sColumn )) )
517  ;
518  }
519 
520  m_xLbTableDbColumn->insert_text(nInsPos, aSrch.sColumn);
521  m_xLbTableCol->remove( nDelPos );
522 
523  if (nInsPos >= m_xLbTableDbColumn->n_children())
524  nInsPos = m_xLbTableDbColumn->n_children() - 1;
525  m_xLbTableDbColumn->select(nInsPos);
526 
527  if (nDelPos >= m_xLbTableCol->n_children())
528  nDelPos = m_xLbTableCol->n_children() - 1;
529  m_xLbTableCol->select(nDelPos);
530  }
531  else
532  bEnableTo = 0 != m_xLbTableDbColumn->n_children();
533 
534  bEnableFrom = 0 != m_xLbTableCol->n_children();
535  }
536  else if( &rButton == m_xIbDbcolAllFrom.get() )
537  {
538  bEnableFrom = false;
539 
540  m_xLbTableDbColumn->freeze();
541  m_xLbTableCol->freeze();
542 
543  m_xLbTableDbColumn->clear();
544  m_xLbTableCol->clear();
545  for (size_t n = 0; n < aDBColumns.size(); ++n)
546  m_xLbTableDbColumn->append_text(aDBColumns[n]->sColumn);
547 
548  m_xLbTableDbColumn->thaw();
549  m_xLbTableCol->thaw();
550 
551  m_xLbTableDbColumn->select(0);
552  }
553  else if( &rButton == m_xIbDbcolToEdit.get() )
554  {
555  bChgEnable = false;
556  // move data to Edit:
557  OUString aField(m_xLbTextDbColumn->get_selected_text());
558  if( !aField.isEmpty() )
559  {
560  OUString aStr( m_xEdDbText->get_text() );
561  int nStartPos, nEndPos;
562  m_xEdDbText->get_selection_bounds(nStartPos, nEndPos);
563  sal_Int32 nPos = std::min(nStartPos, nEndPos);
564  sal_Int32 nMax = std::max(nStartPos, nEndPos);
565  const sal_Int32 nSel = nMax - nPos;
566  if( nSel )
567  // first delete the existing selection
568  aStr = aStr.replaceAt( nPos, nSel, "" );
569 
570  aField = OUStringChar(cDBFieldStart) + aField + OUStringChar(cDBFieldEnd);
571  if( !aStr.isEmpty() )
572  {
573  if( nPos ) // one blank in front
574  {
575  sal_Unicode c = aStr[ nPos-1 ];
576  if( '\n' != c && '\r' != c )
577  aField = " " + aField;
578  }
579  if( nPos < aStr.getLength() ) // one blank behind
580  {
581  sal_Unicode c = aStr[ nPos ];
582  if( '\n' != c && '\r' != c )
583  aField += " ";
584  }
585  }
586 
587  m_xEdDbText->set_text( aStr.replaceAt( nPos, 0, aField ) );
588  nPos += aField.getLength();
589  m_xEdDbText->select_region(nPos, nPos);
590  }
591  }
592 
593  if( bChgEnable )
594  {
595  m_xIbDbcolOneTo->set_sensitive( bEnableTo );
596  m_xIbDbcolAllTo->set_sensitive( bEnableTo );
597  m_xIbDbcolOneFrom->set_sensitive( bEnableFrom );
598  m_xIbDbcolAllFrom->set_sensitive( bEnableFrom );
599 
600  m_xRbDbFormatFromDb->set_sensitive( false );
601  m_xRbDbFormatFromUsr->set_sensitive( false );
602  m_xLbDbFormatFromUsr->set_sensitive( false );
603 
604  m_xPbTableFormat->set_sensitive( bEnableFrom );
605  }
606 }
607 
608 IMPL_LINK(SwInsertDBColAutoPilot, DblClickHdl, weld::TreeView&, rBox, bool)
609 {
610  weld::Button* pButton = nullptr;
611  if( &rBox == m_xLbTextDbColumn.get() )
612  pButton = m_xIbDbcolToEdit.get();
613  else if( &rBox == m_xLbTableDbColumn.get() && m_xIbDbcolOneTo->get_sensitive() )
614  pButton = m_xIbDbcolOneTo.get();
615  else if( &rBox == m_xLbTableCol.get() && m_xIbDbcolOneFrom->get_sensitive() )
616  pButton = m_xIbDbcolOneFrom.get();
617 
618  if (pButton)
619  TableToFromHdl(*pButton);
620 
621  return true;
622 }
623 
624 IMPL_LINK_NOARG(SwInsertDBColAutoPilot, TableFormatHdl, weld::Button&, void)
625 {
626  SwWrtShell& rSh = pView->GetWrtShell();
627  bool bNewSet = false;
628  if( !pTableSet )
629  {
630  bNewSet = true;
631  pTableSet.reset(new SfxItemSet( rSh.GetAttrPool(), SwuiGetUITableAttrRange() ));
632 
633  // At first acquire the simple attributes
634  pTableSet->Put( SfxStringItem( FN_PARAM_TABLE_NAME, rSh.GetUniqueTableName() ));
635  pTableSet->Put( SfxUInt16Item( FN_PARAM_TABLE_HEADLINE, 1 ) );
636 
637  pTableSet->Put( SfxUInt16Item( SID_BACKGRND_DESTINATION,
638  rSh.GetViewOptions()->GetTableDest() ));
639 
640  SvxBrushItem aBrush( RES_BACKGROUND );
641  pTableSet->Put( aBrush );
642  aBrush.SetWhich(SID_ATTR_BRUSH_ROW);
643  pTableSet->Put( aBrush );
644  aBrush.SetWhich(SID_ATTR_BRUSH_TABLE);
645  pTableSet->Put( aBrush );
646 
647  SvxBoxInfoItem aBoxInfo( SID_ATTR_BORDER_INNER );
648  // table variant, when multiple table cells are selected
649  aBoxInfo.SetTable( true );
650  // always show gap field
651  aBoxInfo.SetDist( true);
652  // set minimum size in tables and paragraphs
653  aBoxInfo.SetMinDist( false );
654  // always set default-gap
655  aBoxInfo.SetDefDist( MIN_BORDER_DIST );
656  // Single lines can have DontCare-status only in tables
657  aBoxInfo.SetValid( SvxBoxInfoItemValidFlags::DISABLE );
658  pTableSet->Put( aBoxInfo );
659 
660  SwGetCurColNumPara aPara;
661  const sal_uInt16 nNum = rSh.GetCurColNum( &aPara );
662  long nWidth;
663 
664  if( nNum )
665  {
666  nWidth = aPara.pPrtRect->Width();
667  const SwFormatCol& rCol = aPara.pFrameFormat->GetCol();
668  const SwColumns& rCols = rCol.GetColumns();
669 
670  // initialise nStart and nEnd for nNum == 0
671  long nWidth1 = 0,
672  nStart1 = 0,
673  nEnd1 = nWidth;
674  for( sal_uInt16 i = 0; i < nNum; ++i )
675  {
676  const SwColumn* pCol = &rCols[i];
677  nStart1 = pCol->GetLeft() + nWidth1;
678  nWidth1 += static_cast<long>(rCol.CalcColWidth( i, static_cast<sal_uInt16>(nWidth) ));
679  nEnd1 = nWidth1 - pCol->GetRight();
680  }
681  if(nStart1 || nEnd1 != nWidth)
682  nWidth = nEnd1 - nStart1;
683  }
684  else
685  nWidth = rSh.GetAnyCurRect(
686  (FrameTypeFlags::FLY_ANY & rSh.GetFrameType( nullptr, true ))
687  ? CurRectType::FlyEmbeddedPrt
688  : CurRectType::PagePrt ).Width();
689 
690  SwTabCols aTabCols;
691  aTabCols.SetRight( nWidth );
692  aTabCols.SetRightMax( nWidth );
693  pRep.reset(new SwTableRep( aTabCols ));
694  pRep->SetAlign( text::HoriOrientation::NONE );
695  pRep->SetSpace( nWidth );
696  pRep->SetWidth( nWidth );
697  pRep->SetWidthPercent( 100 );
698  pTableSet->Put( SwPtrItem( FN_TABLE_REP, pRep.get() ));
699 
700  pTableSet->Put( SfxUInt16Item( SID_HTML_MODE,
701  ::GetHtmlMode( pView->GetDocShell() )));
702  }
703 
704  sal_Int32 nCols = m_xLbTableCol->n_children();
705  if (nCols != pRep->GetAllColCount() && nCols > 0)
706  {
707  // Number of columns has changed: then the TabCols have to be adjusted
708  long nWidth = pRep->GetWidth();
709  --nCols;
710  SwTabCols aTabCols( nCols );
711  aTabCols.SetRight( nWidth );
712  aTabCols.SetRightMax( nWidth );
713  if( nCols )
714  {
715  const sal_Int32 nStep = nWidth / (nCols+1);
716  for( sal_Int32 n = 0; n < nCols; ++n )
717  {
718  aTabCols.Insert( nStep*(n+1), false, n );
719  }
720  }
721  pRep.reset(new SwTableRep( aTabCols ));
722  pRep->SetAlign( text::HoriOrientation::NONE );
723  pRep->SetSpace( nWidth );
724  pRep->SetWidth( nWidth );
725  pRep->SetWidthPercent( 100 );
726  pTableSet->Put( SwPtrItem( FN_TABLE_REP, pRep.get() ));
727  }
728 
729  SwAbstractDialogFactory& rFact = swui::GetFactory();
730 
731  ScopedVclPtr<SfxAbstractTabDialog> pDlg(rFact.CreateSwTableTabDlg(m_xDialog.get(), pTableSet.get(), &rSh));
732  if( RET_OK == pDlg->Execute() )
733  pTableSet->Put( *pDlg->GetOutputItemSet() );
734  else if( bNewSet )
735  {
736  pTableSet.reset();
737  pRep.reset();
738  }
739 }
740 
741 IMPL_LINK_NOARG(SwInsertDBColAutoPilot, AutoFormatHdl, weld::Button&, void)
742 {
743  SwAbstractDialogFactory& rFact = swui::GetFactory();
744 
745  ScopedVclPtr<AbstractSwAutoFormatDlg> pDlg(rFact.CreateSwAutoFormatDlg(m_xDialog.get(), pView->GetWrtShellPtr(), false, m_xTAutoFormat.get()));
746  if( RET_OK == pDlg->Execute())
747  m_xTAutoFormat = pDlg->FillAutoFormatOfIndex();
748 }
749 
750 IMPL_LINK(SwInsertDBColAutoPilot, TVSelectHdl, weld::TreeView&, rBox, void)
751 {
752  weld::TreeView* pGetBox = &rBox;
753 
754  SwInsDBColumn aSrch(pGetBox->get_selected_text());
755  SwInsDBColumns::const_iterator it = aDBColumns.find( &aSrch );
756 
757  // set the selected FieldName at the FormatGroupBox, so that
758  // it's clear what field is configured by the format!
759  OUString sText( m_xFormatFrame->get_label().copy( 0, nGBFormatLen ));
760  if( aSrch.sColumn.isEmpty() )
761  {
762  m_xRbDbFormatFromDb->set_sensitive( false );
763  m_xRbDbFormatFromUsr->set_sensitive( false );
764  m_xLbDbFormatFromUsr->set_sensitive( false );
765  }
766  else
767  {
768  bool bEnableFormat = (*it)->bHasFormat;
769  m_xRbDbFormatFromDb->set_sensitive( bEnableFormat );
770  m_xRbDbFormatFromUsr->set_sensitive( bEnableFormat );
771 
772  if( bEnableFormat )
773  {
774  sText += " (" + aSrch.sColumn + ")";
775  }
776 
777  bool bIsDBFormat = (*it)->bIsDBFormat;
778  m_xRbDbFormatFromDb->set_active( bIsDBFormat );
779  m_xRbDbFormatFromUsr->set_active( !bIsDBFormat );
780  m_xLbDbFormatFromUsr->set_sensitive( !bIsDBFormat );
781  if( !bIsDBFormat )
782  m_xLbDbFormatFromUsr->SetDefFormat( (*it)->nUsrNumFormat );
783  }
784 
785  m_xFormatFrame->set_label(sText);
786 
787  if (m_xLbTableCol->n_children())
788  {
789  // to know later on, what ListBox was the "active", a Flag
790  // is remembered in the 1st entry
791  if (&rBox == m_xLbTableCol.get())
792  m_xLbTableCol->set_id(0, "tablecols");
793  else
794  m_xLbTableCol->set_id(0, OUString());
795  }
796 }
797 
798 IMPL_LINK_NOARG(SwInsertDBColAutoPilot, CBSelectHdl, weld::ComboBox&, void)
799 {
800  weld::TreeView* pGetBox = m_xRbAsTable->get_active()
801  ? ( m_xLbTableCol->get_id(0).isEmpty()
802  ? m_xLbTableDbColumn.get()
803  : m_xLbTableCol.get() )
804  : m_xLbTextDbColumn.get();
805 
806  SwInsDBColumn aSrch(pGetBox->get_selected_text());
807  SwInsDBColumns::const_iterator it = aDBColumns.find( &aSrch );
808 
809  if( !aSrch.sColumn.isEmpty() )
810  {
811  m_xLbDbFormatFromUsr->CallSelectHdl();
812  (*it)->nUsrNumFormat = m_xLbDbFormatFromUsr->GetFormat();
813  }
814 }
815 
816 IMPL_LINK( SwInsertDBColAutoPilot, HeaderHdl, weld::Button&, rButton, void )
817 {
818  if (&rButton == m_xCbTableHeadon.get())
819  {
820  bool bEnable = m_xCbTableHeadon->get_active();
821 
822  m_xRbHeadlColnms->set_sensitive( bEnable );
823  m_xRbHeadlEmpty->set_sensitive( bEnable );
824  }
825 }
826 
827 static void lcl_InsTextInArr( const OUString& rText, DB_Columns& rColArr )
828 {
829  sal_Int32 nSttPos = 0, nFndPos;
830  while( -1 != ( nFndPos = rText.indexOf( '\x0A', nSttPos )) )
831  {
832  if( 1 < nFndPos )
833  {
834  rColArr.push_back(std::make_unique<DB_Column>(rText.copy(nSttPos, nFndPos -1)));
835  }
836  rColArr.push_back(std::make_unique<DB_Column>());
837  nSttPos = nFndPos + 1;
838  }
839  if( nSttPos < rText.getLength() )
840  {
841  rColArr.push_back(std::make_unique<DB_Column>(rText.copy(nSttPos)));
842  }
843 }
844 
845 bool SwInsertDBColAutoPilot::SplitTextToColArr( const OUString& rText,
846  DB_Columns& rColArr,
847  bool bInsField )
848 {
849  // create each of the database columns from the text again
850  // and then save in an array
851  // database columns are in <> and must be present in the columns' array:
852  OUString sText( rText );
853  sal_Int32 nFndPos, nEndPos, nSttPos = 0;
854 
855  while( -1 != ( nFndPos = sText.indexOf( cDBFieldStart, nSttPos )))
856  {
857  nSttPos = nFndPos + 1;
858  if( -1 != ( nEndPos = sText.indexOf( cDBFieldEnd, nSttPos+1 )))
859  {
860  // Text in <> brackets found: what is it:
861  SwInsDBColumn aSrch( sText.copy( nSttPos, nEndPos - nSttPos ));
862  SwInsDBColumns::const_iterator it = aDBColumns.find( &aSrch );
863  if( it != aDBColumns.end() )
864  {
865  // that is a valid field
866  // so surely the text "before":
867  const SwInsDBColumn& rFndCol = **it;
868 
869  DB_Column* pNew;
870 
871  if( 1 < nSttPos )
872  {
873  ::lcl_InsTextInArr( sText.copy( 0, nSttPos-1 ), rColArr );
874  sText = sText.copy( nSttPos-1 );
875  }
876 
877  sText = sText.copy( rFndCol.sColumn.getLength() + 2 );
878  nSttPos = 0;
879 
880  sal_uInt16 nSubType = 0;
881  sal_uInt32 nFormat;
882  if( rFndCol.bHasFormat )
883  {
884  if( rFndCol.bIsDBFormat )
885  nFormat = static_cast<sal_uInt32>(rFndCol.nDBNumFormat);
886  else
887  {
888  nFormat = rFndCol.nUsrNumFormat;
889  nSubType = nsSwExtendedSubType::SUB_OWN_FMT;
890  }
891  }
892  else
893  nFormat = 0;
894 
895  if( bInsField )
896  {
897  SwWrtShell& rSh = pView->GetWrtShell();
898  SwDBFieldType aFieldType( rSh.GetDoc(), aSrch.sColumn,
899  aDBData );
900  pNew = new DB_Column( rFndCol, *new SwDBField(
901  static_cast<SwDBFieldType*>(rSh.InsertFieldType( aFieldType )),
902  nFormat ) );
903  if( nSubType )
904  pNew->pField->SetSubType( nSubType );
905  }
906  else
907  pNew = new DB_Column( rFndCol, nFormat );
908 
909  rColArr.push_back( std::unique_ptr<DB_Column>(pNew) );
910  }
911  }
912  }
913 
914  // don't forget the last text
915  if( !sText.isEmpty() )
916  ::lcl_InsTextInArr( sText, rColArr );
917 
918  return !rColArr.empty();
919 }
920 
921 void SwInsertDBColAutoPilot::DataToDoc( const Sequence<Any>& rSelection,
922  Reference< XDataSource> const & xSource,
923  Reference< XConnection> const & xConnection,
924  Reference< sdbc::XResultSet > const & xResultSet_in )
925 {
926  auto xResultSet = xResultSet_in;
927 
928  const Any* pSelection = rSelection.hasElements() ? rSelection.getConstArray() : nullptr;
929  SwWrtShell& rSh = pView->GetWrtShell();
930 
931  //with the drag and drop interface no result set is initially available
932  bool bDisposeResultSet = false;
933  // we don't have a cursor, so we have to create our own RowSet
934  if ( !xResultSet.is() )
935  {
936  xResultSet = SwDBManager::createCursor(aDBData.sDataSource,aDBData.sCommand,aDBData.nCommandType,xConnection,pView);
937  bDisposeResultSet = xResultSet.is();
938  }
939 
940  Reference< sdbc::XRow > xRow(xResultSet, UNO_QUERY);
941  if ( !xRow.is() )
942  return;
943 
944  rSh.StartAllAction();
945  bool bUndo = rSh.DoesUndo();
946  if( bUndo )
947  rSh.StartUndo();
948 
949  bool bAsTable = m_xRbAsTable->get_active();
950  SvNumberFormatter& rNumFormatr = *rSh.GetNumberFormatter();
951 
952  if( rSh.HasSelection() )
953  rSh.DelRight();
954 
955  std::unique_ptr<SwWait> pWait;
956 
957  Reference< XColumnsSupplier > xColsSupp( xResultSet, UNO_QUERY );
958  Reference <XNameAccess> xCols = xColsSupp->getColumns();
959 
960  uno::Reference<sdbcx::XRowLocate> xRowLocate(xResultSet, uno::UNO_QUERY_THROW);
961 
962  do{ // middle checked loop!!
963  if( bAsTable ) // fill in data as table
964  {
965  rSh.DoUndo( false );
966 
967  sal_Int32 nCols = m_xLbTableCol->n_children();
968  sal_Int32 nRows = 0;
969  if( m_xCbTableHeadon->get_active() )
970  nRows++;
971 
972  if( pSelection )
973  nRows += rSelection.getLength();
974  else
975  ++nRows;
976 
977  // prepare the array for the selected columns
978  std::vector<SwInsDBColumn*> aColFields;
979  for( sal_Int32 n = 0; n < nCols; ++n )
980  {
981  SwInsDBColumn aSrch(m_xLbTableCol->get_text(n));
982  SwInsDBColumns::const_iterator it = aDBColumns.find( &aSrch );
983  if (it != aDBColumns.end())
984  aColFields.push_back(it->get());
985  else {
986  OSL_ENSURE( false, "database column not found" );
987  }
988  }
989 
990  if( static_cast<size_t>(nCols) != aColFields.size() )
991  {
992  OSL_ENSURE( false, "not all database columns found" );
993  nCols = static_cast<sal_Int32>(aColFields.size());
994  }
995 
996  if(!nRows || !nCols)
997  {
998  OSL_ENSURE( false, "wrong parameters" );
999  break;
1000  }
1001 
1002  const SwModuleOptions* pModOpt = SW_MOD()->GetModuleConfig();
1003 
1004  bool bHTML = 0 != (::GetHtmlMode( pView->GetDocShell() ) & HTMLMODE_ON);
1005  rSh.InsertTable(
1006  pModOpt->GetInsTableFlags(bHTML),
1007  nRows, nCols, (pSelection ? m_xTAutoFormat.get(): nullptr) );
1008  rSh.MoveTable( GotoPrevTable, fnTableStart );
1009 
1010  if( pSelection && pTableSet )
1011  SetTabSet();
1012 
1013  SfxItemSet aTableSet( rSh.GetAttrPool(), svl::Items<RES_BOXATR_FORMAT,
1014  RES_BOXATR_VALUE>{} );
1015  bool bIsAutoUpdateCells = rSh.IsAutoUpdateCells();
1016  rSh.SetAutoUpdateCells( false );
1017 
1018  if( m_xCbTableHeadon->get_active() )
1019  {
1020  for( sal_Int32 n = 0; n < nCols; ++n )
1021  {
1022  if( m_xRbHeadlColnms->get_active() )
1023  {
1024  rSh.SwEditShell::Insert2( aColFields[ n ]->sColumn );
1025  }
1026  rSh.GoNextCell();
1027  }
1028  }
1029  else
1030  rSh.SetRowsToRepeat( 0 );
1031 
1032  for( sal_Int32 i = 0 ; ; ++i )
1033  {
1034  bool bBreak = false;
1035  try
1036  {
1037  if(pSelection)
1038  {
1039  bBreak = !xRowLocate->moveToBookmark(pSelection[i]);
1040  }
1041  else if(!i)
1042  bBreak = !xResultSet->first();
1043  }
1044  catch (const Exception&)
1045  {
1046  bBreak = true;
1047  }
1048  if(bBreak)
1049  break;
1050 
1051  for( sal_Int32 n = 0; n < nCols; ++n )
1052  {
1053  // at the very first time, NO GoNextCell, because we're
1054  // already in it. Also no GoNextCell after the Insert,
1055  // because an empty line is added at the end.
1056  if( i || n )
1057  rSh.GoNextCell();
1058 
1059  const SwInsDBColumn* pEntry = aColFields[ n ];
1060 
1061  Reference< XColumn > xColumn;
1062  xCols->getByName(pEntry->sColumn) >>= xColumn;
1063  Reference< XPropertySet > xColumnProps( xColumn, UNO_QUERY );
1064  sal_Int32 eDataType = 0;
1065  if( xColumnProps.is() )
1066  {
1067  Any aType = xColumnProps->getPropertyValue("Type");
1068  aType >>= eDataType;
1069  }
1070  try
1071  {
1072  if( pEntry->bHasFormat )
1073  {
1074  SwTableBoxNumFormat aNumFormat(
1075  pEntry->bIsDBFormat ? static_cast<sal_uInt32>(pEntry->nDBNumFormat)
1076  : pEntry->nUsrNumFormat );
1077  aTableSet.Put(aNumFormat);
1078  if( xColumn.is() )
1079  {
1080  double fVal = xColumn->getDouble();
1081  if( xColumn->wasNull() )
1082  aTableSet.ClearItem( RES_BOXATR_VALUE );
1083  else
1084  {
1085  if(rNumFormatr.GetType(aNumFormat.GetValue()) & SvNumFormatType::DATE)
1086  {
1087  ::Date aStandard(1,1,1900);
1088  if (rNumFormatr.GetNullDate() != aStandard)
1089  fVal += (aStandard - rNumFormatr.GetNullDate());
1090  }
1091  aTableSet.Put( SwTableBoxValue( fVal ));
1092  }
1093  }
1094  else
1095  aTableSet.ClearItem( RES_BOXATR_VALUE );
1096  rSh.SetTableBoxFormulaAttrs( aTableSet );
1097  }
1098  //#i60207# don't insert binary data as string - creates a loop
1099  else if( DataType::BINARY == eDataType ||
1100  DataType::VARBINARY == eDataType ||
1101  DataType::LONGVARBINARY== eDataType ||
1102  DataType::SQLNULL == eDataType ||
1103  DataType::OTHER == eDataType ||
1104  DataType::OBJECT == eDataType ||
1105  DataType::DISTINCT == eDataType ||
1106  DataType::STRUCT == eDataType ||
1107  DataType::ARRAY == eDataType ||
1108  DataType::BLOB == eDataType ||
1109  DataType::CLOB == eDataType ||
1110  DataType::REF == eDataType
1111  )
1112  {
1113  // do nothing
1114  }
1115  else
1116  {
1117  const OUString sVal = xColumn->getString();
1118  if(!xColumn->wasNull())
1119  {
1120  rSh.SwEditShell::Insert2( sVal );
1121  }
1122  }
1123  }
1124  catch (const Exception&)
1125  {
1126  TOOLS_WARN_EXCEPTION("sw", "");
1127  }
1128  }
1129 
1130  if( !pSelection )
1131  {
1132  if ( !xResultSet->next() )
1133  break;
1134  }
1135  else if( i+1 >= rSelection.getLength() )
1136  break;
1137 
1138  if( 10 == i )
1139  pWait.reset(new SwWait( *pView->GetDocShell(), true ));
1140  }
1141 
1142  rSh.MoveTable( GotoCurrTable, fnTableStart );
1143  if( !pSelection && ( pTableSet || m_xTAutoFormat ))
1144  {
1145  if( pTableSet )
1146  SetTabSet();
1147 
1148  if (m_xTAutoFormat)
1149  rSh.SetTableStyle(*m_xTAutoFormat);
1150  }
1151  rSh.SetAutoUpdateCells( bIsAutoUpdateCells );
1152  }
1153  else // add data as fields/text
1154  {
1155  DB_Columns aColArr;
1156  if( SplitTextToColArr( m_xEdDbText->get_text(), aColArr, m_xRbAsField->get_active() ) )
1157  {
1158  // now for each data set, we can iterate over the array
1159  // and add the data
1160 
1161  if( !rSh.IsSttPara() )
1162  rSh.SwEditShell::SplitNode();
1163  if( !rSh.IsEndPara() )
1164  {
1165  rSh.SwEditShell::SplitNode();
1166  rSh.SwCursorShell::Left(1,CRSR_SKIP_CHARS);
1167  }
1168 
1169  rSh.DoUndo( false );
1170 
1171  SwTextFormatColl* pColl = nullptr;
1172  {
1173  const OUString sTmplNm(m_xLbDbParaColl->get_active_text());
1174  if( sNoTmpl != sTmplNm )
1175  {
1176  pColl = rSh.FindTextFormatCollByName( sTmplNm );
1177  if( !pColl )
1178  {
1179  const sal_uInt16 nId = SwStyleNameMapper::GetPoolIdFromUIName(
1180  sTmplNm, SwGetPoolIdFromName::TxtColl );
1181  if( USHRT_MAX != nId )
1182  pColl = rSh.GetTextCollFromPool( nId );
1183  else
1184  pColl = rSh.MakeTextFormatColl( sTmplNm );
1185  }
1186  rSh.SetTextFormatColl( pColl );
1187  }
1188  }
1189 
1190  // for adding as fields -> insert a "NextField" after
1191  // every data set
1192  SwDBFormatData aDBFormatData;
1193  Reference< XComponentContext > xContext( ::comphelper::getProcessComponentContext() );
1194  aDBFormatData.xFormatter.set(util::NumberFormatter::create(xContext), UNO_QUERY_THROW) ;
1195 
1196  Reference<XPropertySet> xSourceProps(xSource, UNO_QUERY);
1197  if(xSourceProps.is())
1198  {
1199  Any aFormats = xSourceProps->getPropertyValue("NumberFormatsSupplier");
1200  if(aFormats.hasValue())
1201  {
1202  Reference< util::XNumberFormatsSupplier> xSuppl;
1203  aFormats >>= xSuppl;
1204  if(xSuppl.is())
1205  {
1206  Reference< XPropertySet > xSettings = xSuppl->getNumberFormatSettings();
1207  Any aNull = xSettings->getPropertyValue("NullDate");
1208  aNull >>= aDBFormatData.aNullDate;
1209  if(aDBFormatData.xFormatter.is())
1210  aDBFormatData.xFormatter->attachNumberFormatsSupplier(xSuppl);
1211  }
1212  }
1213  }
1214  aDBFormatData.aLocale = LanguageTag( rSh.GetCurLang() ).getLocale();
1215  SwDBNextSetField aNxtDBField( static_cast<SwDBNextSetFieldType*>(rSh.
1216  GetFieldType( 0, SwFieldIds::DbNextSet )),
1217  "1", aDBData );
1218 
1219  bool bSetCursor = true;
1220  const size_t nCols = aColArr.size();
1221  ::sw::mark::IMark* pMark = nullptr;
1222  for( sal_Int32 i = 0 ; ; ++i )
1223  {
1224  bool bBreak = false;
1225  try
1226  {
1227  if(pSelection)
1228  {
1229  bBreak = !xRowLocate->moveToBookmark(pSelection[i]);
1230  }
1231  else if(!i)
1232  bBreak = !xResultSet->first();
1233  }
1234  catch (const Exception&)
1235  {
1236  bBreak = true;
1237  }
1238 
1239  if(bBreak)
1240  break;
1241 
1242  for( size_t n = 0; n < nCols; ++n )
1243  {
1244  DB_Column* pDBCol = aColArr[ n ].get();
1245  OUString sIns;
1246  switch( pDBCol->eColType )
1247  {
1248  case DB_Column::Type::FILLTEXT:
1249  sIns = *pDBCol->pText;
1250  break;
1251 
1252  case DB_Column::Type::SPLITPARA:
1253  rSh.SplitNode();
1254  // when the template is not the same as the follow template,
1255  // the selected has to be set newly
1256  if( pColl && &pColl->GetNextTextFormatColl() != pColl )
1257  rSh.SetTextFormatColl( pColl );
1258  break;
1259 
1260  case DB_Column::Type::COL_FIELD:
1261  {
1262  std::unique_ptr<SwDBField> pField(static_cast<SwDBField *>(
1263  pDBCol->pField->CopyField().release()));
1264  double nValue = DBL_MAX;
1265 
1266  Reference< XPropertySet > xColumnProps;
1267  xCols->getByName(pDBCol->pColInfo->sColumn) >>= xColumnProps;
1268 
1269  pField->SetExpansion( SwDBManager::GetDBField(
1270  xColumnProps,
1271  aDBFormatData,
1272  &nValue ) );
1273  if( DBL_MAX != nValue )
1274  {
1275  Any aType = xColumnProps->getPropertyValue("Type");
1276  sal_Int32 eDataType = 0;
1277  aType >>= eDataType;
1278  if( DataType::DATE == eDataType || DataType::TIME == eDataType ||
1279  DataType::TIMESTAMP == eDataType)
1280 
1281  {
1282  ::Date aStandard(1,1,1900);
1283  ::Date aCompare(aDBFormatData.aNullDate.Day ,
1284  aDBFormatData.aNullDate.Month,
1285  aDBFormatData.aNullDate.Year);
1286  if(aStandard != aCompare)
1287  nValue += (aStandard - aCompare);
1288  }
1289  pField->ChgValue( nValue, true );
1290  }
1291  pField->SetInitialized();
1292 
1293  rSh.Insert( *pField );
1294  }
1295  break;
1296 
1297  case DB_Column::Type::COL_TEXT:
1298  {
1299  double nValue = DBL_MAX;
1300  Reference< XPropertySet > xColumnProps;
1301  xCols->getByName(pDBCol->pColInfo->sColumn) >>= xColumnProps;
1302  sIns = SwDBManager::GetDBField(
1303  xColumnProps,
1304  aDBFormatData,
1305  &nValue );
1306  if( pDBCol->nFormat &&
1307  DBL_MAX != nValue )
1308  {
1309  Color* pCol;
1310  if(rNumFormatr.GetType(pDBCol->nFormat) & SvNumFormatType::DATE)
1311  {
1312  ::Date aStandard(1,1,1900);
1313  if (rNumFormatr.GetNullDate() != aStandard)
1314  nValue += (aStandard - rNumFormatr.GetNullDate());
1315  }
1316  rNumFormatr.GetOutputString( nValue,
1317  pDBCol->nFormat,
1318  sIns, &pCol );
1319  }
1320  }
1321  break;
1322  }
1323 
1324  if( !sIns.isEmpty() )
1325  {
1326  rSh.Insert( sIns );
1327 
1328  if( bSetCursor)
1329  {
1330  // to the beginning and set a mark, so that
1331  // the cursor can be set to the initial position
1332  // at the end.
1333 
1334  rSh.SwCursorShell::MovePara(
1335  GoCurrPara, fnParaStart );
1336  pMark = rSh.SetBookmark(
1337  vcl::KeyCode(),
1338  OUString(),
1339  IDocumentMarkAccess::MarkType::UNO_BOOKMARK );
1340  rSh.SwCursorShell::MovePara(
1341  GoCurrPara, fnParaEnd );
1342  bSetCursor = false;
1343  }
1344  }
1345  }
1346 
1347  if( !pSelection )
1348  {
1349  bool bNext = xResultSet->next();
1350  if(!bNext)
1351  break;
1352  }
1353  else if( i+1 >= rSelection.getLength() )
1354  break;
1355 
1356  if( m_xRbAsField->get_active() )
1357  rSh.Insert( aNxtDBField );
1358 
1359  if( !rSh.IsSttPara() )
1360  rSh.SwEditShell::SplitNode();
1361 
1362  if( 10 == i )
1363  pWait.reset(new SwWait( *pView->GetDocShell(), true ));
1364  }
1365 
1366  if( !bSetCursor && pMark != nullptr)
1367  {
1368  rSh.SetMark();
1369  rSh.GotoMark( pMark );
1370  rSh.getIDocumentMarkAccess()->deleteMark( pMark );
1371  break;
1372  }
1373  }
1374  }
1375  // write configuration
1376  Commit();
1377  }while( false ); // middle checked loop
1378 
1379  if( bUndo )
1380  {
1381  rSh.DoUndo();
1382  rSh.AppendUndoForInsertFromDB( bAsTable );
1383  rSh.EndUndo();
1384  }
1385  rSh.ClearMark();
1386  rSh.EndAllAction();
1387 
1388  if ( bDisposeResultSet )
1389  ::comphelper::disposeComponent(xResultSet);
1390 }
1391 
1392 void SwInsertDBColAutoPilot::SetTabSet()
1393 {
1394  SwWrtShell& rSh = pView->GetWrtShell();
1395  const SfxPoolItem* pItem;
1396 
1397  if (m_xTAutoFormat)
1398  {
1399  if (m_xTAutoFormat->IsFrame())
1400  {
1401  // border is from AutoFormat
1402  pTableSet->ClearItem( RES_BOX );
1403  pTableSet->ClearItem( SID_ATTR_BORDER_INNER );
1404  }
1405  if (m_xTAutoFormat->IsBackground())
1406  {
1407  pTableSet->ClearItem( RES_BACKGROUND );
1408  pTableSet->ClearItem( SID_ATTR_BRUSH_ROW );
1409  pTableSet->ClearItem( SID_ATTR_BRUSH_TABLE );
1410  }
1411  }
1412  else
1413  {
1414  // remove the defaults again, it makes no sense to set them
1415  SvxBrushItem aBrush( RES_BACKGROUND );
1416  static const sal_uInt16 aIds[3] =
1417  { RES_BACKGROUND, SID_ATTR_BRUSH_ROW, SID_ATTR_BRUSH_TABLE };
1418  for(sal_uInt16 i : aIds)
1419  if( SfxItemState::SET == pTableSet->GetItemState( i,
1420  false, &pItem ) && *pItem == aBrush )
1421  pTableSet->ClearItem( i );
1422  }
1423 
1424  if( SfxItemState::SET == pTableSet->GetItemState( FN_PARAM_TABLE_NAME, false,
1425  &pItem ) && static_cast<const SfxStringItem*>(pItem)->GetValue() ==
1426  rSh.GetTableFormat()->GetName() )
1427  pTableSet->ClearItem( FN_PARAM_TABLE_NAME );
1428 
1429  rSh.MoveTable( GotoCurrTable, fnTableStart );
1430  rSh.SetMark();
1431  rSh.MoveTable( GotoCurrTable, fnTableEnd );
1432 
1433  ItemSetToTableParam( *pTableSet, rSh );
1434 
1435  rSh.ClearMark();
1436  rSh.MoveTable( GotoCurrTable, fnTableStart );
1437 }
1438 
1439 static Sequence<OUString> lcl_createSourceNames(const OUString& rNodeName)
1440 {
1441  Sequence<OUString> aSourceNames(11);
1442  OUString* pNames = aSourceNames.getArray();
1443  pNames[0] = rNodeName + "/DataSource";
1444  pNames[1] = rNodeName + "/Command";
1445  pNames[2] = rNodeName + "/CommandType";
1446  pNames[3] = rNodeName + "/ColumnsToText";
1447  pNames[4] = rNodeName + "/ColumnsToTable";
1448  pNames[5] = rNodeName + "/ParaStyle";
1449  pNames[6] = rNodeName + "/TableAutoFormat";
1450  pNames[7] = rNodeName + "/IsTable";
1451  pNames[8] = rNodeName + "/IsField";
1452  pNames[9] = rNodeName + "/IsHeadlineOn";
1453  pNames[10] = rNodeName + "/IsEmptyHeadline";
1454  return aSourceNames;
1455 }
1456 
1457 static Sequence<OUString> lcl_CreateSubNames(const OUString& rSubNodeName)
1458 {
1459  Sequence<OUString> aSubSourceNames(6);
1460  OUString* pNames = aSubSourceNames.getArray();
1461  pNames[0] = rSubNodeName + "/ColumnName";
1462  pNames[1] = rSubNodeName + "/ColumnIndex";
1463  pNames[2] = rSubNodeName + "/IsNumberFormat";
1464  pNames[3] = rSubNodeName + "/IsNumberFormatFromDataBase";
1465  pNames[4] = rSubNodeName + "/NumberFormat";
1466  pNames[5] = rSubNodeName + "/NumberFormatLocale";
1467  return aSubSourceNames;
1468 }
1469 
1470 static OUString lcl_CreateUniqueName(const Sequence<OUString>& aNames)
1471 {
1472  sal_Int32 nIdx = aNames.getLength();
1473  while(true)
1474  {
1475  const OUString sRet = "_" + OUString::number(nIdx++);
1476  if ( comphelper::findValue(aNames, sRet) == -1 )
1477  return sRet; // No match found, return unique name
1478  }
1479 }
1480 
1481 void SwInsertDBColAutoPilot::Notify( const css::uno::Sequence< OUString >& ) {}
1482 
1483 void SwInsertDBColAutoPilot::ImplCommit()
1484 {
1485  Sequence <OUString> aNames = GetNodeNames(OUString());
1486  //remove entries that contain this data source + table at first
1487  for(OUString const & nodeName : std::as_const(aNames))
1488  {
1489  Sequence<OUString> aSourceNames(2);
1490  OUString* pSourceNames = aSourceNames.getArray();
1491  pSourceNames[0] = nodeName + "/DataSource";
1492  pSourceNames[1] = nodeName + "/Command";
1493  Sequence<Any> aSourceProperties = GetProperties(aSourceNames);
1494  const Any* pSourceProps = aSourceProperties.getArray();
1495  OUString sSource, sCommand;
1496  pSourceProps[0] >>= sSource;
1497  pSourceProps[1] >>= sCommand;
1498  if(sSource==aDBData.sDataSource && sCommand==aDBData.sCommand)
1499  {
1500  Sequence<OUString> aElements { nodeName };
1501  ClearNodeElements(OUString(), aElements);
1502  }
1503  }
1504 
1505  aNames = GetNodeNames(OUString());
1506  OUString sNewNode = lcl_CreateUniqueName(aNames);
1507  Sequence<OUString> aNodeNames = lcl_createSourceNames(sNewNode);
1508  Sequence<PropertyValue> aValues(aNodeNames.getLength());
1509  PropertyValue* pValues = aValues.getArray();
1510  const OUString* pNodeNames = aNodeNames.getConstArray();
1511  for(sal_Int32 i = 0; i < aNodeNames.getLength(); i++)
1512  {
1513  pValues[i].Name = "/" + pNodeNames[i];
1514  }
1515 
1516  pValues[0].Value <<= aDBData.sDataSource;
1517  pValues[1].Value <<= aDBData.sCommand;
1518  pValues[2].Value <<= aDBData.nCommandType;
1519  pValues[3].Value <<= m_xEdDbText->get_text();
1520 
1521  OUString sTmp;
1522  const sal_Int32 nCnt = m_xLbTableCol->n_children();
1523  for( sal_Int32 n = 0; n < nCnt; ++n )
1524  sTmp += m_xLbTableCol->get_text(n) + "\x0a";
1525 
1526  if (!sTmp.isEmpty())
1527  pValues[4].Value <<= sTmp;
1528 
1529  if( sNoTmpl != (sTmp = m_xLbDbParaColl->get_active_text()) )
1530  pValues[5].Value <<= sTmp;
1531 
1532  if (m_xTAutoFormat)
1533  pValues[6].Value <<= m_xTAutoFormat->GetName();
1534 
1535  pValues[7].Value <<= m_xRbAsTable->get_active();
1536  pValues[8].Value <<= m_xRbAsField->get_active();
1537  pValues[9].Value <<= m_xCbTableHeadon->get_active();
1538  pValues[10].Value <<= m_xRbHeadlEmpty->get_active();
1539 
1540  SetSetProperties(OUString(), aValues);
1541 
1542  sNewNode += "/ColumnSet";
1543 
1544  LanguageType ePrevLang(0xffff);
1545 
1546  SvNumberFormatter& rNFormatr = *pView->GetWrtShell().GetNumberFormatter();
1547  for(size_t nCol = 0; nCol < aDBColumns.size(); nCol++)
1548  {
1549  SwInsDBColumn* pColumn = aDBColumns[nCol].get();
1550  OUString sColumnInsertNode(sNewNode + "/__");
1551  if( nCol < 10 )
1552  sColumnInsertNode += "00";
1553  else if( nCol < 100 )
1554  sColumnInsertNode += "0";
1555  sColumnInsertNode += OUString::number( nCol );
1556 
1557  const Sequence <OUString> aSubNodeNames = lcl_CreateSubNames(sColumnInsertNode);
1558  Sequence<PropertyValue> aSubValues(aSubNodeNames.getLength());
1559  PropertyValue* pSubValues = aSubValues.getArray();
1560  sal_Int32 i = 0;
1561 
1562  for( const OUString& rSubNodeName : aSubNodeNames)
1563  pSubValues[i++].Name = rSubNodeName;
1564  pSubValues[0].Value <<= pColumn->sColumn;
1565  pSubValues[1].Value <<= i;
1566  pSubValues[2].Value <<= pColumn->bHasFormat;
1567  pSubValues[3].Value <<= pColumn->bIsDBFormat;
1568 
1569  SwStyleNameMapper::FillUIName( RES_POOLCOLL_STANDARD, sTmp );
1570  const SvNumberformat* pNF = rNFormatr.GetEntry( pColumn->nUsrNumFormat );
1571  LanguageType eLang;
1572  if( pNF )
1573  {
1574  pSubValues[4].Value <<= pNF->GetFormatstring();
1575  eLang = pNF->GetLanguage();
1576  }
1577  else
1578  {
1579  pSubValues[4].Value <<= sTmp;
1580  eLang = GetAppLanguage();
1581  }
1582 
1583  OUString sPrevLang;
1584  if( eLang != ePrevLang )
1585  {
1586  sPrevLang = LanguageTag::convertToBcp47( eLang );
1587  ePrevLang = eLang;
1588  }
1589 
1590  pSubValues[5].Value <<= sPrevLang;
1591  SetSetProperties(sNewNode, aSubValues);
1592  }
1593 }
1594 
1595 void SwInsertDBColAutoPilot::Load()
1596 {
1597  const Sequence<OUString> aNames = GetNodeNames(OUString());
1598  SvNumberFormatter& rNFormatr = *pView->GetWrtShell().GetNumberFormatter();
1599  for(OUString const & nodeName : aNames)
1600  {
1601  //search for entries with the appropriate data source and table
1602  Sequence<OUString> aSourceNames = lcl_createSourceNames(nodeName);
1603 
1604  Sequence< Any> aDataSourceProps = GetProperties(aSourceNames);
1605  const Any* pDataSourceProps = aDataSourceProps.getConstArray();
1606  OUString sSource, sCommand;
1607  sal_Int16 nCommandType;
1608  pDataSourceProps[0] >>= sSource;
1609  pDataSourceProps[1] >>= sCommand;
1610  pDataSourceProps[2] >>= nCommandType;
1611  if(sSource == aDBData.sDataSource && sCommand == aDBData.sCommand)
1612  {
1613  std::unique_ptr<DB_ColumnConfigData> pNewData(new DB_ColumnConfigData);
1614 
1615  pDataSourceProps[3] >>= pNewData->sEdit;
1616  pDataSourceProps[4] >>= pNewData->sTableList;
1617  pDataSourceProps[5] >>= pNewData->sTmplNm;
1618  pDataSourceProps[6] >>= pNewData->sTAutoFormatNm;
1619  if(pDataSourceProps[7].hasValue())
1620  pNewData->bIsTable = *o3tl::doAccess<bool>(pDataSourceProps[7]);
1621  if(pDataSourceProps[8].hasValue())
1622  pNewData->bIsField = *o3tl::doAccess<bool>(pDataSourceProps[8]);
1623  if(pDataSourceProps[9].hasValue())
1624  pNewData->bIsHeadlineOn = *o3tl::doAccess<bool>(pDataSourceProps[9]);
1625  if(pDataSourceProps[10].hasValue())
1626  pNewData->bIsEmptyHeadln = *o3tl::doAccess<bool>(pDataSourceProps[10]);
1627 
1628  const OUString sSubNodeName(nodeName + "/ColumnSet/");
1629  const Sequence <OUString> aSubNames = GetNodeNames(sSubNodeName);
1630  for(const OUString& rSubName : aSubNames)
1631  {
1632  Sequence <OUString> aSubNodeNames =
1633  lcl_CreateSubNames(sSubNodeName + rSubName);
1634  Sequence< Any> aSubProps = GetProperties(aSubNodeNames);
1635  const Any* pSubProps = aSubProps.getConstArray();
1636 
1637  OUString sColumn;
1638  pSubProps[0] >>= sColumn;
1639  // check for existence of the loaded column name
1640  bool bFound = false;
1641  for(size_t nRealColumn = 0; nRealColumn < aDBColumns.size(); ++nRealColumn)
1642  {
1643  if(aDBColumns[nRealColumn]->sColumn == sColumn)
1644  {
1645  bFound = true;
1646  break;
1647  }
1648  }
1649  if(!bFound)
1650  continue;
1651  sal_Int16 nIndex = 0;
1652  pSubProps[1] >>= nIndex;
1653  std::unique_ptr<SwInsDBColumn> pInsDBColumn(new SwInsDBColumn(sColumn));
1654  if(pSubProps[2].hasValue())
1655  pInsDBColumn->bHasFormat = *o3tl::doAccess<bool>(pSubProps[2]);
1656  if(pSubProps[3].hasValue())
1657  pInsDBColumn->bIsDBFormat = *o3tl::doAccess<bool>(pSubProps[3]);
1658 
1659  pSubProps[4] >>= pInsDBColumn->sUsrNumFormat;
1660  OUString sNumberFormatLocale;
1661  pSubProps[5] >>= sNumberFormatLocale;
1662 
1663  /* XXX Earlier versions wrote a Country-Language string in
1664  * SwInsertDBColAutoPilot::Commit() that here was read as
1665  * Language-Country with 2 characters copied to language,
1666  * 1 character separator and unconditionally 2 characters read
1667  * as country. So for 'DE-de' and locales that have similar
1668  * case-insensitive equal language/country combos that may have
1669  * worked, for all others not. FIXME if you need to read old
1670  * data that you were never able to read before. */
1671  pInsDBColumn->eUsrNumFormatLng = LanguageTag::convertToLanguageType( sNumberFormatLocale );
1672 
1673  pInsDBColumn->nUsrNumFormat = rNFormatr.GetEntryKey( pInsDBColumn->sUsrNumFormat,
1674  pInsDBColumn->eUsrNumFormatLng );
1675 
1676  pNewData->aDBColumns.insert(std::move(pInsDBColumn));
1677  }
1678  OUString sTmp( pNewData->sTableList );
1679  if( !sTmp.isEmpty() )
1680  {
1681  sal_Int32 n = 0;
1682  do {
1683  const OUString sEntry( sTmp.getToken( 0, '\x0a', n ) );
1684  //preselect column - if they still exist!
1685  if (m_xLbTableDbColumn->find_text(sEntry) != -1)
1686  {
1687  m_xLbTableCol->append_text(sEntry);
1688  m_xLbTableDbColumn->remove_text(sEntry);
1689  }
1690  } while( n>=0 );
1691 
1692  if (!m_xLbTableDbColumn->n_children())
1693  {
1694  m_xIbDbcolAllTo->set_sensitive( false );
1695  m_xIbDbcolOneTo->set_sensitive( false );
1696  }
1697  m_xIbDbcolOneFrom->set_sensitive(true);
1698  m_xIbDbcolAllFrom->set_sensitive(true);
1699  }
1700  m_xEdDbText->set_text( pNewData->sEdit );
1701 
1702  sTmp = pNewData->sTmplNm;
1703  if( !sTmp.isEmpty() )
1704  m_xLbDbParaColl->set_active_text(sTmp);
1705  else
1706  m_xLbDbParaColl->set_active(0);
1707 
1708  m_xTAutoFormat.reset();
1709  sTmp = pNewData->sTAutoFormatNm;
1710  if( !sTmp.isEmpty() )
1711  {
1712  // then load the AutoFormat file and look for Autoformat first
1713  SwTableAutoFormatTable aAutoFormatTable;
1714  aAutoFormatTable.Load();
1715  for( size_t nAutoFormat = aAutoFormatTable.size(); nAutoFormat; )
1716  if( sTmp == aAutoFormatTable[ --nAutoFormat ].GetName() )
1717  {
1718  m_xTAutoFormat.reset(new SwTableAutoFormat(aAutoFormatTable[nAutoFormat]));
1719  break;
1720  }
1721  }
1722 
1723  m_xRbAsTable->set_active( pNewData->bIsTable );
1724  m_xRbAsField->set_active( pNewData->bIsField );
1725  m_xRbAsText->set_active( !pNewData->bIsTable && !pNewData->bIsField );
1726 
1727  m_xCbTableHeadon->set_active( pNewData->bIsHeadlineOn );
1728  m_xRbHeadlColnms->set_active( !pNewData->bIsEmptyHeadln );
1729  m_xRbHeadlEmpty->set_active( pNewData->bIsEmptyHeadln );
1730  HeaderHdl(*m_xCbTableHeadon);
1731 
1732  // now copy the user defined Numberformat strings to the
1733  // Shell. Then only these are available as ID
1734  for( size_t n = 0; n < aDBColumns.size() ; ++n )
1735  {
1736  SwInsDBColumn& rSet = *aDBColumns[ n ];
1737  for( size_t m = 0; m < pNewData->aDBColumns.size() ; ++m )
1738  {
1739  SwInsDBColumn& rGet = *pNewData->aDBColumns[ m ];
1740  if(rGet.sColumn == rSet.sColumn)
1741  {
1742  if( rGet.bHasFormat && !rGet.bIsDBFormat )
1743  {
1744  rSet.bIsDBFormat = false;
1745  rSet.nUsrNumFormat = rNFormatr.GetEntryKey( rGet.sUsrNumFormat,
1746  rGet.eUsrNumFormatLng );
1747  if( NUMBERFORMAT_ENTRY_NOT_FOUND == rSet.nUsrNumFormat )
1748  {
1749  sal_Int32 nCheckPos;
1750  SvNumFormatType nType;
1751  rNFormatr.PutEntry( rGet.sUsrNumFormat, nCheckPos, nType,
1752  rSet.nUsrNumFormat, rGet.eUsrNumFormatLng );
1753  }
1754  }
1755  break;
1756  }
1757  }
1758  }
1759 
1760  // when the cursor is inside of a table, table must NEVER be selectable
1761  if( !m_xRbAsTable->get_sensitive() && m_xRbAsTable->get_active() )
1762  m_xRbAsField->set_active(true);
1763  break;
1764  }
1765  }
1766 }
1767 
1768 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */
SwInsertDBColAutoPilot::m_xFormatFrame
std::unique_ptr< weld::Frame > m_xFormatFrame
Definition: dbinsdlg.hxx:102
DB_Column::pField
SwField * pField
Definition: dbinsdlg.cxx:121
fnParaEnd
SwMoveFnCollection const & fnParaEnd
Definition: paminit.cxx:47
fnTableEnd
SwMoveFnCollection const & fnTableEnd
Definition: paminit.cxx:53
SwInsDBColumn::sColumn
OUString sColumn
Definition: dbinsdlg.hxx:56
SwDBData::nCommandType
sal_Int32 nCommandType
Definition: swdbdata.hxx:32
SwWrtShell::SplitNode
void SplitNode(bool bAutoFormat=false)
Definition: wrtsh1.cxx:999
lcl_InsTextInArr
static void lcl_InsTextInArr(const OUString &rText, DB_Columns &rColArr)
Definition: dbinsdlg.cxx:827
SwCursorShell::IsAutoUpdateCells
bool IsAutoUpdateCells() const
Definition: crsrsh.hxx:809
SwInsertDBColAutoPilot::m_xLbDbFormatFromUsr
std::unique_ptr< NumFormatListBox > m_xLbDbFormatFromUsr
Definition: dbinsdlg.hxx:105
SwFormat::GetCol
const SwFormatCol & GetCol(bool=true) const
Definition: fmtclds.hxx:168
SwTextFormatColl
Represents the style of a paragraph.
Definition: fmtcol.hxx:55
SwInsDBColumn::bIsDBFormat
bool bIsDBFormat
Definition: dbinsdlg.hxx:61
SwColumns
std::vector< SwColumn > SwColumns
Definition: fmtclds.hxx:57
SwEditShell::GetTextCollFromPool
SwTextFormatColl * GetTextCollFromPool(sal_uInt16 nId)
Definition: edfmt.cxx:123
DB_ColumnConfigData::bIsTable
bool bIsTable
Definition: dbinsdlg.cxx:165
CollatorWrapper::compareString
sal_Int32 compareString(const OUString &s1, const OUString &s2) const
SvxBoxInfoItem::SetDefDist
void SetDefDist(sal_uInt16 nNew)
SwDBFormatData::aNullDate
css::util::Date aNullDate
Definition: dbmgr.hxx:65
SfxStyleSheetBasePool::First
SfxStyleSheetBase * First()
DB_Column::Type
Type
Definition: dbinsdlg.cxx:117
GotoPrevTable
bool GotoPrevTable(SwPaM &rCurrentCursor, SwMoveFnCollection const &fnPosTable, bool bInReadOnly)
Definition: trvltbl.cxx:480
SwCursorShell::SetAutoUpdateCells
void SetAutoUpdateCells(bool bFlag)
Definition: crsrsh.hxx:810
GoCurrPara
bool GoCurrPara(SwPaM &rPam, SwMoveFnCollection const &aPosPara)
Definition: pam.cxx:951
SfxAbstractDialog::GetOutputItemSet
virtual const SfxItemSet * GetOutputItemSet() const =0
GetValue
std::string GetValue
SwStyleNameMapper::FillUIName
static void FillUIName(const OUString &rName, OUString &rFillName, SwGetPoolIdFromName)
Definition: SwStyleNameMapper.cxx:286
comphelper::findValue
sal_Int32 findValue(const css::uno::Sequence< T1 > &_rList, const T2 &_rValue)
SwCursorShell::IsSttPara
bool IsSttPara() const
Definition: crsrsh.cxx:1082
SvxBoxInfoItem::SetMinDist
void SetMinDist(bool bNew)
SwFEShell::GetAnyCurRect
const SwRect & GetAnyCurRect(CurRectType eType, const Point *pPt=nullptr, const css::uno::Reference< css::embed::XEmbeddedObject > &=css::uno::Reference< css::embed::XEmbeddedObject >()) const
Definition: fews.cxx:90
SvNumberFormatter::GetOutputString
void GetOutputString(const double &fOutNumber, sal_uInt32 nFIndex, OUString &sOutString, Color **ppColor, bool bUseStarFormat=false)
LanguageTag::convertToLanguageType
static LanguageType convertToLanguageType(const css::lang::Locale &rLocale, bool bResolveSystem=true)
SwuiGetUITableAttrRange
SW_DLLPUBLIC const sal_uInt16 * SwuiGetUITableAttrRange()
Definition: tabsh.cxx:132
LanguageTag::convertToBcp47
static OUString convertToBcp47(LanguageType nLangID)
cDBFieldStart
const char cDBFieldStart
Definition: dbinsdlg.cxx:111
AbstractSwAutoFormatDlg::FillAutoFormatOfIndex
virtual std::unique_ptr< SwTableAutoFormat > FillAutoFormatOfIndex() const =0
SwDBData::sDataSource
OUString sDataSource
Definition: swdbdata.hxx:30
SwFEShell::GetCurColNum
sal_uInt16 GetCurColNum(SwGetCurColNumPara *pPara=nullptr) const
The ruler needs some information too.
Definition: fews.cxx:682
ConfigItemMode
ConfigItemMode
SvxBoxInfoItem::SetTable
void SetTable(bool bNew)
SwField
Base class of all fields.
Definition: fldbas.hxx:280
SwInsertDBColAutoPilot::m_xLbTextDbColumn
std::unique_ptr< weld::TreeView > m_xLbTextDbColumn
Definition: dbinsdlg.hxx:100
DB_ColumnConfigData::sTAutoFormatNm
OUString sTAutoFormatNm
Definition: dbinsdlg.cxx:164
fnParaStart
SwMoveFnCollection const & fnParaStart
Definition: paminit.cxx:46
SvNumberFormatter::GetType
SvNumFormatType GetType(sal_uInt32 nFIndex) const
DB_Column::DB_Column
DB_Column(const OUString &rText)
Definition: dbinsdlg.cxx:131
SwField::CopyField
std::unique_ptr< SwField > CopyField() const
Definition: fldbas.cxx:424
nId
sal_Int16 nId
SwInsDBColumn::operator<
bool operator<(const SwInsDBColumn &rCmp) const
Definition: dbinsdlg.cxx:180
SwEditShell::EndUndo
SwUndoId EndUndo(SwUndoId eUndoId=SwUndoId::EMPTY, const SwRewriter *pRewriter=nullptr)
Closes parenthesis of nUndoId, not used by UI.
Definition: edws.cxx:233
o3tl::sorted_vector::find
const_iterator find(const Value &x) const
DB_Columns
std::vector< std::unique_ptr< DB_Column > > DB_Columns
Definition: dbinsdlg.hxx:50
SwAbstractDialogFactory::CreateSwTableTabDlg
virtual VclPtr< SfxAbstractTabDialog > CreateSwTableTabDlg(weld::Window *pParent, const SfxItemSet *pItemSet, SwWrtShell *pSh)=0
DB_Column::Type::COL_TEXT
FN_PARAM_TABLE_NAME
#define FN_PARAM_TABLE_NAME
Definition: cmdid.h:757
SwEditShell::DoUndo
void DoUndo(bool bOn=true)
Undo.
Definition: edws.cxx:199
SwInsertDBColAutoPilot::m_xPbTableAutofmt
std::unique_ptr< weld::Button > m_xPbTableAutofmt
Definition: dbinsdlg.hxx:124
DB_ColumnConfigData::bIsField
bool bIsField
Definition: dbinsdlg.cxx:165
SwInsertDBColAutoPilot::m_xCbTableHeadon
std::unique_ptr< weld::CheckButton > m_xCbTableHeadon
Definition: dbinsdlg.hxx:120
SwInsertDBColAutoPilot::m_xRbAsText
std::unique_ptr< weld::RadioButton > m_xRbAsText
Definition: dbinsdlg.hxx:95
VclAbstractDialog::Execute
virtual short Execute()=0
DB_Column::DB_Column
DB_Column(const SwInsDBColumn &rInfo, sal_uInt32 nFormat_)
Definition: dbinsdlg.cxx:137
DB_ColumnConfigData::sEdit
OUString sEdit
Definition: dbinsdlg.cxx:161
MIN_BORDER_DIST
#define MIN_BORDER_DIST
Definition: swtypes.hxx:74
SwEditShell::EndAllAction
void EndAllAction()
Definition: edws.cxx:96
DB_Column::eColType
enum DB_Column::Type eColType
SwInsertDBColAutoPilot::Notify
virtual void Notify(const css::uno::Sequence< OUString > &aPropertyNames) override
Definition: dbinsdlg.cxx:1481
SvNumberformat::GetFormatstring
const OUString & GetFormatstring() const
SwCursorShell::GoNextCell
bool GoNextCell(bool bAppendLine=true)
set cursor into next/previous cell
Definition: trvltbl.cxx:38
SwInsertDBColAutoPilot::m_xLbTableCol
std::unique_ptr< weld::TreeView > m_xLbTableCol
Definition: dbinsdlg.hxx:119
SwTabCols::Insert
void Insert(long nValue, bool bValue, size_t nPos)
Definition: tabcol.cxx:69
SwWrtShell::DelRight
bool DelRight()
Definition: delete.cxx:285
SwView::GetWrtShell
SwWrtShell & GetWrtShell() const
Definition: view.hxx:400
GotoCurrTable
bool GotoCurrTable(SwPaM &rCurrentCursor, SwMoveFnCollection const &fnPosTable, bool bInReadOnly)
Definition: trvltbl.cxx:632
SwEditShell::GetCurLang
LanguageType GetCurLang() const
Definition: edattr.cxx:808
SwWrtShell
Used by the UI to modify the document model.
Definition: wrtsh.hxx:90
FN_PARAM_TABLE_HEADLINE
#define FN_PARAM_TABLE_HEADLINE
Definition: cmdid.h:758
Value
Value
DB_ColumnConfigData::DB_ColumnConfigData
DB_ColumnConfigData()
Definition: dbinsdlg.cxx:173
DB_ColumnConfigData::aDBColumns
SwInsDBColumns aDBColumns
Definition: dbinsdlg.cxx:160
SwInsertDBColAutoPilot::m_xEdDbText
std::unique_ptr< weld::TextView > m_xEdDbText
Definition: dbinsdlg.hxx:109
sal_Unicode
sal_uInt16 sal_Unicode
SwEditShell::InsertTable
const SwTable & InsertTable(const SwInsertTableOptions &rInsTableOpts, sal_uInt16 nRows, sal_uInt16 nCols, const SwTableAutoFormat *pTAFormat=nullptr)
Definition: edtab.cxx:100
weld::TreeView::get_selected_text
virtual OUString get_selected_text() const =0
DB_ColumnConfigData::sTableList
OUString sTableList
Definition: dbinsdlg.cxx:162
SfxStyleSheetBase::GetName
const OUString & GetName() const
SwInsertDBColAutoPilot::SplitTextToColArr
bool SplitTextToColArr(const OUString &rText, DB_Columns &rColArr, bool bInsField)
Definition: dbinsdlg.cxx:845
utl::ConfigItem::SetSetProperties
bool SetSetProperties(const OUString &rNode, const css::uno::Sequence< css::beans::PropertyValue > &rValues)
SwInsDBColumn::sUsrNumFormat
OUString sUsrNumFormat
Definition: dbinsdlg.hxx:56
SwInsertDBColAutoPilot::pTableSet
std::unique_ptr< SfxItemSet > pTableSet
Definition: dbinsdlg.hxx:89
SwFEShell::SetTableStyle
bool SetTableStyle(const OUString &rStyleName)
Set table style of the current table.
Definition: fetab.cxx:1167
NUMBERFORMAT_ENTRY_NOT_FOUND
constexpr sal_uInt32 NUMBERFORMAT_ENTRY_NOT_FOUND
SwFormat::GetName
const OUString & GetName() const
Definition: format.hxx:111
DB_Column::Type::COL_FIELD
SwStyleNameMapper::GetPoolIdFromUIName
static SW_DLLPUBLIC sal_uInt16 GetPoolIdFromUIName(const OUString &rName, SwGetPoolIdFromName)
Definition: SwStyleNameMapper.cxx:435
SwInsertDBColAutoPilot::sNoTmpl
OUString const sNoTmpl
Definition: dbinsdlg.hxx:84
SwAbstractDialogFactory::CreateSwAutoFormatDlg
virtual VclPtr< AbstractSwAutoFormatDlg > CreateSwAutoFormatDlg(weld::Window *pParent, SwWrtShell *pShell, bool bSetAutoFormat=true, const SwTableAutoFormat *pSelFormat=nullptr)=0
DB_ColumnConfigData::bIsHeadlineOn
bool bIsHeadlineOn
Definition: dbinsdlg.cxx:165
o3tl::strong_int< sal_uInt16, struct LanguageTypeTag >
SwViewShell::GetDoc
SwDoc * GetDoc() const
Definition: viewsh.hxx:284
SwViewShell::getIDocumentMarkAccess
const IDocumentMarkAccess * getIDocumentMarkAccess() const
Provides access to the document bookmark interface.
Definition: viewsh.cxx:2595
o3tl::sorted_vector::size
size_type size() const
SwDBFormatData::aLocale
css::lang::Locale aLocale
Definition: dbmgr.hxx:67
SwInsDBColumn::eUsrNumFormatLng
LanguageType eUsrNumFormatLng
Definition: dbinsdlg.hxx:59
SwWrtShell::Insert
void Insert(SwField const &, SwPaM *pAnnotationRange=nullptr)
Definition: wrtsh2.cxx:71
SvNumberFormatter::PutEntry
bool PutEntry(OUString &rString, sal_Int32 &nCheckPos, SvNumFormatType &nType, sal_uInt32 &nKey, LanguageType eLnge=LANGUAGE_DONTKNOW)
SwDBManager::createCursor
static css::uno::Reference< css::sdbc::XResultSet > createCursor(const OUString &_sDataSourceName, const OUString &_sCommand, sal_Int32 _nCommandType, const css::uno::Reference< css::sdbc::XConnection > &_xConnection, const SwView *pView)
creates a RowSet, which must be disposed after use.
Definition: dbmgr.cxx:3155
SwEditShell::SetTableBoxFormulaAttrs
void SetTableBoxFormulaAttrs(const SfxItemSet &rSet)
Definition: edtab.cxx:343
RES_BACKGROUND
#define RES_BACKGROUND
Definition: hintids.hxx:212
IDocumentMarkAccess::deleteMark
virtual std::unique_ptr< ILazyDeleter > deleteMark(const IDocumentMarkAccess::const_iterator_t &ppMark)=0
Deletes a mark.
IMPL_LINK_NOARG
IMPL_LINK_NOARG(SwInsertDBColAutoPilot, TableFormatHdl, weld::Button &, void)
Definition: dbinsdlg.cxx:624
GetFrameWeld
weld::Window * GetFrameWeld(const SfxFrame *pFrame)
Definition: dialoghelp.cxx:20
utl::ConfigItem::ClearNodeElements
bool ClearNodeElements(const OUString &rNode, css::uno::Sequence< OUString > const &rElements)
SwViewShell::GetAttrPool
const SfxItemPool & GetAttrPool() const
Definition: viewsh.hxx:614
DB_Column::pText
OUString *const pText
Definition: dbinsdlg.cxx:120
SwEditShell::SetTextFormatColl
void SetTextFormatColl(SwTextFormatColl *, const bool bResetListAttrs=false)
Add 2nd optional parameter - see also
Definition: edfcol.cxx:2179
TOOLS_WARN_EXCEPTION
#define TOOLS_WARN_EXCEPTION(area, stream)
CurRectType::PagePrt
Rect of current PrtArea of page.
SwWrtShell::HasSelection
bool HasSelection() const
Definition: wrtsh.hxx:141
SW_MOD
#define SW_MOD()
Definition: swmodule.hxx:256
SwFormatCol::GetColumns
const SwColumns & GetColumns() const
Definition: fmtclds.hxx:112
SwEditShell::InsertFieldType
SwFieldType * InsertFieldType(const SwFieldType &)
insert field type
Definition: edfld.cxx:346
SwFEShell::SetRowsToRepeat
void SetRowsToRepeat(sal_uInt16 nNumOfRows)
Definition: fetab.cxx:994
SwInsertDBColAutoPilot::m_xPbTableFormat
std::unique_ptr< weld::Button > m_xPbTableFormat
Definition: dbinsdlg.hxx:123
swui::GetFactory
SwAbstractDialogFactory & GetFactory()
Definition: swuiexp.cxx:57
diagnose_ex.h
SwInsertDBColAutoPilot::m_xRbDbFormatFromUsr
std::unique_ptr< weld::RadioButton > m_xRbDbFormatFromUsr
Definition: dbinsdlg.hxx:104
DB_ColumnConfigData
Definition: dbinsdlg.cxx:158
i
int i
nType
QPRO_FUNC_TYPE const nType
SwInsertDBColAutoPilot::m_xRbAsField
std::unique_ptr< weld::RadioButton > m_xRbAsField
Definition: dbinsdlg.hxx:94
SwInsertDBColAutoPilot::aDBColumns
SwInsDBColumns aDBColumns
Definition: dbinsdlg.hxx:81
SwCursorShell::SetBookmark
::sw::mark::IMark * SetBookmark(const vcl::KeyCode &, const OUString &rName, IDocumentMarkAccess::MarkType eMark=IDocumentMarkAccess::MarkType::BOOKMARK)
Definition: crbm.cxx:80
HTMLMODE_ON
HTMLMODE_ON
SwFormatCol::CalcColWidth
sal_uInt16 CalcColWidth(sal_uInt16 nCol, sal_uInt16 nAct) const
Calculates current width of column nCol.
Definition: atrfrm.cxx:966
GetHtmlMode
sal_uInt16 GetHtmlMode(const SwDocShell *pShell)
Definition: viewopt.cxx:340
SwTableAutoFormatTable::size
size_t size() const
Definition: tblafmt.cxx:910
DB_Column::pColInfo
const SwInsDBColumn * pColInfo
Definition: dbinsdlg.cxx:124
DB_Column::Type::FILLTEXT
SwEditShell::StartUndo
SwUndoId StartUndo(SwUndoId eUndoId=SwUndoId::EMPTY, const SwRewriter *pRewriter=nullptr)
Undo: set up Undo parenthesis, return nUndoId of this parenthesis.
Definition: edws.cxx:222
SwDocShell::GetStyleSheetPool
virtual SfxStyleSheetBasePool * GetStyleSheetPool() override
For Style PI.
Definition: docsh.cxx:1165
DB_Column::~DB_Column
~DB_Column()
Definition: dbinsdlg.cxx:149
SwEditShell::GetUniqueTableName
OUString GetUniqueTableName() const
Definition: edfmt.cxx:111
utl::ConfigItem::GetProperties
css::uno::Sequence< css::uno::Any > GetProperties(const css::uno::Sequence< OUString > &rNames)
SvNumFormatType
SvNumFormatType
SwCursorShell::SetMark
void SetMark()
Definition: crsrsh.hxx:879
SwInsertDBColAutoPilot::m_xHeadFrame
std::unique_ptr< weld::Frame > m_xHeadFrame
Definition: dbinsdlg.hxx:97
DB_Column
Definition: dbinsdlg.cxx:115
SwInsertDBColAutoPilot::aDBData
const SwDBData aDBData
Definition: dbinsdlg.hxx:82
DB_ColumnConfigData::operator=
DB_ColumnConfigData & operator=(DB_ColumnConfigData const &)=delete
o3tl::sorted_vector::end
const_iterator end() const
SwResId
OUString SwResId(const char *pId)
Definition: swmodule.cxx:190
RES_BOXATR_VALUE
#define RES_BOXATR_VALUE
Definition: hintids.hxx:265
lcl_createSourceNames
static Sequence< OUString > lcl_createSourceNames(const OUString &rNodeName)
Definition: dbinsdlg.cxx:1439
SwTabCols::SetRightMax
void SetRightMax(long nNew)
Definition: tabcol.hxx:84
SwView::GetDocShell
SwDocShell * GetDocShell()
Definition: view.cxx:1128
SwEditShell::GetTableFormat
SwFrameFormat * GetTableFormat()
Definition: edws.cxx:182
SwInsertDBColAutoPilot::DataToDoc
void DataToDoc(const css::uno::Sequence< css::uno::Any > &rSelection, css::uno::Reference< css::sdbc::XDataSource > const &rxSource, css::uno::Reference< css::sdbc::XConnection > const &xConnection, css::uno::Reference< css::sdbc::XResultSet > const &xResultSet)
Definition: dbinsdlg.cxx:921
DB_Column::DB_Column
DB_Column(const SwInsDBColumn &rInfo, SwDBField &rField)
Definition: dbinsdlg.cxx:143
DB_ColumnConfigData::bIsEmptyHeadln
bool bIsEmptyHeadln
Definition: dbinsdlg.cxx:165
SwEditShell::AppendUndoForInsertFromDB
void AppendUndoForInsertFromDB(bool bIsTable)
Set up InsertDB as table Undo.
Definition: edtab.cxx:526
getDefaultNumberFormat
sal_Int32 getDefaultNumberFormat(const Reference< XPropertySet > &_xColumn, const Reference< XNumberFormatTypes > &_xTypes, const Locale &_rLocale)
SwViewOption::GetTableDest
sal_uInt8 GetTableDest() const
Definition: viewopt.hxx:509
SwWrtShell::GotoMark
void GotoMark(const ::sw::mark::IMark *const pMark)
Definition: wrtsh3.cxx:138
SwInsertDBColAutoPilot::m_xRbHeadlColnms
std::unique_ptr< weld::RadioButton > m_xRbHeadlColnms
Definition: dbinsdlg.hxx:121
fnTableStart
SwMoveFnCollection const & fnTableStart
Definition: paminit.cxx:52
SwColumn::GetRight
sal_uInt16 GetRight() const
Definition: fmtclds.hxx:52
FN_TABLE_REP
#define FN_TABLE_REP
Definition: cmdid.h:327
SwInsDBColumn::nDBNumFormat
sal_Int32 nDBNumFormat
Definition: dbinsdlg.hxx:57
SvNumberFormatter::GetEntry
const SvNumberformat * GetEntry(sal_uInt32 nKey) const
SwViewShell::GetViewOptions
const SwViewOption * GetViewOptions() const
Definition: viewsh.hxx:426
SwRect::Width
void Width(long nNew)
Definition: swrect.hxx:185
SwCursorShell::MoveTable
bool MoveTable(SwWhichTable, SwMoveFnCollection const &)
Definition: trvltbl.cxx:681
SwInsertDBColAutoPilot::m_xLbDbParaColl
std::unique_ptr< weld::ComboBox > m_xLbDbParaColl
Definition: dbinsdlg.hxx:111
SfxStyleSheetBasePool::Next
SfxStyleSheetBase * Next()
USHRT_MAX
const o3tl::enumarray< SvxAdjust, unsigned short > aSvxToUnoAdjust USHRT_MAX
Definition: unosett.cxx:261
SwInsertDBColAutoPilot::SwInsertDBColAutoPilot
SwInsertDBColAutoPilot(SwView &rView, css::uno::Reference< css::sdbc::XDataSource > const &rxSource, css::uno::Reference< css::sdbcx::XColumnsSupplier > const &xColSupp, const SwDBData &rData)
Definition: dbinsdlg.cxx:185
SwInsertDBColAutoPilot::m_xIbDbcolAllTo
std::unique_ptr< weld::Button > m_xIbDbcolAllTo
Definition: dbinsdlg.hxx:114
DB_Column::nFormat
sal_uInt32 const nFormat
Definition: dbinsdlg.cxx:122
lcl_CreateSubNames
static Sequence< OUString > lcl_CreateSubNames(const OUString &rSubNodeName)
Definition: dbinsdlg.cxx:1457
SwEditShell::FindTextFormatCollByName
SwTextFormatColl * FindTextFormatCollByName(const OUString &rName) const
Definition: edfmt.cxx:154
GetAppLanguage
LanguageType GetAppLanguage()
Definition: init.cxx:729
RET_OK
RET_OK
ItemSetToTableParam
SW_DLLPUBLIC void ItemSetToTableParam(const SfxItemSet &rSet, SwWrtShell &rSh)
Definition: tabsh.cxx:278
DB_Column::DB_Column
DB_Column()
Definition: dbinsdlg.cxx:126
SwInsertDBColAutoPilot::m_xLbTableDbColumn
std::unique_ptr< weld::TreeView > m_xLbTableDbColumn
Definition: dbinsdlg.hxx:99
SwInsertDBColAutoPilot::ImplCommit
virtual void ImplCommit() override
Definition: dbinsdlg.cxx:1483
nsSwExtendedSubType::SUB_OWN_FMT
const SwExtendedSubType SUB_OWN_FMT
SwDBField: Don't accept formatting from database.
Definition: fldbas.hxx:207
comphelper::getProcessComponentContext
Reference< XComponentContext > getProcessComponentContext()
SwDBManager::GetDBField
static OUString GetDBField(css::uno::Reference< css::beans::XPropertySet > const &xColumnProp, const SwDBFormatData &rDBFormatData, double *pNumber=nullptr)
Definition: dbmgr.cxx:1987
SwDBFormatData::xFormatter
css::uno::Reference< css::util::XNumberFormatter > xFormatter
Definition: dbmgr.hxx:66
SfxStyleSheetBasePool::SetSearchMask
void SetSearchMask(SfxStyleFamily eFam, SfxStyleSearchBits n=SfxStyleSearchBits::All)
SwInsertDBColAutoPilot::m_xIbDbcolAllFrom
std::unique_ptr< weld::Button > m_xIbDbcolAllFrom
Definition: dbinsdlg.hxx:117
SwColumn
ColumnDescriptor.
Definition: fmtclds.hxx:33
SwInsertDBColAutoPilot::~SwInsertDBColAutoPilot
virtual ~SwInsertDBColAutoPilot() override
Definition: dbinsdlg.cxx:404
SwCursorShell::ClearMark
void ClearMark()
Definition: crsrsh.cxx:926
SvNumberFormatter::GetEntryKey
sal_uInt32 GetEntryKey(const OUString &sStr, LanguageType eLnge=LANGUAGE_DONTKNOW)
SwGetCurColNumPara::pPrtRect
const SwRect * pPrtRect
Definition: fesh.hxx:153
SwColumn::GetLeft
sal_uInt16 GetLeft() const
Definition: fmtclds.hxx:51
utl::ConfigItem::GetNodeNames
css::uno::Sequence< OUString > GetNodeNames(const OUString &rNode)
IMPL_LINK
IMPL_LINK(SwInsertDBColAutoPilot, PageHdl, weld::Button &, rButton, void)
Definition: dbinsdlg.cxx:408
SwInsertDBColAutoPilot::m_xIbDbcolOneFrom
std::unique_ptr< weld::Button > m_xIbDbcolOneFrom
Definition: dbinsdlg.hxx:116
CntUInt32Item::GetValue
sal_uInt32 GetValue() const
RES_BOX
#define RES_BOX
Definition: hintids.hxx:213
SvxBoxInfoItem::SetValid
void SetValid(SvxBoxInfoItemValidFlags nValid, bool bValid=true)
CRSR_SKIP_CHARS
const sal_uInt16 CRSR_SKIP_CHARS
Definition: swcrsr.hxx:63
SwGetCurColNumPara::pFrameFormat
const SwFrameFormat * pFrameFormat
Definition: fesh.hxx:152
cDBFieldEnd
const char cDBFieldEnd
Definition: dbinsdlg.cxx:112
SwInsertDBColAutoPilot::m_xTAutoFormat
std::unique_ptr< SwTableAutoFormat > m_xTAutoFormat
Definition: dbinsdlg.hxx:87
SwInsertDBColAutoPilot::nGBFormatLen
sal_Int32 nGBFormatLen
Definition: dbinsdlg.hxx:91
lcl_CreateUniqueName
static OUString lcl_CreateUniqueName(const Sequence< OUString > &aNames)
Definition: dbinsdlg.cxx:1470
MnemonicGenerator::EraseAllMnemonicChars
static OUString EraseAllMnemonicChars(const OUString &rStr)
SwCursorShell::IsEndPara
bool IsEndPara() const
Definition: crsrsh.cxx:1101
SwInsertDBColAutoPilot::m_xRbHeadlEmpty
std::unique_ptr< weld::RadioButton > m_xRbHeadlEmpty
Definition: dbinsdlg.hxx:122
SwInsDBColumn::nUsrNumFormat
sal_uInt32 nUsrNumFormat
Definition: dbinsdlg.hxx:58
SwEditShell::MakeTextFormatColl
SwTextFormatColl * MakeTextFormatColl(const OUString &rFormatCollName, SwTextFormatColl *pDerivedFrom=nullptr)
Definition: edfcol.cxx:2227
SwEditShell::DoesUndo
bool DoesUndo() const
Definition: edws.cxx:202
SwModuleOptions::GetInsTableFlags
const SwInsertTableOptions & GetInsTableFlags(bool bHTML) const
Definition: modcfg.hxx:301
o3tl::sorted_vector::insert
std::pair< const_iterator, bool > insert(Value &&x)
SwField::SetSubType
virtual void SetSubType(sal_uInt16)
Definition: fldbas.cxx:289
SvNumberFormatsSupplierObj::getNumberFormats
virtual css::uno::Reference< css::util::XNumberFormats > SAL_CALL getNumberFormats() override
SvNumberFormatter::GetNullDate
const Date & GetNullDate() const
SwEditShell::StartAllAction
void StartAllAction()
For all views of this document.
Definition: edws.cxx:85
SwTabCols::SetRight
void SetRight(long nNew)
Definition: tabcol.hxx:83
nPos
sal_Int32 nPos
SwEditShell::GetNumberFormatter
SvNumberFormatter * GetNumberFormatter()
Query NumberFormatter from document.
Definition: editsh.cxx:744
SwDBData::sCommand
OUString sCommand
Definition: swdbdata.hxx:31
DB_ColumnConfigData::sTmplNm
OUString sTmplNm
Definition: dbinsdlg.cxx:163
DB_Column::Type::SPLITPARA
CurRectType::FlyEmbeddedPrt
Rect of PrtArea of FlyFrame.
aStr
aStr
SwFEShell::GetFrameType
FrameTypeFlags GetFrameType(const Point *pPt, bool bStopAtFly) const
For return values see above FrameType.
Definition: fews.cxx:236
SwInsertDBColAutoPilot::m_xRbDbFormatFromDb
std::unique_ptr< weld::RadioButton > m_xRbDbFormatFromDb
Definition: dbinsdlg.hxx:103
SvNumberformat::GetLanguage
LanguageType GetLanguage() const
SwView
Definition: view.hxx:146
RES_BOXATR_FORMAT
#define RES_BOXATR_FORMAT
Definition: hintids.hxx:263
o3tl::sorted_vector< std::unique_ptr< SwInsDBColumn >, o3tl::less_uniqueptr_to< SwInsDBColumn > >::const_iterator
std::vector< std::unique_ptr< SwInsDBColumn > >::const_iterator const_iterator
SwTextFormatColl::GetNextTextFormatColl
SwTextFormatColl & GetNextTextFormatColl() const
Definition: fmtcol.hxx:97
SwInsDBColumn::bHasFormat
bool bHasFormat
Definition: dbinsdlg.hxx:60
GetAppCollator
CollatorWrapper & GetAppCollator()
Definition: init.cxx:741
SvxBoxInfoItem::SetDist
void SetDist(bool bNew)
SwInsertDBColAutoPilot::m_xIbDbcolToEdit
std::unique_ptr< weld::Button > m_xIbDbcolToEdit
Definition: dbinsdlg.hxx:108
SwInsertDBColAutoPilot::m_xIbDbcolOneTo
std::unique_ptr< weld::Button > m_xIbDbcolOneTo
Definition: dbinsdlg.hxx:115
SwTableAutoFormatTable::Load
SAL_DLLPRIVATE bool Load(SvStream &rStream)
Definition: tblafmt.cxx:1041
SwInsertDBColAutoPilot::m_xRbAsTable
std::unique_ptr< weld::RadioButton > m_xRbAsTable
Definition: dbinsdlg.hxx:93
Generated on Mon Nov 18 2019 23:58:53 for LibreOffice Module sw (master) by   doxygen 1.8.10