Apache OpenOffice (AOO) Bugzilla – Issue 32817
The PersistentRepresentation property of the CellAddressConversion serivce is not consistent
Last modified: 2013-07-30 02:21:01 UTC
The PersistentRepresentation property of the CellAddressConversion serivce is not consistent. Consider the following macro: Sub DemoCellAddressConversion Dim oConv Dim oCell oConv = ThisComponent.CreateInstance("com.sun.star.table.CellAddressConversion") oCell = ThisComponent.Sheets(2).getCellByPosition(0,0) 'Cell Sheet3.A1 oConv.Address = oCell.getCellAddress() Print oConv.UserInterfaceRepresentation 'Sheet3.A1 Print oConv.PersistentRepresentation 'Sheet3.A1 Inspect(oConv) End Sub If the cell is taken from Sheet1, however, the UserInterfaceRepresentation property does not include the sheet name. In other words, it returns "A1" rather than "Sheet1.A1". I initially assumed that this was related to which sheet is the active sheet. I was not correct. I believe that the code that contains this is in the file sc/source/ui/unoobj.cxx in the function: void SAL_CALL ScAddressConversionObj::setPropertyValue( const rtl::OUString& aPropertyName, const uno::Any& aValue ) throw(beans::UnknownPropertyException, beans::PropertyVetoException, lang::IllegalArgumentException, lang::WrappedTargetException, uno::RuntimeException) { Look for the SC_UNONAME_PERSREPR property.
SW->SAB: one for you :-)
Hi This defect still exists in OOo 3.1.1 as far as I can make out. Is there any reason for not trying to fix this? (Ok if I were a programmer I would try, but I am not). Regards Martin
Reset assignee on issues not touched by assignee in more than 2000 days.