Java / Apache POI - How to create a XSSFClientAnchor in a fixed position with a fixed size? Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) Data science time! April 2019 and salary with experience The Ask Question Wizard is Live!How do I efficiently iterate over each entry in a Java Map?How do I read / convert an InputStream into a String in Java?How do I generate random integers within a specific range in Java?How do I create a file and write to it in Java?How do I convert a String to an int in Java?How do I fix android.os.NetworkOnMainThreadException?Creating a memory leak with JavaCreate and Alter Excel tables using Apache POIXSSFWorkbook constructor is undefinedHow to protect Apache poi sxssf sheet with optional locking of features like autofilter
Fundamental Solution of the Pell Equation
Is it common practice to audition new musicians one-on-one before rehearsing with the entire band?
Generate an RGB colour grid
What is homebrew?
Should I use a zero-interest credit card for a large one-time purchase?
Why wasn't DOSKEY integrated with COMMAND.COM?
Compare a given version number in the form major.minor.build.patch and see if one is less than the other
How to Make a Beautiful Stacked 3D Plot
How to tell that you are a giant?
Wu formula for manifolds with boundary
Why aren't air breathing engines used as small first stages
What is the longest distance a player character can jump in one leap?
old style "caution" boxes
How to find all the available tools in mac terminal?
Is the Standard Deduction better than Itemized when both are the same amount?
Is it a good idea to use CNN to classify 1D signal?
Most bit efficient text communication method?
Do I really need recursive chmod to restrict access to a folder?
Fantasy story; one type of magic grows in power with use, but the more powerful they are, they more they are drawn to travel to their source
Why didn't Eitri join the fight?
Delete nth line from bottom
Can an alien society believe that their star system is the universe?
8 Prisoners wearing hats
How do I stop a creek from eroding my steep embankment?
Java / Apache POI - How to create a XSSFClientAnchor in a fixed position with a fixed size?
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)
Data science time! April 2019 and salary with experience
The Ask Question Wizard is Live!How do I efficiently iterate over each entry in a Java Map?How do I read / convert an InputStream into a String in Java?How do I generate random integers within a specific range in Java?How do I create a file and write to it in Java?How do I convert a String to an int in Java?How do I fix android.os.NetworkOnMainThreadException?Creating a memory leak with JavaCreate and Alter Excel tables using Apache POIXSSFWorkbook constructor is undefinedHow to protect Apache poi sxssf sheet with optional locking of features like autofilter
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
According to https://poi.apache.org/apidocs/dev/org/apache/poi/xssf/usermodel/XSSFClientAnchor.html it should be possible but I really can't find how. I'm using POI 3.17.
java excel apache-poi
asked Mar 8 at 18:42
BolaumBolaum
254
add a comment |
According to https://poi.apache.org/apidocs/dev/org/apache/poi/xssf/usermodel/XSSFClientAnchor.html it should be possible but I really can't find how. I'm using POI 3.17.
java excel apache-poi
asked Mar 8 at 18:42
BolaumBolaum
254
1
What is the goal? AXSSFClientAnchoranchors shapes in the drawing layer to the sheet's cells. So it needs row1, dy1, col1, dx1, row2, dy2, col2, dx2. If the goal is only that the shape shall not change position and/or size when cells dimensinon changes, then do setAnchorType appropriate.
– Axel Richter
Mar 9 at 6:29
add a comment |
According to https://poi.apache.org/apidocs/dev/org/apache/poi/xssf/usermodel/XSSFClientAnchor.html it should be possible but I really can't find how. I'm using POI 3.17.
java excel apache-poi
asked Mar 8 at 18:42
BolaumBolaum
254
According to https://poi.apache.org/apidocs/dev/org/apache/poi/xssf/usermodel/XSSFClientAnchor.html it should be possible but I really can't find how. I'm using POI 3.17.
java excel apache-poi
java excel apache-poi
asked Mar 8 at 18:42
BolaumBolaum
254
asked Mar 8 at 18:42
BolaumBolaum
254
asked Mar 8 at 18:42
BolaumBolaum
254
asked Mar 8 at 18:42
BolaumBolaum
254
asked Mar 8 at 18:42
BolaumBolaum
254
254
1
What is the goal? AXSSFClientAnchoranchors shapes in the drawing layer to the sheet's cells. So it needs row1, dy1, col1, dx1, row2, dy2, col2, dx2. If the goal is only that the shape shall not change position and/or size when cells dimensinon changes, then do setAnchorType appropriate.
– Axel Richter
Mar 9 at 6:29
add a comment |
1
What is the goal? AXSSFClientAnchoranchors shapes in the drawing layer to the sheet's cells. So it needs row1, dy1, col1, dx1, row2, dy2, col2, dx2. If the goal is only that the shape shall not change position and/or size when cells dimensinon changes, then do setAnchorType appropriate.
– Axel Richter
Mar 9 at 6:29
1
1
What is the goal? A
XSSFClientAnchor anchors shapes in the drawing layer to the sheet's cells. So it needs row1, dy1, col1, dx1, row2, dy2, col2, dx2. If the goal is only that the shape shall not change position and/or size when cells dimensinon changes, then do setAnchorType appropriate.– Axel Richter
Mar 9 at 6:29
What is the goal? A
XSSFClientAnchor anchors shapes in the drawing layer to the sheet's cells. So it needs row1, dy1, col1, dx1, row2, dy2, col2, dx2. If the goal is only that the shape shall not change position and/or size when cells dimensinon changes, then do setAnchorType appropriate.– Axel Richter
Mar 9 at 6:29
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55069187%2fjava-apache-poi-how-to-create-a-xssfclientanchor-in-a-fixed-position-with-a%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55069187%2fjava-apache-poi-how-to-create-a-xssfclientanchor-in-a-fixed-position-with-a%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
What is the goal? A
XSSFClientAnchoranchors shapes in the drawing layer to the sheet's cells. So it needs row1, dy1, col1, dx1, row2, dy2, col2, dx2. If the goal is only that the shape shall not change position and/or size when cells dimensinon changes, then do setAnchorType appropriate.– Axel Richter
Mar 9 at 6:29