Issue 32817

Summary: The PersistentRepresentation property of the CellAddressConversion serivce is not consistent
Product: App Dev Reporter: andrew
Component: apiAssignee: 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: ---

Description andrew 2004-08-11 02:33:04 UTC
The PersistentRepresentation property of the CellAddressConversion serivce is
not consistent. Consider the following macro:

Sub DemoCellAddressConversion
  Dim oConv
  Dim oCell
  oConv = ThisComponent.CreateInstance("")
  oCell = ThisComponent.Sheets(2).getCellByPosition(0,0)  'Cell Sheet3.A1
  oConv.Address = oCell.getCellAddress()
  Print oConv.UserInterfaceRepresentation    'Sheet3.A1
  Print oConv.PersistentRepresentation       'Sheet3.A1
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

in the function:

void SAL_CALL ScAddressConversionObj::setPropertyValue( const rtl::OUString&
aPropertyName, const uno::Any& aValue )
                throw(beans::UnknownPropertyException, beans::PropertyVetoException,

Look for the SC_UNONAME_PERSREPR property.
Comment 1 stephan.wunderlich 2004-08-11 09:34:59 UTC
SW->SAB: one for you :-)
Comment 2 mwpub 2009-12-09 10:18:23 UTC

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).

Comment 3 Rob Weir 2013-07-30 02:21:01 UTC
Reset assignee on issues not touched by assignee in more than 2000 days.