|
Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
| Summary: | The PersistentRepresentation property of the CellAddressConversion serivce is not consistent | ||
|---|---|---|---|
| Product: | App Dev | Reporter: | andrew |
| Component: | api | Assignee: | AOO issues mailing list <issues> |
| Status: | CONFIRMED --- | QA Contact: | |
| Severity: | Trivial | ||
| Priority: | P3 | CC: | issues |
| Version: | 3.3.0 or older (OOo) | ||
| Target Milestone: | --- | ||
| Hardware: | PC | ||
| OS: | Linux, all | ||
| Issue Type: | DEFECT | Latest Confirmation in: | --- |
| Developer Difficulty: | --- | ||
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. |
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.