Ask Your Question

Russ G's profile - activity

2020-08-09 00:07:08 +0100 marked best answer Calc: If/Then with Checkbox

Is there a way for me to perform an if/then in Calc (v5) based on whether or not a checkbox is checked?

I want calc to run one calculation if the box is checked and another if it is not. I know checkboxes can be inserted but I don't know how to use them or if they can be used as I describe.

If it's easy to do I'd like to try it but if this is complicated please do not feel the need to explain the process. I casn probably find another way to handle the situation.

Thanks.

2020-08-09 00:06:24 +0100 received badge  Notable Question (source)
2020-07-21 23:38:16 +0100 marked best answer Can I place a text box with columns on top of a full bleed photo?

I'm trying to set up a page in writer where I have a full bleed image in the background and text, some in columns and some not, on top of the image.

It doesn't seem that columns are an option inside a text box--the menu item is grayed out.

Is there any way to do what I want to do?

2020-07-21 23:37:47 +0100 received badge  Notable Question (source)
2020-07-10 21:32:46 +0100 received badge  Popular Question (source)
2020-07-10 05:40:09 +0100 asked a question Calc: If/Then with Checkbox

Calc: If/Then with Checkbox Is there a way for me to perform an if/then in Calc (v5) based on whether or not a checkbox

2020-04-30 08:04:25 +0100 commented answer dashed lines between pages writer

Your explanation is appreciated... a little too technical for me to grasp entirely, but I understand the Writer is not t

2020-04-30 01:30:14 +0100 commented answer dashed lines between pages writer

What you see are two images on adjacent pages that were photographed as one then cropped exactly in half and placed on a

2020-04-29 22:28:42 +0100 commented answer dashed lines between pages writer

Also, you wrote that the dashed line is evidence of the existence of a manual page break. Well, that's the only way I kn

2020-04-29 22:02:31 +0100 commented answer dashed lines between pages writer

Thank you. That sounds like it may be useful. I'm not sure I quite understand, however. You've mentioned some things tha

2020-04-29 14:51:20 +0100 received badge  Notable Question (source)
2020-04-29 08:25:17 +0100 received badge  Popular Question (source)
2020-04-29 02:31:58 +0100 commented question dashed lines between pages writer

We haven't tried that but we would not expect them to export or print as they are just part of the user interface that w

2020-04-28 22:46:04 +0100 asked a question dashed lines between pages writer

dashed lines between pages writer We're working in LibreOffice Writer 5.4, Windows 10, creating a file for output as a P

2020-02-21 02:58:18 +0100 received badge  Famous Question (source)
2020-02-21 02:58:18 +0100 received badge  Notable Question (source)
2019-02-16 17:00:40 +0100 commented question LibreOffice to PhotoShop Font Embedding Problem

I have not found a solution to this problem, but in this instance I was able to create a workaround. I created a PDF/A

2019-02-15 02:47:01 +0100 asked a question LibreOffice to PhotoShop Font Embedding Problem

LibreOffice to PhotoShop Font Embedding Problem I'm making a book cover for print on IngramSpark. They require a PDF/X w

2019-01-30 15:04:24 +0100 received badge  Famous Question (source)
2019-01-30 15:04:24 +0100 received badge  Notable Question (source)
2019-01-30 15:04:24 +0100 received badge  Popular Question (source)
2019-01-24 17:32:19 +0100 received badge  Famous Question (source)
2018-12-02 22:50:01 +0100 received badge  Popular Question (source)
2018-10-06 18:23:21 +0100 received badge  Notable Question (source)
2018-10-06 18:23:21 +0100 received badge  Famous Question (source)
2018-08-23 16:33:53 +0100 received badge  Famous Question (source)
2018-06-25 22:07:12 +0100 received badge  Popular Question (source)
2018-06-20 23:42:01 +0100 commented answer Exporting PDF - "Submit Format"

Thanks, but that's not it. The Create PDF Form checkbox is not checked. In fact it's grayed out.

2018-06-20 23:15:21 +0100 commented question Exporting PDF - "Submit Format"

Thanks. Don't know. We submitted the PDF to CreateSpace's Internal Reviewer and it came back with an error having to d

2018-06-20 23:15:21 +0100 received badge  Commentator
2018-06-20 22:44:18 +0100 asked a question Exporting PDF - "Submit Format"

Exporting PDF - "Submit Format" We have exported LO Writer files before (File/Export/PDF/PDF Options) and do not recall

2018-06-20 22:44:13 +0100 asked a question Exporting PDF - "Submit Format"

Exporting PDF - "Submit Format" We have exported LO Writer files before (File/Export/PDF/PDF Options) and do not recall

2018-06-05 17:26:49 +0100 commented answer Determining Photo File Names

Thanks. Actually, my girlfriend has the file and she's on a PC so we will try that on both platforms.

2018-06-04 23:58:51 +0100 commented answer Determining Photo File Names

How does one unpack a Writer document in Mac OS X?

2018-05-23 13:32:06 +0100 received badge  Notable Question (source)
2018-05-23 02:20:45 +0100 received badge  Popular Question (source)
2018-05-22 22:52:05 +0100 received badge  Supporter (source)
2018-05-22 22:51:54 +0100 commented answer Determining Photo File Names

Thanks. The images were Inserted using the Insert command (Mac) so neither modality you mentioned was used but the resul

2018-05-22 21:29:37 +0100 asked a question Determining Photo File Names

Determining Photo File Names I've created a Writer document into which I have inserted photos. My problem is that in som

2018-05-22 01:57:02 +0100 answered a question Can I place a text box with columns on top of a full bleed photo?

I found the answer to my own question--use frames, but that begs the question, why have both frames and text boxes if fr

2018-05-22 00:29:37 +0100 asked a question Can I place a text box with columns on top of a full bleed photo?

Can I place a text box with columns on top of a full bleed photo? I'm trying to set up a page in writer where I have a f

2018-05-14 23:52:06 +0100 edited question Grids & Text Boxes Disappearing

Grids & Text Boxes Disappearing I'm working on a book project in LO Writer 5.2.0.4 with my girlfriend. It is 32 page

2018-05-13 20:16:54 +0100 asked a question Grids & Text Boxes Disappearing

Grids & Text Boxes Disappearing I'm working on a book project in LO Writer 5.2.0.4 with my girlfriend. It is 32 page

2018-04-30 03:18:15 +0100 received badge  Enthusiast
2018-04-29 18:00:33 +0100 marked best answer Inserting Page Breaks - Writer

I'm using Writer 6.0.3.2 on Mac OS X 10.11.6. I'm working on a document that will later be exported as a PDF for on-demand printing as a book. My page size is set to 8.63" W x 8.75" H (for a full bleed book) and the trim size will be 8.5" x 8.5" which means that the excess beyond 8.5" will be trimmed off by the printer.

My problem is that I am inserting images that are 8.63" W x 8.75" H (the same size as the page" and after setting the images to Original Size and filling the page there is no way I can find to easily insert a page break. The Insert/Page Break option is grayed out. There is no way to click outside of the image when it fills the page. Sure, I can shrink the image down so that I can click on the page outside the image area, insert a page break, and then expand the image back to full size, but this adds a number of unwelcome steps to the work flow. SometimesI can insert a page break before expanding the image to the size of the page but not always. Is there a way to insert a page break without doing this dance?

2018-04-29 17:59:49 +0100 marked best answer Unknown Tool

In LibreOffice Writer 5 there is a tool icon that that appears at the cursor position when a text box is left-clicked and the mouse button held down. The icon looks like a rectangle with an arrow pointing toward the 11 o'clock position. If the cursor is then moved and then the mouse button released the text box jumps across the page aligning the top line of the bounding box to the cursor position.

What is this tool called, and what is it used for, bearing in mind the cross-arrow tool can move a text box too?

2018-04-29 17:59:49 +0100 received badge  Scholar (source)