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?
@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 ...
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?
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.
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.
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...
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?
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.
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...
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...
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
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.
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 -...
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...
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.
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?
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...
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.
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.