Search found 9066 matches

by FJCC
Tue Mar 26, 2024 3:33 pm
Forum: Calc
Topic: [Solved] Determine MAX and MIN, with multiple criteria
Replies: 11
Views: 964

Re: MAX IF: "AND" supported?

a) The formulas will automatically be displayed in the the language of the user's OpenOffice locale. There is no need to translate them. b) Column headers in other languages are not usually a problem but it might make the document easier to understand if they were in English. The most helpful things...
by FJCC
Tue Mar 26, 2024 12:19 am
Forum: Calc
Topic: [Solved] Determine MAX and MIN, with multiple criteria
Replies: 11
Views: 964

Re: MAX IF: "AND" supported?

Yes, the MIN() function won't work. The formula relies on the fact that TRUE comparisons have a value of 1. When A1:A8 = "A" is true, it gets the value 1 and the same goes for B1:B8 = "". You end up with 1 * 1 * C1:C8 for the rows where both the test conditions are TRUE. A FALSE ...
by FJCC
Mon Mar 25, 2024 8:07 pm
Forum: Calc
Topic: [Solved] Determine MAX and MIN, with multiple criteria
Replies: 11
Views: 964

Re: MAX IF: "AND" supported?

A formula like the following, entered as a array formula, works for me if the maximum value is positive.

Code: Select all

=MAX((A1:A8="A") * (B1:B8="") *(C1:C8))
by FJCC
Sun Mar 24, 2024 2:15 am
Forum: Calc
Topic: [Solved] Undesired sort order after import of CSV file
Replies: 6
Views: 345

Re: Cannot sort by Date because the data didn't include leading zeros.. help?

In the Text Import dialog that you should get as part of importing a csv file, there is a table at the bottom showing a few rows of data and the data type under which they will be imported. The default type is Standard. Right click on the word standard and pick something appropriate for the column. ...
by FJCC
Sun Mar 24, 2024 12:55 am
Forum: Calc
Topic: [Solved] Undesired sort order after import of CSV file
Replies: 6
Views: 345

Re: Cannot sort by Date because the data didn't include leading zeros.. help?

Your dates and your numbers have entered the cells as text and are being sorted alphabetically. How is the data being entered into Calc?
by FJCC
Sat Mar 23, 2024 6:43 pm
Forum: Impress
Topic: Installed new components, Impress text invisible
Replies: 24
Views: 2622

Re: Installed new components, Impress text invisible

There is an option to increase the size of the user interface. Choose the menu Tools -> Options, expand the OpenOffice list on the left, choose View, and increase the Scaling value in the User Interface section.
by FJCC
Sat Mar 23, 2024 6:08 pm
Forum: Impress
Topic: Installed new components, Impress text invisible
Replies: 24
Views: 2622

Re: Installed new components, Impress text invisible

No, you are not in the wrong forum. LibreOffice is also supported here. If you want to install OpenOffice on Ubuntu, you first have to uninstall LibreOffice. sudo apt purge libreoffice* Then download and install OpenOffice. You can then reinstall LibreOffice. I have both programs on a Linux Mint sys...
by FJCC
Sat Mar 23, 2024 5:31 pm
Forum: Impress
Topic: Installed new components, Impress text invisible
Replies: 24
Views: 2622

Re: Installed new components, Impress text invisible

I don't have any suggestions for fixing this in LibreOffice but I opened the document in OpenOffice and the text is visible in Normal View, in the Slide pane, and in the slider Sorter View.
by FJCC
Sat Mar 23, 2024 12:37 am
Forum: Calc
Topic: [Solved] Subtract B1 from last entry in column C
Replies: 8
Views: 714

Re: How to format cell to take from one line and add to another

If all the cells in column C are filled until the one you want, you can use

Code: Select all

=INDEX(C1:C100;COUNT(C1:C100)) - B1
Edit: And all the cells after the one your want are empty until the end of the range C1:C100. Of course you can adjust C1:C100 to fit your needs.
by FJCC
Sat Mar 23, 2024 12:27 am
Forum: Calc
Topic: [Solved] Assign sales values to categories
Replies: 3
Views: 343

Re: Struggling with multiple "IF" formula.

I wouldn't use nested IF() functions. It gets very unwieldy as the number of categories grows. If the values are evenly spaced, as in your example, you can use the QUOTIENT() function. If they are not evenly spaced, you can use VLOOKUP(). The attached file shows examples of both. CHange the value in...
by FJCC
Fri Mar 22, 2024 10:44 pm
Forum: Calc
Topic: [Solved] Subtract B1 from last entry in column C
Replies: 8
Views: 714

Re: How to format cell to take from one line and add to another

It isn't clear to me what you want to do. Please upload a small example file explaining which cells you want to add and where you want the result to appear. To upload a file, click Post Reply and look for the Attachments tab just below the box where you type a response.
by FJCC
Fri Mar 22, 2024 6:17 am
Forum: Calc
Topic: Hyperlink to today's date
Replies: 18
Views: 1134

Re: Hyperlink to today's date

You are being both unclear and snarky. That is a bad combination. Here are a few comments before I leave this thread. You are not using OpenOffice if your version is 24.2.1.2. You are using LibreOffice. In your first post you say "hyperlink at the top of the page that could take you directly to...
by FJCC
Thu Mar 21, 2024 7:12 pm
Forum: Calc
Topic: Hyperlink to today's date
Replies: 18
Views: 1134

Re: Hyperlink to today's date

My understanding is that the user wants a hyperlink function that moves the cursor to the row in his document that corresponds to the current date.
by FJCC
Thu Mar 21, 2024 7:06 pm
Forum: Calc
Topic: [Solved] Format error in sub-document context.xml
Replies: 4
Views: 248

Re: Format error in sub-document context.xml

Here is what I got so far. Does it look right?
by FJCC
Thu Mar 21, 2024 4:57 pm
Forum: Calc
Topic: [Solved] Format error in sub-document context.xml
Replies: 4
Views: 248

Re: Format error in sub-document context.xml

To upload a file, click Post Reply and look for the Attachments tab just below the box where you type a response. There is an Add Files button there that allows you to indicate which file to attach. The size limit is 128 KB.
Please don't post new questions in previously solved threads.
by FJCC
Thu Mar 21, 2024 4:33 pm
Forum: Calc
Topic: Hyperlink to today's date
Replies: 18
Views: 1134

Re: Help with Hyperlink to today's date

Clicking on the text in I2 takes me to C28. Isn't that what you want?
by FJCC
Thu Mar 21, 2024 4:05 pm
Forum: Calc
Topic: Hyperlink to today's date
Replies: 18
Views: 1134

Re: Help with Hyperlink to today's date

This worked for me in OpenOffice.

Code: Select all

=HYPERLINK("#Tidrapport."&ADDRESS(MATCH(TODAY();C$1:C$1048576;0);3;4;1);"Today's row")
by FJCC
Mon Mar 18, 2024 6:52 am
Forum: Calc
Topic: [Solved] Keep formula from changing if columns are deleted
Replies: 4
Views: 458

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: 404

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: [Solved] Create report with "Comments" filled in
Replies: 3
Views: 664

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: [Dropped] Blank Page Partially Covering Text
Replies: 9
Views: 1071

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: [Dropped] Blank Page Partially Covering Text
Replies: 9
Views: 1071

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: 3
Views: 650

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: 445

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: 168

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: 821

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: 4
Views: 1141

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: 389

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: 726

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: 675

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