openoffice-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From stev...@apache.org
Subject svn commit: r1553626 - /openoffice/trunk/main/oox/source/xls/worksheethelper.cxx
Date Fri, 27 Dec 2013 05:30:08 GMT
Author: steve_y
Date: Fri Dec 27 05:30:08 2013
New Revision: 1553626

URL: http://svn.apache.org/r1553626
Log:
Bug 123910 - The reference in validation condition change to #REF! in exported xls file

Modified:
    openoffice/trunk/main/oox/source/xls/worksheethelper.cxx

Modified: openoffice/trunk/main/oox/source/xls/worksheethelper.cxx
URL: http://svn.apache.org/viewvc/openoffice/trunk/main/oox/source/xls/worksheethelper.cxx?rev=1553626&r1=1553625&r2=1553626&view=diff
==============================================================================
--- openoffice/trunk/main/oox/source/xls/worksheethelper.cxx (original)
+++ openoffice/trunk/main/oox/source/xls/worksheethelper.cxx Fri Dec 27 05:30:08 2013
@@ -1073,6 +1073,26 @@ void WorksheetGlobals::finalizeValidatio
         {
             PropertySet aValProps( xValidation );
 
+            try
+            {
+                sal_Int32 nIndex = 0;
+                OUString aToken = aIt->msRef.getToken( 0, ' ', nIndex );
+
+                Reference<XSpreadsheet> xSheet = getSheetFromDoc( getCurrentSheetIndex()
);
+                Reference<XCellRange> xDBCellRange;
+                Reference<XCell> xCell;
+                xDBCellRange = xSheet->getCellRangeByName( aToken );
+
+                xCell = xDBCellRange->getCellByPosition( 0, 0 );
+                Reference<XCellAddressable> xCellAddressable( xCell, UNO_QUERY_THROW
);
+                CellAddress aFirstCell = xCellAddressable->getCellAddress();
+                Reference<XSheetCondition> xCondition( xValidation, UNO_QUERY_THROW
);
+                xCondition->setSourcePosition( aFirstCell );	
+            }
+            catch( Exception& )
+            {
+            }
+
             // convert validation type to API enum
             ValidationType eType = ValidationType_ANY;
             switch( aIt->mnType )



Mime
View raw message