Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenWed, 19 Aug 2020 16:04:45 +0200Set a minimum amount for formulahttps://ask.libreoffice.org/en/question/261033/set-a-minimum-amount-for-formula/So, I have this small calc sheet. I have some set of values that decrease when I input my numbers on the right. One of these cells, likely inelegantly, takes values from two different cells, but one of them should never go below "0" when subtracting. I want that cell to know that even if it goes subzero, it should always display and have as its value no less than "0".
Thanks for the help! StarblindMark89Wed, 19 Aug 2020 16:04:45 +0200https://ask.libreoffice.org/en/question/261033/[Calc] How to highlight the minimum non-zero value in a row?https://ask.libreoffice.org/en/question/217435/calc-how-to-highlight-the-minimum-non-zero-value-in-a-row/I'm trying to highlight (as in change the background colour of the cell) the minimum non-zero value in a row of numbers. I can set up conditional formatting to do this, but whenever I add a new row of numbers, the formatting extends to include the new row (e.g. highlight minimum of range B2:B6, insert a new row below, range is now B2:C6). But the new row needs to be compared against itself and not any other rows (row B compared only to row B, row C compared only to row C, etc.). How can I do this without having to manually adjust the formatting for every single row of the worksheet whenever I add new rows?
And clone-formatting doesn't work for this either. It, also, changes the range of the formatting instead of applying the formatting to the new range (e.g. range B2:B6 gets cloned onto D2:D6, range is now B2:B6;D2:D6; it should be range B2:B6 and a separate rule for range D2:D6).
This is especially aggravating because I never had these problems in Office (it applied formatting exactly the way I expected it to) and I really don't want to shell out $100+ for an Office licence to fix this one issue.quaytsarFri, 15 Nov 2019 22:52:51 +0100https://ask.libreoffice.org/en/question/217435/determine min and max dates (date/month) froma series of dateshttps://ask.libreoffice.org/en/question/204431/determine-min-and-max-dates-datemonth-froma-series-of-dates/Hi
I'm hoping someone can help me with the following problem:
I have a series of dates in two columns and I would like to determine which is the min-date and max-date (based on day & month only[C:\fakepath\Min&max dates.ods](/upfiles/15656429372855606.ods)) over all years in each column.
See the attached sample spreadsheet.
The red-colored cells are manually edited to show the expected results.
Thanks in advance
Fred
drobbleMon, 12 Aug 2019 22:50:33 +0200https://ask.libreoffice.org/en/question/204431/Using the ‘min’ function, libreoffice calc prints the date value ‘03/18/1900’ instead of the correct ‘78’.https://ask.libreoffice.org/en/question/181207/using-the-min-function-libreoffice-calc-prints-the-date-value-03181900-instead-of-the-correct-78/ As explained I had trouble using the min functionTheo314Thu, 31 Jan 2019 09:39:15 +0100https://ask.libreoffice.org/en/question/181207/Calculating a block of cells with Calc?https://ask.libreoffice.org/en/question/24069/calculating-a-block-of-cells-with-calc/I need to perform calculations on a block of cells and return the minimum of all the calculations.
I need to divide D1 by A1, D2 by A2, D3 by A3....., then I need to get the minimum of those calculations and return either the entire row or the absolute row address where that minimum is found. Any suggestions?
delijantzenThu, 17 Oct 2013 23:41:45 +0200https://ask.libreoffice.org/en/question/24069/Find minimum value in a columnhttps://ask.libreoffice.org/en/question/5477/find-minimum-value-in-a-column/Need help writing a formula to find the minimum value in a column when the number of rows in the column varies. The cell below the last one in the column is blank, and there are no other blank cells above it. The starting row would be row 2 as row 1 contains headers.
Thanks
MalcolmitsonlymeSat, 01 Sep 2012 11:35:36 +0200https://ask.libreoffice.org/en/question/5477/