Skip to content
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

Can't capture and reinsert charts that are not TwoCellAnchors #29

Open
tomfaulhaber opened this issue Mar 12, 2016 · 0 comments
Open

Can't capture and reinsert charts that are not TwoCellAnchors #29

tomfaulhaber opened this issue Mar 12, 2016 · 0 comments

Comments

@tomfaulhaber
Copy link
Owner

The POI library does not support creating anchors on sheets that are absolutely positioned, but only the TwoCellAnchor. This is an issue because the workaround to #7 requires us to remove the charts from the sheets and reinsert them later. We avoid this problem for chartsheets by simply leaving them in place, but if there's an absolute anchor on a worksheet, we don't have much choice but to throw an exception.

As far as I can tell, this happens when you copy a chart from a chart sheet to a work sheet, but there may be other ways to get into this situation as well. The workaround would be to recreate the chart from scratch on the worksheet (but maybe just resizing it would work - I didn't try that).

One approach to resolving this might be to simply create an equivalent TwoCellAnchor to the AbsoluteAnchor. Another way would be as a side product of #28.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant