Search found 9049 matches

by FJCC
Mon Mar 18, 2024 6:52 am
Forum: Calc
Topic: [Solved] Keep formula from changing if columns are deleted
Replies: 4
Views: 377

Re: Keep formula from changing

There may be a more elegant way, but this works.

Code: Select all

=COUNTA(INDIRECT("C4:BZ4"))
by FJCC
Sun Mar 17, 2024 12:20 am
Forum: MS Windows
Topic: Lost all my files on OpenOffice 4.1.14
Replies: 2
Views: 289

Re: lost all my files on open office 4.1.14

Sorry, I'm not aware of any icon that displays a list of files. Your signature says you use Windows 10. Is that true? Are you right clicking on the OpenOffice icon and seeing a list of files?
by FJCC
Sat Mar 16, 2024 10:10 pm
Forum: Tables & Queries
Topic: Create report with "Comments" filled in
Replies: 5
Views: 584

Re: Create report with "Comments" filled in

@MFL_2024 - If you want to make a fully functional database from csv files, i.e. both "Master Item List" and "Ship To List" are csv files, that can be done with a modest amount of set up work. Let me know if you are interested in that. It would then be simple to make the desired ...
by FJCC
Fri Mar 15, 2024 6:44 pm
Forum: Writer
Topic: Blank Page Partially Covering Text
Replies: 10
Views: 975

Re: Blank Page Partially Covering Text

I can approximate the posted image with a frame with the wrap set to Wrap Through and with no border. What happens if you right click on the edge of the "partial page"? Is there a Frame option in the context menu?
by FJCC
Fri Mar 15, 2024 6:23 pm
Forum: Writer
Topic: Blank Page Partially Covering Text
Replies: 10
Views: 975

Re: Blank Page Partially Covering Text

That's the weirdest thing I've seen in a while! Can you upload the actual document, even if it is just a copy containing only the affected page?
by FJCC
Wed Mar 13, 2024 4:31 pm
Forum: Calc
Topic: [Solved] Hiding lines when printing
Replies: 7
Views: 610

Re: Hiding lines when printing

The easiest solution is probably to hide the rows you don't want to print. Select some cells in the rows you want to hide then select the menu item Format -> Row -> Hide. When you want to unhide the rows, select cells on each side of the hidden rows and select Format -> Row -> Show.
by FJCC
Wed Mar 13, 2024 2:08 am
Forum: Calc
Topic: [Solved] Autofilter by Year/Month of date column
Replies: 5
Views: 407

Re: Autofilter by Year/Month of date column

Please upload a small example file. The easiest way to make the file might be to make a copy of your actual file, delete most of the data and change any remaining confidential information. To upload a file, click Post Reply and look for the Attachments tab just below the box where you type a response.
by FJCC
Sun Mar 10, 2024 10:00 pm
Forum: Calc
Topic: [Solved] Crash after copy to clipboard
Replies: 1
Views: 142

Re: Calc crashing on certain actions

Go to Start > Settings, Click Clipboard on the System tab and turn off Suggested Actions; if that doesn't help, try turning off Clipboard History
by FJCC
Sat Mar 09, 2024 2:11 am
Forum: Writer
Topic: Compare changes between two documents
Replies: 9
Views: 741

Re: Comparing changes in two nearly identical docs.

In OpenOffice, there is a menu item Edit -> Compare Documents. Make back up copies of both documents in case you get tangled up. Open the document you want to keep, choose Edit -> Compare Documents (or whatever it is called in LibreOffice) and the differences will be displayed as tracked changes tha...
by FJCC
Thu Mar 07, 2024 5:19 pm
Forum: Draw
Topic: [Solved] Drawing much larger in PDF than in Draw
Replies: 8
Views: 1044

Re: Off-Page Elements

Can you upload the file? To do that, click Post Reply and look for the Attachments tab just below the box where you type a response.
by FJCC
Sun Mar 03, 2024 8:00 pm
Forum: Calc
Topic: [Solved] Random name picker by macro
Replies: 2
Views: 368

Re: Random Name Picker by macro

As currently set up, the cell C3 in 123.odt will display a new name every time you press Ctrl + Shift + F9. Is that all you want from a button and macro?
by FJCC
Sun Mar 03, 2024 7:23 pm
Forum: Calc
Topic: [Solved] 03/04/24 changed to ¾ 24 (fraction)
Replies: 5
Views: 711

Re: Can't format cells for date

If you type exactly 03/04/24, including the zeros, do you get the fraction? I don't get that. If you want to type 3/4/24, I think you have to go to the menu Tools -> AutoCorrect Options, choose the Replace tab, and remove the entry for 3/4.
by FJCC
Sat Mar 02, 2024 4:00 pm
Forum: Advanced Uses
Topic: [Solved] Edit *.ott impossible
Replies: 7
Views: 633

Re: Edit *.ott impossible

I hope I'm not muddying the water here through a misunderstanding. I thought the way to edit a template is through the menu File -> Templates -> Edit. I agree it isn't obvious, but it makes sense to me that you access the template through File -> Templates and you get documents based on the template...
by FJCC
Thu Feb 29, 2024 4:33 pm
Forum: Impress
Topic: [Solved] Change resolution of images
Replies: 6
Views: 904

Re: Change resolution of images

Doh! Thanks for correcting that, Rory!
by FJCC
Thu Feb 29, 2024 1:30 am
Forum: Impress
Topic: [Solved] Change resolution of images
Replies: 6
Views: 904

Re: Change resolution of images

There is an extension to reduce the size of a presentation. I just did a quick test and it worked on my Windows 10 system despite a complaint about not being able to read a file during the installation process. To use it, download the extension, us the Tools -> Extension Manager to Add it to OpenOff...
by FJCC
Wed Feb 28, 2024 4:48 am
Forum: Writer
Topic: [Solved] Turn OFF automatic formatting
Replies: 3
Views: 2780

Re: Turning OFF automatic formatting

You can turn off automatic numbering by selecting the menu Tools -> AutoCorrect Options, choosing the Options tab and removing the selection from Apply numbering - symbol
by FJCC
Tue Feb 27, 2024 9:31 pm
Forum: Calc
Topic: [Solved] Cell edit reverts to previous value
Replies: 1
Views: 418

Re: Calc Edit Reverts to previous

Try turning off the menu selection Tools -> Cell Contents -> AutoInput
by FJCC
Sat Feb 24, 2024 8:36 pm
Forum: Writer
Topic: [Solved] Text Next to Picture
Replies: 11
Views: 1172

Re: Text Next to Picture

Change the wrap of the image. The text, as you have seen, has no wrap.
by FJCC
Sat Feb 24, 2024 4:32 pm
Forum: Calc
Topic: [Solved] Freeze both row 1 and column A
Replies: 4
Views: 707

Re: Just choose one?

Works fine with 4.1.15 on Windows 10.
Frozen.PNG
Frozen.PNG (31.07 KiB) Viewed 618 times
by FJCC
Fri Feb 23, 2024 5:42 pm
Forum: Writer
Topic: [Solved+Issue] Tooltip hints for formula fields
Replies: 22
Views: 1859

Re: Tooltip hints for formulas

I don't know of a way to change the tooltip, but you can see the desired information by pressing the keys CTRL + F9 to toggle between the field value and the field name.
by FJCC
Wed Feb 21, 2024 10:31 pm
Forum: Draw
Topic: [Workaround] Assign default color for different shapes
Replies: 4
Views: 809

Re: Assign A Default Color For Different Shapes

Maybe a template would save you some trouble. You can make a document with all the shapes and text you need and save it as a template with the menu File -> Templates -> Save. I would put it in the My Templates folder. When you want a new document, open it by choosing that template with File -> New -...
by FJCC
Wed Feb 21, 2024 7:44 pm
Forum: Draw
Topic: [Workaround] Assign default color for different shapes
Replies: 4
Views: 809

Re: Assign A Default Color For Different Shapes

I don't think you can set that by shape. You can define Graphics styles for each shape, so that after drawing the shape you can double click on the style in the Styles and Formatting window (I would have that selected in the Sidebar for easy access) and apply the color and any other properties parti...
by FJCC
Fri Feb 16, 2024 6:57 pm
Forum: Calc
Topic: [Solved] What are those buttons in left margin?
Replies: 2
Views: 667

Re: what is this for. how do I get rid of it

That is data grouping. Select the menu item Data -> Group and Outline -> Ungroup to remove it.
by FJCC
Thu Feb 15, 2024 12:06 am
Forum: Calc
Topic: [Solved] Unable to fit images to cells
Replies: 3
Views: 807

Re: Unable to fit images to cells

If I click on a cell and select the menu item Insert -> Picture -> From File, I think I get what you want. Is that what you are doing?
by FJCC
Wed Feb 14, 2024 5:58 pm
Forum: Writer
Topic: [Solved] odt file crashing AOO when opening
Replies: 7
Views: 1061

Re: odt file crashing AOO when opening

I got the file via PM and it opens with no problem. I sent a resaved copy back to the OP.
by FJCC
Wed Feb 14, 2024 5:26 pm
Forum: Writer
Topic: [Solved] Encrypt document
Replies: 3
Views: 748

Re: Encrypt document

Us the menu File -> Save As. There will be a box on the dialog labelled Save with password. Select that and then click the Save button. You will get a dialog to enter an encryption password. Fill that out and you will be done.
by FJCC
Wed Feb 14, 2024 4:42 pm
Forum: Writer
Topic: [Solved] odt file crashing AOO when opening
Replies: 7
Views: 1061

Re: Odt file crashing OO when opening.

Can you upload the file to the forum? To do that, click Post Reply and look for the Attachments tab just below the box where you type a response. If the file is larger than 128kB, could you post it on a publicly accessible drive?
by FJCC
Tue Feb 13, 2024 5:09 pm
Forum: Calc
Topic: [Solved] Format Numbers in a Pivot Table
Replies: 2
Views: 836

Re: Format Numbers in a Pivot Table

Short answer: Set the Pivot Table Value and Pivot Table Result cell styles to have an integer number format. Longer answer: Access the Styles & Formatting tool, either in the Sidebar where it is the second icon down, or through the menu Format -> Styles & Formatting. Click the Cell Styles ic...
by FJCC
Fri Feb 09, 2024 11:30 pm
Forum: MS Windows
Topic: OpenOffice Crashing
Replies: 5
Views: 1055

Re: OpenOffice Crashing

You can post it on a personal cloud drive, like Google Drive or One Drive, and make it publicly available, or you can use a file sharing site like MediaFire.
by FJCC
Thu Feb 08, 2024 7:22 am
Forum: MS Windows
Topic: OpenOffice Crashing
Replies: 5
Views: 1055

Re: Open Office Crashing

Please post the file here so we can see what happens on other computers. To post a file, click Post Reply and look for the Attachments tab just below the box where you type a response.