-
Notifications
You must be signed in to change notification settings - Fork 272
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Setting TopLeftCell in a template with Frozen columns Breaks both scroll and frozen columns #352
Comments
The topLeftCell attribute set by the TopLeftCell is done on the sheet view, so this applies to the bottom right pane. Location of the top left visible cell Location of the top left visible cell in the bottom right I think this has to be set on the pane element that currently is not exposed as a property ... <pane xSplit="7" ySplit="7" topLeftCell="H56" activePane="bottomRight" state="frozen"/> We will look into adding support for this. |
It seems more complex than what i thought it should be...
Of EPPLUS is supposed to work the same as
Of the COM? If that's the case i will gladly wait until you manage to implement it! That's currently the only thing that's stopping us to get a commercial license :P Thanks! |
I thing we have to deep dive into how it should work. You have the panes today in ws.View.Panes and we should liklely implement it there. It look like this in the worksheet xml: <sheetViews>
<sheetView tabSelected="1" zoomScaleNormal="100" workbookViewId="0">
<pane xSplit="7" ySplit="7" topLeftCell="H8" activePane="bottomRight" state="frozen"/>
<selection activeCell="A6895" sqref="A6895:G6918"/>
<selection pane="topRight" activeCell="A6895" sqref="A6895:G6918"/>
<selection pane="bottomLeft" activeCell="A6895" sqref="A6895:G6918"/>
<selection pane="bottomRight" activeCell="M19" sqref="M19"/>
</sheetView>
</sheetViews> |
I'm doing a LOT of assumptions here, but... Understanding why the Excel file in my example gets THAT damaged when setting TopLeftCell on the wrong(?) Pane could definitely help me understand what's the exact problem here but I'm afraid it's a bit too much for me considering the time i have at hand ^.^" Let me know if there is something i can do to help you out with this! |
We will look into this as it seems like a function that should be there. I'll add this as an enhancement for the next version. |
I updated my repository (https://github.com/EmaGht/EPPLUS_Bug) with an example using Microsoft COMs, Hope it's gonna be handy to check for the desired beahviour |
Repository is still this: https://github.com/EmaGht/EPPLUS_Bug
Latest developer build of EPPLUS is installed so this (#347) is not a problem anymore, but now i added the showcase of the bug happening when setting the TopLeftCell (Line 19 of Program.cs)
Forgive me for nagging you this much
The text was updated successfully, but these errors were encountered: