C# Excel Interop - Cell text cut off on publishing
I have an Excel sheet where the text overflows the cell and into the next one, but when using the C# Excel Interop to publish this worksheet the text is simply cut off where the cell ends. If I publish the same worksheet from the Excel application the text is not cut. I don't want to use wrapping as I'd like the resulting PDF to remain as close to the original Excel sheet as possible. How can I prevent the text from being cut off?
c# excel interop overflow wrap
add a comment |
I have an Excel sheet where the text overflows the cell and into the next one, but when using the C# Excel Interop to publish this worksheet the text is simply cut off where the cell ends. If I publish the same worksheet from the Excel application the text is not cut. I don't want to use wrapping as I'd like the resulting PDF to remain as close to the original Excel sheet as possible. How can I prevent the text from being cut off?
c# excel interop overflow wrap
Can you verify that the cell to the right of the one containing the text is empty? If it's empty then Excel will display the text as overflowing into the next cell, and that behavior is reflected in an exported PDF.
– Scott Hannen
2 days ago
add a comment |
I have an Excel sheet where the text overflows the cell and into the next one, but when using the C# Excel Interop to publish this worksheet the text is simply cut off where the cell ends. If I publish the same worksheet from the Excel application the text is not cut. I don't want to use wrapping as I'd like the resulting PDF to remain as close to the original Excel sheet as possible. How can I prevent the text from being cut off?
c# excel interop overflow wrap
I have an Excel sheet where the text overflows the cell and into the next one, but when using the C# Excel Interop to publish this worksheet the text is simply cut off where the cell ends. If I publish the same worksheet from the Excel application the text is not cut. I don't want to use wrapping as I'd like the resulting PDF to remain as close to the original Excel sheet as possible. How can I prevent the text from being cut off?
c# excel interop overflow wrap
c# excel interop overflow wrap
asked 2 days ago
bjornno
12114
12114
Can you verify that the cell to the right of the one containing the text is empty? If it's empty then Excel will display the text as overflowing into the next cell, and that behavior is reflected in an exported PDF.
– Scott Hannen
2 days ago
add a comment |
Can you verify that the cell to the right of the one containing the text is empty? If it's empty then Excel will display the text as overflowing into the next cell, and that behavior is reflected in an exported PDF.
– Scott Hannen
2 days ago
Can you verify that the cell to the right of the one containing the text is empty? If it's empty then Excel will display the text as overflowing into the next cell, and that behavior is reflected in an exported PDF.
– Scott Hannen
2 days ago
Can you verify that the cell to the right of the one containing the text is empty? If it's empty then Excel will display the text as overflowing into the next cell, and that behavior is reflected in an exported PDF.
– Scott Hannen
2 days ago
add a comment |
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%2f53944831%2fc-sharp-excel-interop-cell-text-cut-off-on-publishing%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
active
oldest
votes
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f53944831%2fc-sharp-excel-interop-cell-text-cut-off-on-publishing%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
Can you verify that the cell to the right of the one containing the text is empty? If it's empty then Excel will display the text as overflowing into the next cell, and that behavior is reflected in an exported PDF.
– Scott Hannen
2 days ago