Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenMon, 04 Nov 2019 15:33:48 +0100max date=todayhttps://ask.libreoffice.org/en/question/215783/max-datetoday/ Hello,
In my form I have a 2 fields for dates. The first is for a reservation date and the second is when we accepted the reservation. The "Date Taken" field should never be higher than today's date. How can I set that field to be a date equal to or less than today?<br>
W10, LO 6.3.2.2, MySQL Backend<br>Thank youjodybingoMon, 04 Nov 2019 15:33:48 +0100https://ask.libreoffice.org/en/question/215783/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/Having trouble with the maximum text length in textboxes.https://ask.libreoffice.org/en/question/204547/having-trouble-with-the-maximum-text-length-in-textboxes/My text box has a maximum text length of 3,000. To test it, I filled out the box with a series of digits (1234567890) across the line and down the rows, but the total number of characters I entered is far less than the maximum text length I set for the box. So, is a "text length" anything between two spaces? How does this option work? What are its rules? hiloelaine@gmail.comTue, 13 Aug 2019 21:23:41 +0200https://ask.libreoffice.org/en/question/204547/calc csv limits for columnshttps://ask.libreoffice.org/en/question/182225/calc-csv-limits-for-columns/ there are columns to CA, but on opening I received a message saying I exceeded the maximum columns. It only imported to BU.effinsoftwareThu, 07 Feb 2019 14:53:20 +0100https://ask.libreoffice.org/en/question/182225/getting the highest value per cell from various sheetshttps://ask.libreoffice.org/en/question/158594/getting-the-highest-value-per-cell-from-various-sheets/ Hi guys
i need to solve the following
i have 3 tables fro a1 to p39 and all 3 sheets have different values.
how can i make that in sheet 4 i have the maximum values of each cell compared from all the 3 sheets?
thank youDany1000Thu, 21 Jun 2018 15:22:12 +0200https://ask.libreoffice.org/en/question/158594/maximum number of fields in query designerhttps://ask.libreoffice.org/en/question/127038/maximum-number-of-fields-in-query-designer/ I have a table with about 30 fields. When I go into query designer, I am only able to put in about 20! Why is there this limit? Or am I doing something wrong? Is there a way to expand it? I went in to the SQL and was able to add another field there. It then shows up in Design View. Would prefer not to have to code in all of the other fields.WayneRhodesSat, 26 Aug 2017 23:08:57 +0200https://ask.libreoffice.org/en/question/127038/How to get highest value using Libre Calchttps://ask.libreoffice.org/en/question/78528/how-to-get-highest-value-using-libre-calc/ Hi,
I am trying to work out how I can achieve a MAX() type selection on a range of cells, but limit the cells over which I perform the MAX() according to the value of the adjacent cell.
As a new member, I can't attach a jpg of what I mean, unfortunately, but here is a text description:-
Cells A1:A9 contain a random mix of "Apples", "Oranges" and "Bananas". Each cell in B1:B9 contain a number of fruit of the type contained in the adjacent "A" cell.
What I want is to put in Cell D1 (for example) the MAX() of the values in B1:B9, but only for (say) "Apples".
If I do MAX(B1:B9), I (rightly) get the simple highest value, regardless fo the type of fruit. What I need is some way to filter on the fruit and MAX() only matching cells.
Is there a reasonably simple way to do this without modifying (e.g. by sorting) the source data?
Thanks
Mickmick_dSun, 02 Oct 2016 18:04:37 +0200https://ask.libreoffice.org/en/question/78528/is it possible to modify the maximum page size in draw to be greater than 3m?https://ask.libreoffice.org/en/question/29980/is-it-possible-to-modify-the-maximum-page-size-in-draw-to-be-greater-than-3m/I work with documents which need to be greater than 3m and really would like to continue working with OO / LibreOffice but can't seem to see how documents can be legitimately created to be greater than the 3mkaty49Mon, 17 Feb 2014 14:11:05 +0100https://ask.libreoffice.org/en/question/29980/What is the filesize limit on a Calc file?https://ask.libreoffice.org/en/question/29766/what-is-the-filesize-limit-on-a-calc-file/I have a large Calcfile (>20MB) with 5 worksheets, the largest of which has an active array of formulas: 3120 rows and 639 columns. I am using XP and LibreOffice 4.2.0.4. When I try to expand the large array by copying many rows from the top of the array to append them to the bottom, I get odd behavior. After several minutes of apparent inactivity, the file vanishes without any comments or messges. That is, the file no longer appears as an open file. I tried increasing the swap file size to 4GB, but that did not help. Any suggestions?BuzzWed, 12 Feb 2014 16:27:20 +0100https://ask.libreoffice.org/en/question/29766/How can I add a function in LibreOffice Calc so that values of cells would not exceed calculated value of 20?https://ask.libreoffice.org/en/question/28628/how-can-i-add-a-function-in-libreoffice-calc-so-that-values-of-cells-would-not-exceed-calculated-value-of-20/I have spreadsheets calculating assumed development of some attributes. The value of an attribute should't exceed 20 but in some cases the development is so good it goes over the limit. How can I add there a function or something that limits all the values too high to appear as 20?v_markTue, 21 Jan 2014 11:31:19 +0100https://ask.libreoffice.org/en/question/28628/how many tab maximum in calchttps://ask.libreoffice.org/en/question/10028/how-many-tab-maximum-in-calc/I can't find how many tab i can create in the same calc sheet. Who can help me to known the answer ?VALISFri, 18 Jan 2013 17:57:55 +0100https://ask.libreoffice.org/en/question/10028/