INTEGRATION: CWS rptwizard01 (1.12.68); FILE MERGED

2008/05/21 10:14:32 lla 1.12.68.3: RESYNC: (1.12-1.13); FILE MERGED
2008/04/14 09:11:53 lla 1.12.68.2: #i86092# handle nullpointer, add TODO
2008/02/14 13:00:48 lla 1.12.68.1: #i86092# changes for new Report Wizard

1 files changed, 363 insertions, 255 deletions

diff --git a/wizards/com/sun/star/wizards/report/DBColumn.java b/wizards/com/sun/star/wizards/report/DBColumn.java
index f0c57b48441b..5c5c31eebabf 100644
--- a/wizards/com/sun/star/wizards/report/DBColumn.java
+++ b/wizards/com/sun/star/wizards/report/DBColumn.java
@@ -7,7 +7,7 @@
  * OpenOffice.org - a multi-platform office productivity suite
  *
  * $RCSfile: DBColumn.java,v $
- * $Revision: 1.13 $
+ * $Revision: 1.14 $
  *
  * This file is part of OpenOffice.org.
  *
@@ -26,13 +26,15 @@
  * <http://www.openoffice.org/license.html>
  * for a copy of the LGPLv3 License.
  *
- ************************************************************************/package com.sun.star.wizards.report;
+ ************************************************************************/
+
+package com.sun.star.wizards.report;
 import com.sun.star.beans.PropertyState;
 import com.sun.star.beans.XPropertySet;
 import com.sun.star.beans.XPropertyState;
 import com.sun.star.container.XNameAccess;
 import com.sun.star.container.XNamed;
-import com.sun.star.lang.IndexOutOfBoundsException;
+// import com.sun.star.lang.IndexOutOfBoundsException;
 import com.sun.star.style.ParagraphAdjust;
 import com.sun.star.table.XCell;
 import com.sun.star.table.XCellRange;
@@ -53,7 +55,8 @@ import com.sun.star.wizards.text.TextTableHandler;
 import com.sun.star.wizards.text.TextFieldHandler;
 
 
-public class DBColumn {
+public class DBColumn
+{
 
     public XCell xValCell;
     public XTextRange xValTextCell;
@@ -79,298 +82,403 @@ public class DBColumn {
     RecordTable CurRecordTable;
     TextTableHandler  oTextTableHandler;
 
-    public DBColumn(TextTableHandler _oTextTableHandler, RecordParser _CurDBMetaData, int i) throws Exception{
-        CurRecordTable = new RecordTable(_oTextTableHandler);
-        initializeRecordTableMembers(CurRecordTable, _oTextTableHandler, _CurDBMetaData, i, false);
-    }
+    public DBColumn(TextTableHandler _oTextTableHandler, RecordParser _CurDBMetaData, int i) throws Exception
+        {
+            CurRecordTable = new RecordTable(_oTextTableHandler);
+            initializeRecordTableMembers(CurRecordTable, _oTextTableHandler, _CurDBMetaData, i, false);
+        }
 
 
-    public DBColumn(RecordTable _CurRecordTable, TextTableHandler _oTextTableHandler, RecordParser _CurDBMetaData, int i,  boolean _bforce) throws Exception{
-        initializeRecordTableMembers(_CurRecordTable, _oTextTableHandler, _CurDBMetaData, i, _bforce);
-    }
+    public DBColumn(RecordTable _CurRecordTable, TextTableHandler _oTextTableHandler, RecordParser _CurDBMetaData, int i,  boolean _bforce) throws Exception
+        {
+            initializeRecordTableMembers(_CurRecordTable, _oTextTableHandler, _CurDBMetaData, i, _bforce);
+        }
 
 
-    public DBColumn(RecordTable _CurRecordTable, TextTableHandler _oTextTableHandler, RecordParser _CurDBMetaData, int i) throws Exception{
-        initializeRecordTableMembers(_CurRecordTable, _oTextTableHandler, _CurDBMetaData, i, false);
-    }
+    public DBColumn(RecordTable _CurRecordTable, TextTableHandler _oTextTableHandler, RecordParser _CurDBMetaData, int i) throws Exception
+        {
+            initializeRecordTableMembers(_CurRecordTable, _oTextTableHandler, _CurDBMetaData, i, false);
+        }
 
 
 
-    private void initializeRecordTableMembers(RecordTable _CurRecordTable, TextTableHandler _oTextTableHandler, RecordParser _CurDBMetaData, int i, boolean _bForce) throws Exception{
-        this.oTextTableHandler = _oTextTableHandler;
-        this.CurDBMetaData = _CurDBMetaData;
-        this.CurRecordTable = _CurRecordTable;
-        bIsGroupColumn = false;
-        if (CurDBMetaData.RecordFieldColumns != null)
-            CurDBField = CurDBMetaData.getFieldColumnByFieldName(CurDBMetaData.RecordFieldColumns[i].FieldName);
-        else
-            CurDBField = CurDBMetaData.getFieldColumnByFieldName(CurDBMetaData.RecordFieldNames[i]);
-        if (_bForce)
-            assignCells(i, true);
-        else{
-            for (int n = 0; n < CurRecordTable.xTableColumns.getCount(); n++){
-                assignCells(n, false);
+    private void initializeRecordTableMembers(RecordTable _CurRecordTable, TextTableHandler _oTextTableHandler, RecordParser _CurDBMetaData, int i, boolean _bForce) throws Exception
+        {
+            this.oTextTableHandler = _oTextTableHandler;
+            this.CurDBMetaData = _CurDBMetaData;
+            this.CurRecordTable = _CurRecordTable;
+            bIsGroupColumn = false;
+            if (CurDBMetaData.RecordFieldColumns != null)
+            {
+                CurDBField = CurDBMetaData.getFieldColumnByFieldName(CurDBMetaData.RecordFieldColumns[i].FieldName);
+            }
+            else
+            {
+                CurDBField = CurDBMetaData.getFieldColumnByFieldName(CurDBMetaData.getRecordFieldName(i));
+            }
+            if (_bForce)
+            {
+                assignCells(i, true);
+            }
+            else
+            {
+                for (int n = 0; n < CurRecordTable.xTableColumns.getCount(); n++)
+                {
+                    assignCells(n, false);
+                }
             }
         }
-    }
-
-    private boolean assignCells(int _nColumn, boolean _bforce){
-    try {
-        XCell xCell = CurRecordTable.xCellRange.getCellByPosition(_nColumn,0);
-        XTextRange xTextCell = (XTextRange) UnoRuntime.queryInterface(XTextRange.class, xCell);
-        String CompString = "Column";
-        XTextCursor xLocCellCursor = TextDocument.createTextCursor(xCell);
-        if (isNameCell(xLocCellCursor, CurDBField.FieldName, CompString) || (_bforce)){
-            xNameCell = xCell;
-            xNameTextCell = xTextCell;
-            xValCell = CurRecordTable.xCellRange.getCellByPosition(_nColumn,1);
-            xValTextCell = (XTextRange) UnoRuntime.queryInterface(XTextRange.class, xValCell);
-            xValCellCursor = TextDocument.createTextCursor(xValCell);
-            ValColumn = _nColumn;
-            return true;
-        }
-    } catch (Exception e) {
-        e.printStackTrace(System.out);
-    }
-    return false;
-    }
-
-
-    public DBColumn(TextTableHandler _oTextTableHandler, RecordParser _CurDBMetaData, String _FieldName, int GroupIndex, String TableName, DBColumn OldDBColumn) throws Exception{
-        this.oTextTableHandler = _oTextTableHandler;
-        this.CurDBMetaData = _CurDBMetaData;
-    CurDBField = CurDBMetaData.getFieldColumnByDisplayName(_FieldName);
-        bIsGroupColumn = true;
-        getTableColumns(TableName);
-        xNameCell = OldDBColumn.xNameCell;
-        xNameTextCell = OldDBColumn.xNameTextCell;
-        xValCell = OldDBColumn.xValCell;
-        xValTextCell = OldDBColumn.xValTextCell;
-        xValCellCursor = TextDocument.createTextCursor(xValCell);
-        ValColumn = OldDBColumn.ValColumn;
-        ValRow = OldDBColumn.ValRow;
-        initializeNumberFormat();
-    }
-
-
-    public DBColumn(TextTableHandler _oTextTableHandler, RecordParser _CurDBMetaData, String _FieldName, int GroupIndex, String TableName) throws Exception{
-        this.oTextTableHandler = _oTextTableHandler;
-        this.CurDBMetaData = _CurDBMetaData;
-    CurDBField = CurDBMetaData.getFieldColumnByFieldName(_FieldName);
-        bIsGroupColumn = true;
-        XTextRange xTextCell;
-        XCell xCell;
-        getTableColumns(TableName);
-        XTableRows xRows = xTextTable.getRows();
-        for (int n = 0; n < xTableColumns.getCount(); n++){
-            for (int m = 0; m < xRows.getCount(); m++){
-                xCell = xCellRange.getCellByPosition(n,m);
-                xTextCell = (XTextRange) UnoRuntime.queryInterface(XTextRange.class, xCell);
-                String CompString = TableName.substring(4);
+
+    private boolean assignCells(int _nColumn, boolean _bforce)
+        {
+            try
+            {
+                XCell xCell = CurRecordTable.xCellRange.getCellByPosition(_nColumn,0);
+                XTextRange xTextCell = (XTextRange) UnoRuntime.queryInterface(XTextRange.class, xCell);
+                String CompString = "Column";
                 XTextCursor xLocCellCursor = TextDocument.createTextCursor(xCell);
-                if (isNameCell(xLocCellCursor, CurDBField.FieldName, CompString)){
+                if (isNameCell(xLocCellCursor, CurDBField.FieldName, CompString) || (_bforce))
+                {
                     xNameCell = xCell;
                     xNameTextCell = xTextCell;
+                    xValCell = CurRecordTable.xCellRange.getCellByPosition(_nColumn,1);
+                    xValTextCell = (XTextRange) UnoRuntime.queryInterface(XTextRange.class, xValCell);
+                    xValCellCursor = TextDocument.createTextCursor(xValCell);
+                    ValColumn = _nColumn;
+                    return true;
                 }
-                else{   //In Grouping Sections only two cells are allowed ' if (CellString.equals(CurFieldString)){
-                    xValCell = xCell;
-                    xValTextCell = xTextCell;
-                    xValCellCursor = xLocCellCursor;
-                    ValColumn = n;
-                    ValRow = m;
-                    checkforLeftAlignment();
-                }
             }
+            catch (Exception e)
+            {
+                e.printStackTrace(System.out);
+            }
+            return false;
+        }
+
+
+    public DBColumn(TextTableHandler _oTextTableHandler, RecordParser _CurDBMetaData, String _FieldName, int GroupIndex, String TableName, DBColumn OldDBColumn) throws Exception
+        {
+            this.oTextTableHandler = _oTextTableHandler;
+            this.CurDBMetaData = _CurDBMetaData;
+            CurDBField = CurDBMetaData.getFieldColumnByDisplayName(_FieldName);
+            bIsGroupColumn = true;
+            getTableColumns(TableName);
+            xNameCell = OldDBColumn.xNameCell;
+            xNameTextCell = OldDBColumn.xNameTextCell;
+            xValCell = OldDBColumn.xValCell;
+            xValTextCell = OldDBColumn.xValTextCell;
+            xValCellCursor = TextDocument.createTextCursor(xValCell);
+            ValColumn = OldDBColumn.ValColumn;
+            ValRow = OldDBColumn.ValRow;
+            initializeNumberFormat();
         }
-    }
-
-
-    private void  getTableColumns(String TableName){
-    try {
-        XNameAccess xAllTextTables = oTextTableHandler.xTextTablesSupplier.getTextTables();
-        if (xAllTextTables.hasByName(TableName) == true){
-            Object oTextTable = xAllTextTables.getByName(TableName);
-            xCellRange = (XCellRange) UnoRuntime.queryInterface(XCellRange.class, oTextTable);
-            xTextTable = (XTextTable) UnoRuntime.queryInterface(XTextTable.class, oTextTable);
-            xTableName = (XNamed) UnoRuntime.queryInterface(XNamed.class, oTextTable);
-            xTableColumns = xTextTable.getColumns();
+
+
+    public DBColumn(TextTableHandler _oTextTableHandler, RecordParser _CurDBMetaData, String _FieldName, int GroupIndex, String TableName) throws Exception
+        {
+            this.oTextTableHandler = _oTextTableHandler;
+            this.CurDBMetaData = _CurDBMetaData;
+            CurDBField = CurDBMetaData.getFieldColumnByFieldName(_FieldName);
+            bIsGroupColumn = true;
+            XTextRange xTextCell;
+            XCell xCell;
+            getTableColumns(TableName);
+
+            XTableRows xRows = null;
+            try
+            {
+                xRows = xTextTable.getRows();
+            }
+            catch (java.lang.NullPointerException e)
+            {
+                e.printStackTrace();
+// TODO: handle the nullpointer right
+//                return;
+            }
+            for (int n = 0; n < xTableColumns.getCount(); n++)
+            {
+                for (int m = 0; m < xRows.getCount(); m++)
+                {
+                    xCell = xCellRange.getCellByPosition(n,m);
+                    xTextCell = (XTextRange) UnoRuntime.queryInterface(XTextRange.class, xCell);
+                    String CompString = TableName.substring(4);
+                    XTextCursor xLocCellCursor = TextDocument.createTextCursor(xCell);
+                    if (isNameCell(xLocCellCursor, CurDBField.FieldName, CompString))
+                    {
+                        xNameCell = xCell;
+                        xNameTextCell = xTextCell;
+                    }
+                    else
+                    {   //In Grouping Sections only two cells are allowed ' if (CellString.equals(CurFieldString)){
+                        xValCell = xCell;
+                        xValTextCell = xTextCell;
+                        xValCellCursor = xLocCellCursor;
+                        ValColumn = n;
+                        ValRow = m;
+                        checkforLeftAlignment();
+                    }
+                }
+            }
         }
-    } catch (Exception e) {
-        e.printStackTrace();
-    }}
 
 
-    public void initializeNumberFormat(){
-        if (CurDBField.isBoolean()){
-            NumberFormatter oNumberFormatter = oTextTableHandler.getNumberFormatter();
-            int iLogicalFormatKey = oNumberFormatter.setBooleanReportDisplayNumberFormat();
-            oNumberFormatter.setNumberFormat(xValCell, iLogicalFormatKey, oNumberFormatter);
+    private void  getTableColumns(String TableName)
+        {
+            try
+            {
+                XNameAccess xAllTextTables = oTextTableHandler.xTextTablesSupplier.getTextTables();
+                if (xAllTextTables.hasByName(TableName) == true)
+                {
+                    Object oTextTable = xAllTextTables.getByName(TableName);
+                    xCellRange = (XCellRange) UnoRuntime.queryInterface(XCellRange.class, oTextTable);
+                    xTextTable = (XTextTable) UnoRuntime.queryInterface(XTextTable.class, oTextTable);
+                    xTableName = (XNamed) UnoRuntime.queryInterface(XNamed.class, oTextTable);
+                    xTableColumns = xTextTable.getColumns();
+                }
+            }
+            catch (Exception e)
+            {
+                e.printStackTrace();
+            }
         }
-        else{
-            oTextTableHandler.getNumberFormatter().setNumberFormat(xValCell, CurDBField.DBFormatKey, CurDBMetaData.getNumberFormatter());
+
+
+    public void initializeNumberFormat()
+        {
+            if (CurDBField.isBoolean()){
+                NumberFormatter oNumberFormatter = oTextTableHandler.getNumberFormatter();
+                int iLogicalFormatKey = oNumberFormatter.setBooleanReportDisplayNumberFormat();
+                oNumberFormatter.setNumberFormat(xValCell, iLogicalFormatKey, oNumberFormatter);
+            }
+            else
+            {
+                oTextTableHandler.getNumberFormatter().setNumberFormat(xValCell, CurDBField.DBFormatKey, CurDBMetaData.getNumberFormatter());
+            }
+            setCellFont();
         }
-        setCellFont();
-    }
 
 
-    public void insertColumnData(TextFieldHandler oTextFieldHandler, boolean _bIsLandscape){
-        insertUserFieldToTableCell(oTextFieldHandler);
-        replaceValueCellofTable(_bIsLandscape);
-    }
+    public void insertColumnData(TextFieldHandler oTextFieldHandler, boolean _bIsLandscape)
+        {
+            insertUserFieldToTableCell(oTextFieldHandler);
+            replaceValueCellofTable(_bIsLandscape);
+        }
 
 
-    public void insertUserFieldToTableCell(TextFieldHandler oTextFieldHandler){
-        XTextCursor xTextCursor = TextDocument.createTextCursor(xNameCell);
-        xTextCursor.gotoStart(false);
-        xTextCursor.gotoEnd(true);
-        xTextCursor.setString("");
-    oTextFieldHandler.insertUserField(xTextCursor, CurDBField.FieldName, CurDBField.FieldTitle);
-    }
+    public void insertUserFieldToTableCell(TextFieldHandler oTextFieldHandler)
+        {
+            XTextCursor xTextCursor = TextDocument.createTextCursor(xNameCell);
+            xTextCursor.gotoStart(false);
+            xTextCursor.gotoEnd(true);
+            xTextCursor.setString("");
+            oTextFieldHandler.insertUserField(xTextCursor, CurDBField.FieldName, CurDBField.FieldTitle);
+        }
 
 
-    public void insertUserFieldToTableCell(TextFieldHandler oTextFieldHandler, XCell xCell){
-        XTextCursor xTextCursor = TextDocument.createTextCursor(xCell);
-        xTextCursor.gotoStart(false);
-        xTextCursor.gotoEnd(true);
-        xTextCursor.setString("");
-    oTextFieldHandler.insertUserField(xTextCursor, CurDBField.FieldName, CurDBField.FieldTitle);
-    }
+    public void insertUserFieldToTableCell(TextFieldHandler oTextFieldHandler, XCell xCell)
+        {
+            XTextCursor xTextCursor = TextDocument.createTextCursor(xCell);
+            xTextCursor.gotoStart(false);
+            xTextCursor.gotoEnd(true);
+            xTextCursor.setString("");
+            oTextFieldHandler.insertUserField(xTextCursor, CurDBField.FieldName, CurDBField.FieldTitle);
+        }
 
 
-    public void formatValueCell(){
-        initializeNumberFormat();
-        if (checkforLeftAlignment())
-            bAlignLeft = true;
-    }
+    public void formatValueCell()
+        {
+            initializeNumberFormat();
+            if (checkforLeftAlignment())
+            {
+                bAlignLeft = true;
+            }
+        }
 
-    private boolean checkforLeftAlignment(){
-        bAlignLeft = ((CurDBField.bIsNumberFormat) && (ValColumn == xTableColumns.getCount()-1));
-        return bAlignLeft;
-    }
+    private boolean checkforLeftAlignment()
+        {
+            bAlignLeft = ((CurDBField.bIsNumberFormat) && (ValColumn == xTableColumns.getCount()-1));
+            return bAlignLeft;
+        }
 
 
-    public void modifyCellContent(XCellRange xCellRange, Object CurGroupValue){
-    try{
-        xValCell = xCellRange.getCellByPosition(ValColumn, ValRow);
-        xValTextCell = (XTextRange) UnoRuntime.queryInterface(XTextRange.class, xValCell);
-        modifyCellContent(CurGroupValue);
-        if (bAlignLeft){
-            xValCellCursor = TextDocument.createTextCursor(xValCell);
-            Helper.setUnoPropertyValue(xValCellCursor, "ParaAdjust", new Integer(com.sun.star.style.ParagraphAdjust.LEFT_value));
+    public void modifyCellContent(XCellRange xCellRange, Object CurGroupValue)
+        {
+            try
+            {
+                xValCell = xCellRange.getCellByPosition(ValColumn, ValRow);
+                xValTextCell = (XTextRange) UnoRuntime.queryInterface(XTextRange.class, xValCell);
+                modifyCellContent(CurGroupValue);
+                if (bAlignLeft)
+                {
+                    xValCellCursor = TextDocument.createTextCursor(xValCell);
+                    Helper.setUnoPropertyValue(xValCellCursor, "ParaAdjust", new Integer(com.sun.star.style.ParagraphAdjust.LEFT_value));
+                }
+            }
+            catch( Exception exception )
+            {
+                exception.printStackTrace(System.out);
+            }
         }
-    }
-    catch( Exception exception ){
-        exception.printStackTrace(System.out);
-    }}
-
-
-    public void modifyCellContent(Object CurGroupValue){
-    double dblValue = 0;
-    try{
-        if (xValCell != null){
-            if (AnyConverter.isString(CurGroupValue)){
-                String sValue = (String) AnyConverter.toString(CurGroupValue);
-                xValTextCell.setString(sValue);
+
+
+    public void modifyCellContent(Object CurGroupValue)
+        {
+            double dblValue = 0;
+            try
+            {
+                if (xValCell != null)
+                {
+                    if (AnyConverter.isString(CurGroupValue))
+                    {
+                        String sValue = AnyConverter.toString(CurGroupValue);
+                        xValTextCell.setString(sValue);
+                    }
+                    else
+                    {
+                        if (AnyConverter.isBoolean(CurGroupValue))
+                        {
+                            dblValue = (double) AnyConverter.toInt(CurGroupValue);
+                        }
+                        if (AnyConverter.isByte(CurGroupValue))
+                        {
+                            dblValue = (double) AnyConverter.toByte(CurGroupValue);
+                        }
+                        else if (AnyConverter.isDouble(CurGroupValue))
+                        {
+                            dblValue = AnyConverter.toDouble(CurGroupValue);
+                        }
+                        else if (AnyConverter.isFloat(CurGroupValue))
+                        {
+                            dblValue = (double) AnyConverter.toFloat(CurGroupValue);
+                        }
+                        else if (AnyConverter.isInt(CurGroupValue))
+                        {
+                            dblValue = (double) AnyConverter.toInt(CurGroupValue);
+                        }
+                        else if (AnyConverter.isLong(CurGroupValue))
+                        {
+                            dblValue = (double) AnyConverter.toLong(CurGroupValue);
+                        }
+                        else if (AnyConverter.isShort(CurGroupValue))
+                        {
+                            dblValue = (double) AnyConverter.toShort(CurGroupValue);
+                        }
+                        xValCell.setValue(dblValue);
+                    }
+                }
             }
-            else{
-                if (AnyConverter.isBoolean(CurGroupValue))
-                    dblValue = (double) AnyConverter.toInt(CurGroupValue);
-                if (AnyConverter.isByte(CurGroupValue))
-                    dblValue = (double) AnyConverter.toByte(CurGroupValue);
-                else if (AnyConverter.isDouble(CurGroupValue))
-                    dblValue = AnyConverter.toDouble(CurGroupValue);
-                else if (AnyConverter.isFloat(CurGroupValue))
-                    dblValue = (double) AnyConverter.toFloat(CurGroupValue);
-                else if (AnyConverter.isInt(CurGroupValue))
-                    dblValue = (double) AnyConverter.toInt(CurGroupValue);
-                else if (AnyConverter.isLong(CurGroupValue))
-                    dblValue = (double) AnyConverter.toLong(CurGroupValue);
-                else if (AnyConverter.isShort(CurGroupValue))
-                    dblValue = (double) AnyConverter.toShort(CurGroupValue);
-                xValCell.setValue(dblValue);
+            catch( Exception exception )
+            {
+                System.err.println( exception);
             }
         }
-    }
-    catch( Exception exception ){
-        System.err.println( exception);
-    }}
 
 
     // If the parameter CurGroupValue is null the placeholders are inserted
-    public void replaceValueCellofTable(boolean _bIsLandscape){
-    try{
-        Object CurGroupValue;
-        if (bIsGroupColumn == false && CurDBField.bIsNumberFormat == false)
-            CurGroupValue = BlindtextCreator.adjustBlindTextlength(CurDBField.FieldTitle, CurDBField.FieldWidth, _bIsLandscape, bIsGroupColumn, CurDBMetaData.RecordFieldNames);
-        else
-            CurGroupValue = CurDBField.getDefaultValue();
-        modifyCellContent(CurGroupValue);
-        if (bAlignLeft)
-        Helper.setUnoPropertyValue(xValCellCursor, "ParaAdjust", new Integer(ParagraphAdjust.LEFT_value));
-
-        if ((CurDBField.FieldType == com.sun.star.sdbc.DataType.BIT) || (CurDBField.FieldType == com.sun.star.sdbc.DataType.BOOLEAN)){
-            CharFontName = "StarSymbol";
-            Helper.setUnoPropertyValue(xValCellCursor, "CharFontName", CharFontName);
-            if (bIsGroupColumn == false)
-                Helper.setUnoPropertyValue(xValCellCursor, "ParaAdjust", new Integer(ParagraphAdjust.CENTER_value));
-        }
-        else{
-            if (PropertyState == com.sun.star.beans.PropertyState.DEFAULT_VALUE){
-                XPropertyState xPropState = (XPropertyState) UnoRuntime.queryInterface(XPropertyState.class, xValCellCursor);
-                xPropState.setPropertyToDefault("CharFontName");
-            }
-            else{
-                if (PropertyState == com.sun.star.beans.PropertyState.DIRECT_VALUE)
+    public void replaceValueCellofTable(boolean _bIsLandscape)
+        {
+            try
+            {
+                Object CurGroupValue;
+                if (bIsGroupColumn == false && CurDBField.bIsNumberFormat == false)
+                {
+                    CurGroupValue = BlindtextCreator.adjustBlindTextlength(CurDBField.FieldTitle, CurDBField.FieldWidth, _bIsLandscape, bIsGroupColumn, CurDBMetaData.getRecordFieldNames());
+                }
+                else
+                {
+                    CurGroupValue = CurDBField.getDefaultValue();
+                }
+                modifyCellContent(CurGroupValue);
+                if (bAlignLeft)
+                {
+                    Helper.setUnoPropertyValue(xValCellCursor, "ParaAdjust", new Integer(ParagraphAdjust.LEFT_value));
+                }
+
+                if ((CurDBField.FieldType == com.sun.star.sdbc.DataType.BIT) || (CurDBField.FieldType == com.sun.star.sdbc.DataType.BOOLEAN))
+                {
+                    CharFontName = "StarSymbol";
                     Helper.setUnoPropertyValue(xValCellCursor, "CharFontName", CharFontName);
+                    if (bIsGroupColumn == false)
+                    {
+                        Helper.setUnoPropertyValue(xValCellCursor, "ParaAdjust", new Integer(ParagraphAdjust.CENTER_value));
+                    }
+                }
+                else
+                {
+                    if (PropertyState == com.sun.star.beans.PropertyState.DEFAULT_VALUE)
+                    {
+                        XPropertyState xPropState = (XPropertyState) UnoRuntime.queryInterface(XPropertyState.class, xValCellCursor);
+                        xPropState.setPropertyToDefault("CharFontName");
+                    }
+                    else
+                    {
+                        if (PropertyState == com.sun.star.beans.PropertyState.DIRECT_VALUE)
+                        {
+                            Helper.setUnoPropertyValue(xValCellCursor, "CharFontName", CharFontName);
+                        }
+                    }
+                }
+            }
+            catch(com.sun.star.beans.UnknownPropertyException exception)
+            {
+                exception.printStackTrace(System.out);
             }
         }
-    }
-    catch(com.sun.star.beans.UnknownPropertyException exception){
-        exception.printStackTrace(System.out);
-    }}
-
-
-    public void setCellFont(){
-    try{
-        XPropertyState xPropertyState;
-        int FieldType = CurDBField.FieldType;
-        if ((FieldType == com.sun.star.sdbc.DataType.BIT) || (CurDBField.FieldType == com.sun.star.sdbc.DataType.BOOLEAN)){
-            CharFontName = "StarSymbol";
-            PropertyState = com.sun.star.beans.PropertyState.DIRECT_VALUE;
-            xValCellCursor.gotoStart(false);
-            xValCellCursor.gotoEnd(true);
-            Helper.setUnoPropertyValue(xValCellCursor, "CharFontName", CharFontName);
-        }
-        else{
-            xPropertyState = (XPropertyState) UnoRuntime.queryInterface(XPropertyState.class, xValCellCursor);
-            PropertyState = xPropertyState.getPropertyState("CharFontName");
-            CharFontName = AnyConverter.toString(Helper.getUnoPropertyValue(xValCellCursor, "CharFontName"));
-        }
-    }
-    catch(Exception exception){
-        exception.printStackTrace(System.out);
-    }}
-
-    private boolean isNameCell(XTextCursor xCellCursor, String CurFieldName, String CompString){
-    try{
-        xCellCursor.gotoStart(false);
-        XTextRange xTextRange = xCellCursor.getEnd();
-        Object oTextField = Helper.getUnoPropertyValue(xTextRange, "TextField");
-        if (AnyConverter.isVoid(oTextField))
-            return false;
-        else{
-            XDependentTextField xDependent = (XDependentTextField) UnoRuntime.queryInterface(XDependentTextField.class, oTextField);
-            XPropertySet xMaster = xDependent.getTextFieldMaster();
-            String UserFieldName = (String) xMaster.getPropertyValue("Name");
-            boolean bIsNameCell = ((UserFieldName.startsWith(CompString)) || (UserFieldName.equals(CurFieldName)));
-            return bIsNameCell;
-        }
-    }
-    // Todo: Insert a  resource; Exception should be thrown to the calling routine
-    catch( Exception exception){
+
+
+    public void setCellFont()
+        {
+            try
+            {
+                XPropertyState xPropertyState;
+                int FieldType = CurDBField.FieldType;
+                if ((FieldType == com.sun.star.sdbc.DataType.BIT) || (CurDBField.FieldType == com.sun.star.sdbc.DataType.BOOLEAN))
+                {
+                    CharFontName = "StarSymbol";
+                    PropertyState = com.sun.star.beans.PropertyState.DIRECT_VALUE;
+                    xValCellCursor.gotoStart(false);
+                    xValCellCursor.gotoEnd(true);
+                    Helper.setUnoPropertyValue(xValCellCursor, "CharFontName", CharFontName);
+                }
+                else
+                {
+                    xPropertyState = (XPropertyState) UnoRuntime.queryInterface(XPropertyState.class, xValCellCursor);
+                    PropertyState = xPropertyState.getPropertyState("CharFontName");
+                    CharFontName = AnyConverter.toString(Helper.getUnoPropertyValue(xValCellCursor, "CharFontName"));
+                }
+            }
+            catch(Exception exception)
+            {
+                exception.printStackTrace(System.out);
+            }}
+
+    private boolean isNameCell(XTextCursor xCellCursor, String CurFieldName, String CompString)
+        {
+            try
+            {
+                xCellCursor.gotoStart(false);
+                XTextRange xTextRange = xCellCursor.getEnd();
+                Object oTextField = Helper.getUnoPropertyValue(xTextRange, "TextField");
+                if (AnyConverter.isVoid(oTextField))
+                {
+                    return false;
+                }
+                else
+                {
+                    XDependentTextField xDependent = (XDependentTextField) UnoRuntime.queryInterface(XDependentTextField.class, oTextField);
+                    XPropertySet xMaster = xDependent.getTextFieldMaster();
+                    String UserFieldName = (String) xMaster.getPropertyValue("Name");
+                    boolean bIsNameCell = ((UserFieldName.startsWith(CompString)) || (UserFieldName.equals(CurFieldName)));
+                    return bIsNameCell;
+                }
+            }
+            // Todo: Insert a  resource; Exception should be thrown to the calling routine
+            catch( Exception exception)
+            {
 //      sMsgInvalidTextField = oResource.getResText(UIConsts.RID_REPORT + 73);
 //      SystemDialog.showMessageBox(oTextTableHandler.xMSFDoc, "ErrorBox", VclWindowPeerAttribute.OK, sMsgInvalidTextField);
-        exception.printStackTrace(System.out);
-        return true;    //most probably this is really the Namecell!!!!
-    }}
+                exception.printStackTrace(System.out);
+                return true;    //most probably this is really the Namecell!!!!
+            }
+        }
 }