This project has moved. For the latest updates, please go here.

How to set ActiveCell?

May 9, 2012 at 7:31 PM

I love your framework...it has been a great productivity booster. But I think I finally found something ClosedXML doesn't do. I'd like to set the starting "active" cell when the user opens the document. The OpenXML Tool shows this section with the activeCell set to EK9: 

<x:sheetView tabSelected="1" workbookViewId="0">
    <x:pane xSplit="1" ySplit="8" topLeftCell="DZ9" activePane="bottomRight" state="frozenSplit" />
    <x:selection pane="topRight" />
    <x:selection pane="bottomLeft" />
    <x:selection pane="bottomRight" activeCell="EK9" sqref="EK9" />
 </x:sheetView>

 

 

I don't see anything in ws.SheetView that would be able to set the ActiveCell. Only options for freezepane and a View property, which I'm not sure what that does.

Coordinator
May 9, 2012 at 8:18 PM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.