Search found 9066 matches
- 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...
- 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 ...
- 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))
- Sun Mar 24, 2024 2:15 am
- Forum: Calc
- Topic: [Solved] Undesired sort order after import of CSV file
- Replies: 6
- Views: 344
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. ...
- Sun Mar 24, 2024 12:55 am
- Forum: Calc
- Topic: [Solved] Undesired sort order after import of CSV file
- Replies: 6
- Views: 344
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?
- 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.
- 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...
- 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.
- 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
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.
Code: Select all
=INDEX(C1:C100;COUNT(C1:C100)) - B1
- 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...
- 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.
- 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...
- 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.
- 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?
- 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.
Please don't post new questions in previously solved threads.
- 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?
- 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")
- 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"))
- 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?
- 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 ...
- 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?
- 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?
- Wed Mar 13, 2024 4:31 pm
- Forum: Calc
- Topic: [Solved] Hiding lines when printing
- Replies: 3
- Views: 649
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.
- 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.
- 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
- Sat Mar 09, 2024 2:11 am
- Forum: Writer
- Topic: Compare changes between two documents
- Replies: 9
- Views: 820
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...
- 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.
- 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?
- 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.
- 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...