Search found 4861 matches
- Wed Apr 24, 2024 7:24 pm
- Forum: Mac OSX
- Topic: Black titles in blue menu boxes
- Replies: 1
- Views: 63
Re: Black titles in blue menu boxes
Please help me change the title color boxes to white with black copy or white copy on dark blue Mac FAQ Q47/A47: How I make the button color (black letters on dark blue) easier to read? If this solved your problem please go to your first post use the Edit ☐ button and add [Solved] to the start of t...
- Tue Apr 23, 2024 4:40 pm
- Forum: Macros and UNO API
- Topic: [Solved] Macro button to hide/unhide rows in Calc
- Replies: 7
- Views: 873
Re: Macro button for hide/unhide rows in Calc
I am trying to create a macro for a button to show or hide specific Rules for columns, I have already done this. But for rules This post seems to have been created by a language transation program. I will interpret it as: I am trying to create a macro for a button to show or hide specific rows. For...
- Fri Apr 19, 2024 11:49 pm
- Forum: Install, Setup and Troubleshooting
- Topic: Can I recover content I saw in a recovered read only file?
- Replies: 4
- Views: 699
Re: Can I recover content I saw in a recovered read only file?
I cannot find a user folder anywhere on macOS OpenOffice → Preferences → OpenOffice → Paths → Backups 202404191634.gif New content was not saved before a crash but I saw it. My guess is that the data saved for the recovery process was discarded during your attempts to save it; you have one opportun...
- Thu Apr 18, 2024 3:50 pm
- Forum: Mac OSX
- Topic: Cannot use Bauhaus font weights
- Replies: 5
- Views: 486
Re: Cannot use Bauhaus font
Mac 10.14.6 Mojave Apple support for MacOS 10.14 ended 2021-10-25 and click Show more unmaintained releases font Bauhaus is installed in the system Apple does not supply that font on MacOS 10.14. Your 20-year-old foreign font may not be fully compatible with OpenOffice on MacOS 10.14. From memory, ...
- Wed Apr 17, 2024 6:41 pm
- Forum: Calc
- Topic: No windows button on taskbar - unable to freeze rows/columns
- Replies: 8
- Views: 585
Re: No windows button on taskbar - unable to freeze rows/columns
I have … no list of options above them like I see on the videos MacOS does not have a taskbar . Mac FAQ Q11/A11: What happened to my menu bar (OpenOffice, File, Edit, etc.)? I have nearly all the buttons visible and there are two rows of them, Those are OpenOffice toolbar buttons, not the MacOS men...
- Tue Apr 16, 2024 4:05 pm
- Forum: Writer
- Topic: Split large book file into 2 odt files
- Replies: 12
- Views: 1611
Re: Split large book file into 2 odt files
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...
- Tue Apr 16, 2024 3:47 pm
- Forum: Writer
- Topic: [Solved] Set curly apostrophe as default
- Replies: 4
- Views: 805
Re: How to get default Curly Apostrophe
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 ...
- Mon Apr 15, 2024 6:50 pm
- Forum: Writer
- Topic: Split large book file into 2 odt files
- Replies: 12
- Views: 1611
Re: split large book file into 2 odt files
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...
- Sun Apr 14, 2024 6:14 pm
- Forum: Calc
- Topic: [Solved] Dropdown list and images
- Replies: 1
- Views: 452
Re: Dropdown list and images
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...
- Sun Apr 14, 2024 5:03 am
- Forum: Advanced Uses
- Topic: [Solved] Change database field in label
- Replies: 2
- Views: 923
Re: Need help w/ Labels/Templates
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...
- Mon Apr 01, 2024 3:30 pm
- Forum: General Discussion
- Topic: Back to the Future Initiative
- Replies: 11
- Views: 1353
Re: Back to the Future Initiative
Perhaps the text-only system will include Tools → Language → Translate.
- Sat Mar 30, 2024 4:33 pm
- Forum: Calc
- Topic: [Solved] Running total in accumulator
- Replies: 6
- Views: 1005
- Fri Mar 29, 2024 5:20 pm
- Forum: Advanced Uses
- Topic: [Solved] Mailing list label set up
- Replies: 2
- Views: 776
Re: Mailing list label set up
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....
- Thu Mar 28, 2024 5:27 pm
- Forum: Draw
- Topic: [Solved] Can export resolution be changed?
- Replies: 6
- Views: 1679
Re: Exporting options - can it be changed?
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 ...
- Wed Mar 27, 2024 10:20 pm
- Forum: Calc
- Topic: [Solved] Determine MAX and MIN, with multiple criteria
- Replies: 11
- Views: 1323
Re: MAX IF: "AND" supported?
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'...
- Tue Mar 26, 2024 12:53 am
- Forum: Calc
- Topic: [Solved] Determine MAX and MIN, with multiple criteria
- Replies: 11
- Views: 1323
Re: MAX IF: "AND" supported?
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...
- Mon Mar 25, 2024 5:59 pm
- Forum: Calc
- Topic: [Solved] Calculation with date yields #VALUE!
- Replies: 10
- Views: 1271
Re: Subtracting one day from a date yields #VALUE!
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...
- Sun Mar 24, 2024 3:54 pm
- Forum: Macros and UNO API
- Topic: [Dropped] Filter onto another sheet
- Replies: 8
- Views: 1421
Re: Sort onto another sheet
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...
- Sat Mar 23, 2024 4:34 pm
- Forum: Templates
- Topic: [Solved] Home inventory for insurance purposes
- Replies: 1
- Views: 696
Re: Home inventory for insurance purposes
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...
- Thu Mar 21, 2024 5:37 pm
- Forum: Writer
- Topic: [Dropped] Booklet wants to print on wrong size paper
- Replies: 14
- Views: 1354
Re: Booklet wants to print on wrong size paper
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 ...
- Wed Mar 20, 2024 7:16 pm
- Forum: Calc
- Topic: [Solved] Calculation with date yields #VALUE!
- Replies: 10
- Views: 1271
Re: Subtracting one day to a date fails
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 ...
- Wed Mar 20, 2024 6:28 pm
- Forum: Writer
- Topic: [Dropped] Booklet wants to print on wrong size paper
- Replies: 14
- Views: 1354
Re: Booklet wants to print on wrong size paper
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...
- Tue Mar 19, 2024 7:48 pm
- Forum: Forms
- Topic: Mac OS: Cmd-V doesn't paste text into a text field
- Replies: 2
- Views: 508
Re: Mac OS: Cmd-V doesn't paste text into a text field
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...
- Tue Mar 19, 2024 3:28 pm
- Forum: Calc
- Topic: [Solved] Set chart Data Rages from cell value
- Replies: 2
- Views: 700
Re: Change range of cells automatically
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 ...
- Tue Mar 19, 2024 3:16 pm
- Forum: Install, Setup and Troubleshooting
- Topic: [Solved] Install language packs for OpenOffice
- Replies: 50
- Views: 308714
Re: Where can I find language packs for OpenOffice.org
These are the language choices that are available:
OpenOffice in native languages
LibreOffice language selection
- Mon Mar 18, 2024 4:31 pm
- Forum: Calc
- Topic: [Solved] Keep formula from changing if columns are deleted
- Replies: 4
- Views: 728
Re: Keep formula from changing
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...
- Thu Mar 14, 2024 6:30 pm
- Forum: Calc
- Topic: [Solved] Determine sum with two rate brackets and a maximum
- Replies: 4
- Views: 582
Re: Need help with IF formula
… 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}) Co...
- Thu Mar 14, 2024 4:16 am
- Forum: Calc
- Topic: [Solved] Hide rows when printing
- Replies: 3
- Views: 850
Re: Hiding lines when printing
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...
- Tue Mar 12, 2024 9:41 pm
- Forum: General Discussion
- Topic: [Dropped] Synch Calc with Google Onenote?
- Replies: 1
- Views: 664
Re: Synch Calc with Google Onenote?
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...
- Sun Mar 10, 2024 4:09 pm
- Forum: Mac OSX
- Topic: 64 bit indication: that doesn't seem true in Sonoma
- Replies: 3
- Views: 796
Re: 64 bit indication: that doesn't seem true in Sonoma
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...