This project has moved and is read-only. For the latest updates, please go here.

How to set ActiveCell?

May 9, 2012 at 7:31 PM

I love your 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" />



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.

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.