PowerPlusPro to Eikon Migration

[thwk]

I am working on a conversion project to convert existing PPP/Excel2003/XP workbooks (tons of them) to Eikon/Excel2010/Win7. Nightmarish because I have some really complicated sheets which already crashes once or twice a day.



I have written some scripts to convert RtUpdate to RData because the Eikon convertor sucks.



At the moment I am stuck at this problem: RData cannot update certain cells that are hidden as a group. Anyone has encountered this sort of error before?



Any general advice is welcome! Seriously my quality of life has been seriously hurt by MS and Reuters...

[thwk]

Additional information:



We use VBA to protect our sheets. The code below shows how it is done:





TheSheet.Protect password:=PWD, _

DrawingObjects:=False, _

contents:=True, _

AllowFiltering:=True, _

AllowFormattingCells:=True, _

AllowFormattingColumns:=True, _

AllowFormattingRows:=True, _

AllowUsingPivotTables:=True, _

UserInterfaceOnly:=True, _

AllowInsertingColumns:=False, _

AllowInsertingRows:=False, _

AllowDeletingColumns:=False, _

AllowDeletingRows:=False

[GMoney86]

Hi thwk,



I would recommend contacting the Thomson Reuters helpdesk who can escalate this issue to the appropriate support teams who can follow up and assist you with migration.



Thomson Reuters Support - Contact Us



As for the issue you described, I've never seen this issue before. RData() will update functions hidden by group or by by the hide row/column function. I've attached a very basic workbook showing this.



[url=/User%20Files/9078/RData%20updating%20cells%20hidden%20in%20a%20group.xls]Attached File: RData updating cells hidden in a group.xls[/url]



I'll get around to testing this on an Excel 2010 x86, Windows 7 x64 machine when I get a chance and get back to you on that. Remember that there is no Excel 2010 x64 support at this moment.



Again, the Thomson Reuters Helpdesk should be able to shed light on your issue and help you to migrate your workbooks from Power Plus Pro to Eikon Excel.

[thwk]

Hi, GMoney86,



Thanks  a lot for the reply! So based on your sheet I added a button and the macro (as shown in my previous post) and I am able to reproduce the issue.



[url=/User%20Files/9076/RData%20updating%20cells%20hidden%20in%20a%20group%20protected.xls]Attached File: RData updating cells hidden in a group protected.xls[/url]



Now in DataGrouped tab, I can see the RData() shows 'You cannot overwrite cell E7'



Yeah, I contact Reuters support and hopefully they can take a look at this issue soon.