OpenOffice/LibreOffice Calc how to not print column but show it in sheet?
I have a column with hyperlinks to other parts of the same spreadsheet and I want this column to be visible inside the program, but hidden when printed: it should not take up space.
The only solution I found is to right-click the column header (so that the whole column is selected), go into formatting, Cell protection tab and tick "Do not print"; but this only hides the column values from printing, not the whole column. As a result the column is being printed (at least according to the print preview) empty, taking up space on the paper sheet.
The column I'm talking about is the last one on the right; is there a solution that can be applied to columns in the middle of the document as well?
printing formatting libreoffice openoffice
add a comment |
I have a column with hyperlinks to other parts of the same spreadsheet and I want this column to be visible inside the program, but hidden when printed: it should not take up space.
The only solution I found is to right-click the column header (so that the whole column is selected), go into formatting, Cell protection tab and tick "Do not print"; but this only hides the column values from printing, not the whole column. As a result the column is being printed (at least according to the print preview) empty, taking up space on the paper sheet.
The column I'm talking about is the last one on the right; is there a solution that can be applied to columns in the middle of the document as well?
printing formatting libreoffice openoffice
add a comment |
I have a column with hyperlinks to other parts of the same spreadsheet and I want this column to be visible inside the program, but hidden when printed: it should not take up space.
The only solution I found is to right-click the column header (so that the whole column is selected), go into formatting, Cell protection tab and tick "Do not print"; but this only hides the column values from printing, not the whole column. As a result the column is being printed (at least according to the print preview) empty, taking up space on the paper sheet.
The column I'm talking about is the last one on the right; is there a solution that can be applied to columns in the middle of the document as well?
printing formatting libreoffice openoffice
I have a column with hyperlinks to other parts of the same spreadsheet and I want this column to be visible inside the program, but hidden when printed: it should not take up space.
The only solution I found is to right-click the column header (so that the whole column is selected), go into formatting, Cell protection tab and tick "Do not print"; but this only hides the column values from printing, not the whole column. As a result the column is being printed (at least according to the print preview) empty, taking up space on the paper sheet.
The column I'm talking about is the last one on the right; is there a solution that can be applied to columns in the middle of the document as well?
printing formatting libreoffice openoffice
printing formatting libreoffice openoffice
asked Dec 1 at 13:31
watery
1109
1109
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
1) Select the data you want printed
2) Select Format -> Print Ranges -> Define
3) Print!
Note that if you create a print range with non contiguous columns these will be on separate pages. Ex.: If you want to print columns A:C
and E:H
, A:C
will be on page 1 and E:H
will be on page 2.
add a comment |
As cybernetic.nomad explains, the native options for controlling complex print ranges are limited. If the column you don't want printed is on the end, just define the print range to exclude it (you can set the print range in the Format tab). If one or more non-print columns are in the middle, you need to use a workaround to do what you want. Here are two options:
At print time, you can hide the columns you don't want to print. Then unhide them after. You could automate the task by recording a macro that hides the selected columns, prints, and unhides them, all with one shortcut.
Create a separate version, perhaps on another sheet, that you print. On the print version, use simple cell references to display only the selected columns. This takes only a minute to set up:
In say A1 of the print sheet, put a cell reference to the first value of the actual sheet. Drag that across to replicate the entire top row. Delete the columns you don't want printed. Then select all the cells in the row and drag down to replicate all the rows you need. The actual sheet can change, and the print version will reflect whatever is there.
You can pre-populate the print sheet with an arbitrary large number of rows to handle a changing amount of rows. Instead of just referencing the cell, use an IF test for a blank on the real sheet, displaying the cell value, or a null if the actual cell is empty.
If you go this route, you can set the print range to the portion needed in whole-page increments (partial pages will print based on the displayed content). Adjust the print range if the actual data changes enough to change the number of pages you print.
Thank you for the thorough explanation, but I'm preparing an inventory to track item maintenance events of lots of items, and I'm deciding whether to make it in Calc or write a whole program; thus I will go for Calc if it proves to be easy to realize — this issue on printing may not be the only one I will face.
– watery
Dec 2 at 13:39
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
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%2fsuperuser.com%2fquestions%2f1379967%2fopenoffice-libreoffice-calc-how-to-not-print-column-but-show-it-in-sheet%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
1) Select the data you want printed
2) Select Format -> Print Ranges -> Define
3) Print!
Note that if you create a print range with non contiguous columns these will be on separate pages. Ex.: If you want to print columns A:C
and E:H
, A:C
will be on page 1 and E:H
will be on page 2.
add a comment |
1) Select the data you want printed
2) Select Format -> Print Ranges -> Define
3) Print!
Note that if you create a print range with non contiguous columns these will be on separate pages. Ex.: If you want to print columns A:C
and E:H
, A:C
will be on page 1 and E:H
will be on page 2.
add a comment |
1) Select the data you want printed
2) Select Format -> Print Ranges -> Define
3) Print!
Note that if you create a print range with non contiguous columns these will be on separate pages. Ex.: If you want to print columns A:C
and E:H
, A:C
will be on page 1 and E:H
will be on page 2.
1) Select the data you want printed
2) Select Format -> Print Ranges -> Define
3) Print!
Note that if you create a print range with non contiguous columns these will be on separate pages. Ex.: If you want to print columns A:C
and E:H
, A:C
will be on page 1 and E:H
will be on page 2.
answered Dec 1 at 15:06
cybernetic.nomad
1,206111
1,206111
add a comment |
add a comment |
As cybernetic.nomad explains, the native options for controlling complex print ranges are limited. If the column you don't want printed is on the end, just define the print range to exclude it (you can set the print range in the Format tab). If one or more non-print columns are in the middle, you need to use a workaround to do what you want. Here are two options:
At print time, you can hide the columns you don't want to print. Then unhide them after. You could automate the task by recording a macro that hides the selected columns, prints, and unhides them, all with one shortcut.
Create a separate version, perhaps on another sheet, that you print. On the print version, use simple cell references to display only the selected columns. This takes only a minute to set up:
In say A1 of the print sheet, put a cell reference to the first value of the actual sheet. Drag that across to replicate the entire top row. Delete the columns you don't want printed. Then select all the cells in the row and drag down to replicate all the rows you need. The actual sheet can change, and the print version will reflect whatever is there.
You can pre-populate the print sheet with an arbitrary large number of rows to handle a changing amount of rows. Instead of just referencing the cell, use an IF test for a blank on the real sheet, displaying the cell value, or a null if the actual cell is empty.
If you go this route, you can set the print range to the portion needed in whole-page increments (partial pages will print based on the displayed content). Adjust the print range if the actual data changes enough to change the number of pages you print.
Thank you for the thorough explanation, but I'm preparing an inventory to track item maintenance events of lots of items, and I'm deciding whether to make it in Calc or write a whole program; thus I will go for Calc if it proves to be easy to realize — this issue on printing may not be the only one I will face.
– watery
Dec 2 at 13:39
add a comment |
As cybernetic.nomad explains, the native options for controlling complex print ranges are limited. If the column you don't want printed is on the end, just define the print range to exclude it (you can set the print range in the Format tab). If one or more non-print columns are in the middle, you need to use a workaround to do what you want. Here are two options:
At print time, you can hide the columns you don't want to print. Then unhide them after. You could automate the task by recording a macro that hides the selected columns, prints, and unhides them, all with one shortcut.
Create a separate version, perhaps on another sheet, that you print. On the print version, use simple cell references to display only the selected columns. This takes only a minute to set up:
In say A1 of the print sheet, put a cell reference to the first value of the actual sheet. Drag that across to replicate the entire top row. Delete the columns you don't want printed. Then select all the cells in the row and drag down to replicate all the rows you need. The actual sheet can change, and the print version will reflect whatever is there.
You can pre-populate the print sheet with an arbitrary large number of rows to handle a changing amount of rows. Instead of just referencing the cell, use an IF test for a blank on the real sheet, displaying the cell value, or a null if the actual cell is empty.
If you go this route, you can set the print range to the portion needed in whole-page increments (partial pages will print based on the displayed content). Adjust the print range if the actual data changes enough to change the number of pages you print.
Thank you for the thorough explanation, but I'm preparing an inventory to track item maintenance events of lots of items, and I'm deciding whether to make it in Calc or write a whole program; thus I will go for Calc if it proves to be easy to realize — this issue on printing may not be the only one I will face.
– watery
Dec 2 at 13:39
add a comment |
As cybernetic.nomad explains, the native options for controlling complex print ranges are limited. If the column you don't want printed is on the end, just define the print range to exclude it (you can set the print range in the Format tab). If one or more non-print columns are in the middle, you need to use a workaround to do what you want. Here are two options:
At print time, you can hide the columns you don't want to print. Then unhide them after. You could automate the task by recording a macro that hides the selected columns, prints, and unhides them, all with one shortcut.
Create a separate version, perhaps on another sheet, that you print. On the print version, use simple cell references to display only the selected columns. This takes only a minute to set up:
In say A1 of the print sheet, put a cell reference to the first value of the actual sheet. Drag that across to replicate the entire top row. Delete the columns you don't want printed. Then select all the cells in the row and drag down to replicate all the rows you need. The actual sheet can change, and the print version will reflect whatever is there.
You can pre-populate the print sheet with an arbitrary large number of rows to handle a changing amount of rows. Instead of just referencing the cell, use an IF test for a blank on the real sheet, displaying the cell value, or a null if the actual cell is empty.
If you go this route, you can set the print range to the portion needed in whole-page increments (partial pages will print based on the displayed content). Adjust the print range if the actual data changes enough to change the number of pages you print.
As cybernetic.nomad explains, the native options for controlling complex print ranges are limited. If the column you don't want printed is on the end, just define the print range to exclude it (you can set the print range in the Format tab). If one or more non-print columns are in the middle, you need to use a workaround to do what you want. Here are two options:
At print time, you can hide the columns you don't want to print. Then unhide them after. You could automate the task by recording a macro that hides the selected columns, prints, and unhides them, all with one shortcut.
Create a separate version, perhaps on another sheet, that you print. On the print version, use simple cell references to display only the selected columns. This takes only a minute to set up:
In say A1 of the print sheet, put a cell reference to the first value of the actual sheet. Drag that across to replicate the entire top row. Delete the columns you don't want printed. Then select all the cells in the row and drag down to replicate all the rows you need. The actual sheet can change, and the print version will reflect whatever is there.
You can pre-populate the print sheet with an arbitrary large number of rows to handle a changing amount of rows. Instead of just referencing the cell, use an IF test for a blank on the real sheet, displaying the cell value, or a null if the actual cell is empty.
If you go this route, you can set the print range to the portion needed in whole-page increments (partial pages will print based on the displayed content). Adjust the print range if the actual data changes enough to change the number of pages you print.
edited Dec 2 at 8:41
answered Dec 2 at 8:35
fixer1234
17.7k144581
17.7k144581
Thank you for the thorough explanation, but I'm preparing an inventory to track item maintenance events of lots of items, and I'm deciding whether to make it in Calc or write a whole program; thus I will go for Calc if it proves to be easy to realize — this issue on printing may not be the only one I will face.
– watery
Dec 2 at 13:39
add a comment |
Thank you for the thorough explanation, but I'm preparing an inventory to track item maintenance events of lots of items, and I'm deciding whether to make it in Calc or write a whole program; thus I will go for Calc if it proves to be easy to realize — this issue on printing may not be the only one I will face.
– watery
Dec 2 at 13:39
Thank you for the thorough explanation, but I'm preparing an inventory to track item maintenance events of lots of items, and I'm deciding whether to make it in Calc or write a whole program; thus I will go for Calc if it proves to be easy to realize — this issue on printing may not be the only one I will face.
– watery
Dec 2 at 13:39
Thank you for the thorough explanation, but I'm preparing an inventory to track item maintenance events of lots of items, and I'm deciding whether to make it in Calc or write a whole program; thus I will go for Calc if it proves to be easy to realize — this issue on printing may not be the only one I will face.
– watery
Dec 2 at 13:39
add a comment |
Thanks for contributing an answer to Super User!
- 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%2fsuperuser.com%2fquestions%2f1379967%2fopenoffice-libreoffice-calc-how-to-not-print-column-but-show-it-in-sheet%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