it's in odt but I can save it in any format. If submitting the books as PDF is acceptable print to a Windows PDF printer and select your page ranges (first part, second part) in the OpenOffice File → Print dialog. You won't need to adjust page numbering or image anchoring because the PDF will prese...

My open and closed quotation marks are curly but not single apostrophes. You will also need to enable Format → AutoCorrect → While Typing , but that is the default setting. To convert previously created Writer documents which have straight single quotes to use custom (curly) single quotes read the ...

I want to save it in 1-373 pages and 374-660 pages. What file format is the book? • If it is ODT, make two copies of the 660-page file. Now you have three documents. Leave the original file with all the pages . In the first copy, delete the content in the last half of the book and save it. In the s...

I need to click on 1 to order one picture, click on 2 to display another picture...how? [Solved] Change image based on a cell value [Solved] Inventory Spreadsheet with pictures [Solved] How to change image based on a cell value Search found 87 matches: display image If this solved your problem plea...

I am curious if there is a way to create a template with my Font/placements/text size etc for my Print sheet using my "Database Fields" info? The File → New → Labels wizard creates a Writer document. After formatting it the way you want just use File → Save As → File type → ODF Text Docum...

Perhaps the text-only system will include Tools → Language → Translate.

Grandapa Jim wrote: ↑Fri Mar 29, 2024 7:01 pm How does one set up an accumulator?

[Solved] Cell which totals data entered into an input cell
[Solved] How to keep a number?
[Solved] Keep adding numbers on a single cell
Enter numbers in one cell, have them add up in another

Hi, and welcome to the forum. I read the Open Office guides … I hope you mean this, Writer Guide Chapter 11: Using Mail Merge - Form letters, mailing labels, and envelopes , which should have all the details you need. The main problem is that even after uninstalling and reinstalling Open Office 4.1....

are the words 'smallest' and 'largest' in the incorrect places? should they be reversed? The descriptions are correct. 0 is the biggest file size and fastest loading because no compression is used when the file is written, hence no decompression (which takes extra time) is needed during open. 9 is ...

However I'm curious to know other formulas to get the same. Given the layout of that data some of the methods I have used in other situations are not applicable. You are using three cell ranges as the source for your filter: • 'Plausibility Check'.D4:F4 • 'Plausibility Check'.B7:B11 • 'Year Report'...

I need to find the max and min values from a triple column spreadsheet You asked a very similar question six years ago: [Solved] Largest If? After reviewing that if you still need help I think I can show you a method for MIN, perhaps several methods. Attach a spreadsheet demonstrating the situation...

Produced by SQM Reader Pro 2.2.0.0 Year/Month/Day,Hour/Minute/Second 2022/01/12,22:38:40 2022/01/12,22:39:41 2022/01/12,22:40:41 2022/01/12,22:41:41 2022/01/12,22:42:41 I will assume you have read [Tutorial] Text to Columns. I imported the data above with: • Detect Special Numbers • From row 2 • Se...

Hi, and welcome to the forum. I have a spreadsheet that wa smade inoffice but when the operating system was upgraded to windows 11 all macros were removed . Don't you have a backup of your user profile ? I suspect that was where your macros were stored. Unless the macros were created or changed rece...

The template needs to include a detailed description, valuation and at least 2 photos of each piece. OpenOffice is not a good choice for this project because it is not designed to manage photos. Search found 45 matches: photo album [Tutorial] Some useful hints on using images You could create a 4-c...

It seems that the Mac version of OpenOffice simply does not have the proper settings for brochure printing. On MacOS 13.6.3 I can use File → Printer Settings → Options → ✓ Brochure then File → Print and send it to a PDF printer. This attachment shows that the result is fine and the half-size pages ...

Subtract one day from the date in C3 with result in C1 fails. I suspect your values in columns C and D are text but cannot check because you did not attach your spreadsheet. Calc's ability to perform arithmetic on text is limited. For a calculations with a text date, the date's form must one which ...

I am trying to print a booklet, where the final product will be 8.5X5.5 pages printed on 8.5X11 paper. I have never used the Brochure feature. This type of printing may be experiencing the problem which was reported in Weird page size, Writer insists upon rotating it to print . Issue 121080 Printin...

Is there a setting somewhere that prevents the standard keyboard Command-V from pasting text into a form text field? … This is only an issue in Base form text fields. Q60 suggests that this is how MacOS works now and no OpenOffice setting controls the behavior. Q37 doesn't apply to your question. I...

In other words how cai I have something like this: $A$1:$A$$NUM, where NUM=20? You cannnot use constructs like $A$1:$A$$ cell or INDIRECT(cell) in Format → Data Ranges for a chart. Data Ranges only support fixed cell ranges. However you can supply a large chart range like $A$1:$A$999. Unused cells ...

mrdone wrote: ↑Tue Mar 19, 2024 11:29 am I wonder if anyone can help me to install Urdu Language in OpenOffice 4.1.

These are the language choices that are available:
OpenOffice in native languages
LibreOffice language selection

Hi, and welcome to the forum. How do I keep =COUNTA(C4:BZ4) from changing when I delete columns? It's not possible to give a proper answer without knowing more details about the structure of your sheet and especially about which columns you are deleting. It is also not clear if keep from changing re...

… for the surplus value i want it to calculate the 0,5% percentage for a maximum of 145 This says to me that the maximum for ½% of the surplus is 145€. Thus the maximum of the sum is 65€+145€ = 210€. In that case the formula is: =SUMPRODUCT(A9>{0;6500;35500};A9-{0;6500;35500};{1E-2;-5E-3;-5E-3}) I ...

Is it possible to do a print keeping the heading but ignore certain lines between that and the next live entry? If you have a column of dates , you could use Data → Filter → Standard Filter to only show rows with future dates. Before using any filter, it is best to use Data → Define Range to tell C...

Synch Calc with Google Onenote? There are no Google products called Onenote. This is the current list: Android Android Auto Android TV Calendar Cars with Google built-in Chrome Chrome Enterprise Chromebook Chromecast Contacts Docs Drawings Drive Earth Family Link Finance Forms Gboard Gemini Gmail G...

AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel That's my forum signature. I don't run Sonoma. I don't have a Mac with an M1 processor. My understanding is that recent MacOS releases have no 32-bit support and so you'd have to install a 64-bit Java for OpenOffice. Perhaps OpenJDK is needed for OpenO...

Mac FAQ wrote: MacOS 10.15 (2019) and above require 64-bit applications.

Apparently Apple decided that for MacOS 14 that it was redundant to say that applications were 64-bit in the System Information dialog. I will update Mac FAQ.

I'll do a better job with the filenames and delete or move the rest. If you have a file which you want to protect against accidental changes, you can use File → Properties → Security → Open file read-only → OK, then save and close the document. To remove that attribute, open the read-only file and:...

Hi, and welcome to the forum. Now I have 100's of reproductions showing if I scroll to the right. The quickest way to get this resolved it to attach a document demonstrating the situation (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the...

How do I get OpenOffice Writer? If you installed OpenOffice 4.1.13 then you already have it . 202403081656.gif OpenOffice has multiple components, Writer (text documents), Calc (spreadsheets), Impress (presentations), Draw (drawings), etc. When you install OpenOffice (use that link), you get them a...

Q32: I think I have a problem with fonts. What can I do? A32: Problems with fonts may occur when you've tried to install, change, or remove them. My personal opinion is that it's not a good idea to tinker with fonts on the Mac. But if you did and are now having trouble, the simplest solution may be...