Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenWed, 10 Apr 2019 17:24:48 +0200Does Calc add automatically sheet name in cell ranges used in functions?https://ask.libreoffice.org/en/question/189914/does-calc-add-automatically-sheet-name-in-cell-ranges-used-in-functions/I am using SUM() -function to calculate a sum from a cell range from the same sheet, like
=SUM(B6:B15)
At some point I noticed Calc automatically adding sheet name to cell range.
=SUM('Sheet one'.B6:B15)
Is Calc doing this automatically in some situations? I know sheet names are being updated if sheet they are referring to is changed, but if no sheet name is used in the first place?
This became a problem to me, as Calc did not highlight anymore referred cells of the function when selecting the function input line. After testig a bit, I noticed this is caused by the fact that sheet name used has a space (or any other special character) on it. When using a sheet name without special characters (and thus without hyphens), UI shows the selection correctly.
=SUM(SheetOne.B6:B15)
See attachment [referred-cells-highlight.ods](/upfiles/1554909746582334.ods)
Is this a bug in Calc?
I'm using
Version: 5.1.6.2
Build ID: 1:5.1.6~rc2-0ubuntu1~xenial6
CPU Threads: 4; OS Version: Linux 4.4; UI Render: default;
Locale: fi-FI (en_US.UTF-8); Calc: groupEddie AirheadWed, 10 Apr 2019 17:24:48 +0200https://ask.libreoffice.org/en/question/189914/Calc: multiple lines per row for print-friendly sheethttps://ask.libreoffice.org/en/question/188958/calc-multiple-lines-per-row-for-print-friendly-sheet/Dear all:
I am working on Google Contact CSV, it contains headers like
Name, Family Name, Given Name, Birthday, Group Membership E-mail 1 - Type, E-mail 1 - Value,E-mail 2 - Type ,E-mail 2 - Value,
Each row in Google Contact CSV contain ONE person's information
I want a way to automatically create a print-friendly, human-readable output on a separate sheet tab.
(my first tab contains the CSV entry I called "input", my 2nd tab contain the print friendly output, which I called "print")
In order to do so, I need to create a sheet that contains multiple lines PER row
Name, Family Name, Given Name
E-mail 1 Value
E-mail 2 Value
Address 1 Value
Phone 1 Value
Then, replicate them through out the rows
How do I do that using functions? My problem is the following
first entry is easy, everything is in the same row (let say, row 1), different values are in different column, no problem. But how do I reference the next row, row 2 in my "input" tab? mind you by the time I am done with my first entry, the I am already on row 6 in my "print" tab.
thanks in advance kngharvTue, 02 Apr 2019 08:23:16 +0200https://ask.libreoffice.org/en/question/188958/[Calc] How would I go about adding multiple functions to one keyboard shortcut?https://ask.libreoffice.org/en/question/182115/calc-how-would-i-go-about-adding-multiple-functions-to-one-keyboard-shortcut/[Windows 10, 64 bit, LibO version 6.2]
Javascript Developer, latest version of JRE
I'm trying to set up my keyboard shortcuts to copy the cells and delete the cells.
I cannot select multiple functions for the custom keyboard short cut, since I cannot do it this way, I'd like to create my own function to be listed for the keyboard shortcuts that allow me to copy all of the selected cells, and then delete them, or if it can be done, an explanation of how, I've considered custom macros outside of LibO that use a combination of different key strokes, but I would much rather employ those directly into LibO instead.
This isn't the entirety of the problem I'm attempting to resolve, it's just the clearest representation of what it is I am trying to do.crcordineWed, 06 Feb 2019 17:24:21 +0100https://ask.libreoffice.org/en/question/182115/New question on how can I get the total count [Solved]https://ask.libreoffice.org/en/question/180704/new-question-on-how-can-i-get-the-total-count-solved/ I am going to revise my question with a new sample. What I am trying to do is to count the items based on their current status. I cannot seem to "see" on how to do this.Thanks ahead for any and all suggestions.
[C:\fakepath\Item Total Count.ods](/upfiles/15485735712308065.ods)_daveSun, 27 Jan 2019 08:20:19 +0100https://ask.libreoffice.org/en/question/180704/Find Difference in two spreadsheetshttps://ask.libreoffice.org/en/question/179362/find-difference-in-two-spreadsheets/I have two large spreadsheets with similar data and structure but with small and undetermined differences.
Is there a ready function in Calc or some other tool which will locate and show these differences.Bill L.Tue, 15 Jan 2019 04:50:42 +0100https://ask.libreoffice.org/en/question/179362/Can I use LibreOffice Math to graph functionshttps://ask.libreoffice.org/en/question/178094/can-i-use-libreoffice-math-to-graph-functions/ I want to plot a simple function such as y = (x * x) +x + 1 on the screen and then hopefully to the printer using a range of values for x and an increment of my choosing.shoenig369Thu, 03 Jan 2019 04:41:49 +0100https://ask.libreoffice.org/en/question/178094/CALC. How to apply a function in cells where another cell in the row has a specific valuehttps://ask.libreoffice.org/en/question/172519/calc-how-to-apply-a-function-in-cells-where-another-cell-in-the-row-has-a-specific-value/Hi! Sorry if this was already asked. I know it's very basic, but I'm not able to solve it and didn't find a post about it.
I want to know the AVERAGE of the cells in column 'value' depending on the 'name'. Until now, I used to order column 'Name', so =AVERAGE(B1:B3) for µ and B4:B5 for ß, but I need to order my data constantly using other columns. Therefore, I would like to know how to select cells depending of the value of another cell in the same row. Something like AVERAGE in B1:B5 (the whole spreadsheet) WHERE column A = µ.
Could you help me?
Thanks!
A: NAME B: VALUE
µ 50
ß 90
µ 10
µ 7
ß 65kiko35Thu, 15 Nov 2018 11:25:50 +0100https://ask.libreoffice.org/en/question/172519/how to use exact function to compare a text value from a cell to a constant valuehttps://ask.libreoffice.org/en/question/156430/how-to-use-exact-function-to-compare-a-text-value-from-a-cell-to-a-constant-value/In cell C6 , I have the value "Shot" without the quotes. In another cell I have the formula as shown below
=IF(EXACT(C6,"Shot"),1,2)
always I get the result 2 irrespective of what value I have in cell c6
How do I compare the text value in cell c6 with the constant value "Shot" and return 1 if they are same and else 2
CNWed, 30 May 2018 02:05:57 +0200https://ask.libreoffice.org/en/question/156430/Minif and Maxif function in calchttps://ask.libreoffice.org/en/question/62260/minif-and-maxif-function-in-calc/On sheet one, I have a list of URLs, with duplicates in column B. In column J, I have dates visited.
On sheet two, I have a list of all the URLs from sheet 1, with no duplicates.
On sheet two, I want to lookup the highest date that a URL from sheet one matching the url from sheet two in one column, and the earliest date in another.
Something like:
A|B|C
URL|Most recent update|first checked
[url]|=maxif(S1.B2:B25001,a2,S1.J2:J25001)|=minif(S1.B2:B25001,a2,S1.J2:J25001)
I realize that there is no minif or maxif functions (or if there are, I haven't found them), but if someone could show me a way to implement something that would work in the same way as they might work, I would really appreciate it.
Oh yeah: Fully updated English language Windows 7 x64 Ultimate edition with Japanese locale, using LibreOffice v4.4.4.3 Calc with en_US locale.
Had no idea what tags I was supposed to use, so please forgive me if I used the wrong ones.ThorniestmaxThu, 24 Dec 2015 01:34:33 +0100https://ask.libreoffice.org/en/question/62260/How do I.... a1/b1=c1(round result to 2 places) then ..a2/b2=c2 without manually entering that in each c(x) cellhttps://ask.libreoffice.org/en/question/136216/how-do-i-a1b1c1round-result-to-2-places-then-a2b2c2-without-manually-entering-that-in-each-cx-cell/ I have some data on gas mileage of my car. I would like to move it from paper to a spreadsheet. if I could do it recursively ......a1{some operation}b1 = c1 .... then.... a2{same operation}b2 = c2 etc. etc. I would have to manually enter less data from my paper records. The car has an avg mpg meter also so I have been keeping track of actual vs. reported m/g. So in
general I need ... cell{function}cell =cell .... for each cell in a column. I really have looked in various tutorials for this but I can't find it.
P.S. does anyone know of a good book on libreoffice calc. Thanks in advance to any who can help.sam1951Fri, 27 Oct 2017 15:49:38 +0200https://ask.libreoffice.org/en/question/136216/Re: Calc - COS(), can this be fixed?https://ask.libreoffice.org/en/question/126338/re-calc-cos-can-this-be-fixed/ It is readily apparent that the COS() function is inaccurate (check COS(PI()/2).
I do not know if this is a system call, or an internal math library. Either way it can be fairly unhelpful for precision calculations. Also, SIN() on larger angles is not accurately handled (check: SIN(PI()) should return 0, it does not).
A work-around is to instead:
1) if angle > pi/2 then reduce it to QI and deal with sign issues separately
2) if COS(angle) is desired, call SIN(PI()/2 - angle) instead
Can the trig function accuracy be improved? Or, failing that, is there any hope of incorporating this into the program itself so that the function error is more transparent to the end-user? Any factor of pi/2 should be correct regardless of other floating point errors. (Many other functions you may care to perform rely upon factors of PI/2 cancelling out variables in those locations).PiHunter_LMThu, 24 Aug 2017 09:38:10 +0200https://ask.libreoffice.org/en/question/126338/Data Table Alternativehttps://ask.libreoffice.org/en/question/108060/data-table-alternative/Hi,
I'm finding an alternative to Excel Data Table, in Excel it appears in Data -> What-if Analysis -> Data Table.
This helps me to calculate the results of 1 cell with different values of 1 or 2 variables.
I post here a photo to understand it better:
![DataTable](http://imgur.com/a/FxmsK) http://imgur.com/a/FxmsK
On the top-left (A1) I write the cell that I want the results, and the row at the right (B1:V1) these are constants that uses the variable_A, below A1, the column from (A2:A22) these are constants that uses variable_B. And the body of the table are the combinations from variable_A and variable_B that gives A1.
ThankscranmaxTue, 04 Jul 2017 13:15:12 +0200https://ask.libreoffice.org/en/question/108060/search, match, and redirect resulthttps://ask.libreoffice.org/en/question/95353/search-match-and-redirect-result/beating my head against a wall trying to understand how to do this.
for every cell in column B, i want to search for a match in column A. for every match, i want to take the contents of the cell in column D on the same row as the key in column B, and put that result into the cell in column C on the same row as the match in column A.
unfortunately i don't have enough points to upload a file, but here's a link:
https://docs.google.com/spreadsheets/d/1IKLb_-mKUA8JEZ6w_reRY5scg6lgLv7d1dv4wX8FYTk/edit?usp=sharing
any help would be greatly appreciated.thefinn2003Tue, 16 May 2017 20:41:09 +0200https://ask.libreoffice.org/en/question/95353/How to find out if a search string is found as (part of a) content in a range of cells?https://ask.libreoffice.org/en/question/94268/how-to-find-out-if-a-search-string-is-found-as-part-of-a-content-in-a-range-of-cells/I would need a good formula for this for calc.inJesusFri, 05 May 2017 19:11:20 +0200https://ask.libreoffice.org/en/question/94268/How to find a description of a calc function fast by its name?https://ask.libreoffice.org/en/question/94309/how-to-find-a-description-of-a-calc-function-fast-by-its-name/ Would be great.inJesusSat, 06 May 2017 07:48:31 +0200https://ask.libreoffice.org/en/question/94309/LibreCalc- correspond few columns and rows across sheetshttps://ask.libreoffice.org/en/question/92272/librecalc-correspond-few-columns-and-rows-across-sheets/ Hello, I'm Libre Calc newbie that never went beyond SUM function. I have a complex and specified problem- I don't expect help, but if there is even a slight chance I'll get it, it's worth trying, **so**
I have three sheets:
- Governments revenues in domestic currency **(sheetA)**, ![](http://i.imgur.com/lGuHHvY.png)
- exchange rates- US$ per national currency **(sheetB)**, ![](http://i.imgur.com/ilXfWJx.png)
- and a sheet where I need government revenues shown in $dollars **(sheetC)**. ![image description](http://i.imgur.com/DIyRET3.png)
**SheetA** has columns with countries and revenue type listed (central gov/general) and rows with years listed. XY positions are different countries revenues in domestic currency in exact year. I need each XY position to correspond with **SheetB** which has three columns: country name, year and corresponding exchange rate.
Now I need to match **SheetA** country name column and year row with **SheetB** country name and year columns in a way that revenue in domestic currency **A** is multiplied by exchange rate **B** then value is returned to required **C** cell.
*Thus, **SheetC** is built like **SheetA** - two columns with country name and revenue type (central government/general) and one row with years, giving accurate **SheetA** XY positions. For curious- next I will compare 2000 private corporations and their factors with countries organisations in a scale of time, and try to make sense of their relative dynamics.*
zewnyFri, 07 Apr 2017 16:30:48 +0200https://ask.libreoffice.org/en/question/92272/How to make LibreOffice Calc treat empty cells as zeros when using ranges in formulas?https://ask.libreoffice.org/en/question/92199/how-to-make-libreoffice-calc-treat-empty-cells-as-zeros-when-using-ranges-in-formulas/I need to take the minimum over a range of cells, treating empty cells as zeros. However, both `MIN` and `MINA` functions ignore empty cells (in LibO 5.1). What can I do?
More precisely, what I currently need is to calculate the minimum of each line in a table treating empty cells as `0` and to store the results in the last column.alexeymuranovThu, 06 Apr 2017 17:16:10 +0200https://ask.libreoffice.org/en/question/92199/COUNTIF criteria evaluation - function applied on range cells?https://ask.libreoffice.org/en/question/85416/countif-criteria-evaluation-function-applied-on-range-cells/ My friend asked me for help and we only found a solution we don't like 100%.
**Problem:**
I have a table with angle values in degrees (0, 10, 20, ..., 180) - that is range A2:A20. I want to use COUNTIF to tell me, how many of these have SIN > 0,95.
**My solution:**
In column B I use RADIANS to convert degrees to radians. In column C I calculate the SIN value. Then I can write COUNTIF(C2:C20;">0,95").
I don't like this solution because I had to add two extra columns that hold values I don't need to see, I only have them so that COUNTIF can tell me what I need.
![image description](http://i.imgur.com/0vRnsC5.png)
----------
**Anything like this?**
I was hoping for something like this:
- COUNTIF(SIN(RADIANS(A2:A20)); "> 0,95") or better
- COUNTIF(A2:A20; "SIN(RADIANS(value))>0,95")
The "value" would be the value of the evaluated cell. In ">0,95" you can feel this keyword... "value > 0,95"... but not having it means not being able to apply functions to it.
Is there a better solution to my problem?Michal PtákWed, 11 Jan 2017 15:31:36 +0100https://ask.libreoffice.org/en/question/85416/calc - copy formulae without adjustinghttps://ask.libreoffice.org/en/question/83352/calc-copy-formulae-without-adjusting/ So I have prepared a summary sheet with some really nasty formulae that reference other sheets in the same file.
In their simplest form, they are of the form
=AVERAGE(OFFSET($mw_rep0.E:E,$B$8,0,$B$9-$B$8,1)~OFFSET($mw_rep1.E:E,$B$8,0,$B$9-$B$8,1)~OFFSET($mw_rep2.E:E,$B$8,0,$B$9-$B$8,1))
In the uglier versions, they come as
=PERCENTILE(OFFSET($mw_rep0.B:B,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep0.C:C,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep0.D:D,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep0.E:E,$B$8,0,$B$9-$B$8,1)~OFFSET($mw_rep1.B:B,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep1.C:C,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep1.D:D,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep1.E:E,$B$8,0,$B$9-$B$8,1)~OFFSET($mw_rep2.B:B,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep2.C:C,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep2.D:D,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep2.E:E,$B$8,0,$B$9-$B$8,1),0.9)
and need to be entered with ``CTRL+SHIFT+ENTER``.
As I have other files that need the same kind of summary but for THEIR sheets, I have named the sheets in these files accordingly.
So I ``CTRL+A, CTRL+C``, switch to the other document and ``CTRL+V``.
Works "great", *EXCEPT* all the sheet references have been prefixed by the file name (i.e. ``$mw_rep0`` becomes ``'file:///home/.../myFirstDocument.ods'#$mw_rep0``), which in turn results in most cells displaying ``Err:502`` instead of the calculated values from the new sheet.
How do I copy the sheet WITHOUT doing that transformation? I can't copy-paste each cell's formula one-by-one into all the files that need them because I kind of need to get done before I die of old age.DiesNutsWed, 07 Dec 2016 15:05:02 +0100https://ask.libreoffice.org/en/question/83352/calc - #value when computing vector percentiles?https://ask.libreoffice.org/en/question/83351/calc-value-when-computing-vector-percentiles/The range below basically say "cut off everything before ``$B$8`` and everything after ``$B$9$`` and for the remaining, sum columns ``I,J`` where the values are distributed over multiple sheets (3 in this case, "mw_rep0", "mw_rep1", "mw_rep2").
``OFFSET($mw_rep0.I:I,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep0.J:J,$B$8,0,$B$9-$B$8,1),OFFSET($mw_rep1.I:I,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep1.J:J,$B$8,0,$B$9-$B$8,1),OFFSET($mw_rep2.I:I,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep2.J:J,$B$8,0,$B$9-$B$8,1)``
I will refer to this as ``range1`` (though I have to copy-paste it to use it because apparently, you cannot create a name for it).
So ``=AVERAGE(range1)`` entered with ``CTRL+SHIFT+ENTER`` will calculate me the average sum.
Now I want percentiles. To that end, I modify ``range1`` such that the terms for each sheet are separeted by ``~``, rather than by ``,``:
e.g: ``=PERCENTILE(OFFSET($mw_rep0.I:I,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep0.J:J,$B$8,0,$B$9-$B$8,1)~OFFSET($mw_rep1.I:I,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep1.J:J,$B$8,0,$B$9-$B$8,1)~OFFSET($mw_rep2.I:I,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep2.J:J,$B$8,0,$B$9-$B$8,1),0.9)``
when I enter *this* with ``CTRL+SHIFT+ENTER``, I get ``#VALUE!``.
Which I find strange because I have an even uglier range summing up columns ``B,C,D,E``, for which this works:
``OFFSET($mw_rep0.B:B,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep0.C:C,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep0.D:D,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep0.E:E,$B$8,0,$B$9-$B$8,1),OFFSET($mw_rep1.B:B,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep1.C:C,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep1.D:D,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep1.E:E,$B$8,0,$B$9-$B$8,1),OFFSET($mw_rep2.B:B,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep2.C:C,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep2.D:D,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep2.E:E,$B$8,0,$B$9-$B$8,1)``
I will refer to this as ``range0``.
Here, both, ``=AVERAGE(range0)`` and percentiles (for which we again modify ``range0`` such that the individual sheets' terms are separated by tilde, rather than comma) work.
e.g. ``=PERCENTILE(OFFSET($mw_rep0.B:B,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep0.C:C,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep0.D:D,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep0.E:E,$B$8,0,$B$9-$B$8,1)~OFFSET($mw_rep1.B:B,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep1.C:C,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep1.D:D,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep1.E:E,$B$8,0,$B$9-$B$8,1)~OFFSET($mw_rep2.B:B,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep2.C:C,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep2.D:D,$B$8,0,$B$9-$B$8,1)+OFFSET($mw_rep2.E:E,$B$8,0,$B$9-$B$8,1),0.9)``
So how do I get the percentiles working in the "easier" case?DiesNutsWed, 07 Dec 2016 13:56:25 +0100https://ask.libreoffice.org/en/question/83351/Need help with Libre functionshttps://ask.libreoffice.org/en/question/80593/need-help-with-libre-functions/Thanks in advance for help.
Here is what I am trying to do.
If cells D2 through M2 are all empty then leave designated cell empty regardless of other circumstances. If cells D2 through M2 are not empty and the SUM of cells D2 through M2 is zero, then enter “OK”. If cells D2 through M2 are not empty and the SUM of cells D2 through M2 is not zero, then enter “Error”.
When I enter
=IF(D2:M2="","",IF(SUM(D2:M2)=0,"OK';"error""))
I get Err:508
Help is appreciatedCalcasieuFri, 28 Oct 2016 23:49:40 +0200https://ask.libreoffice.org/en/question/80593/How do I derive a text day (Monday, Tuesday,...) from a date field (7/21/2016)https://ask.libreoffice.org/en/question/73716/how-do-i-derive-a-text-day-monday-tuesday-from-a-date-field-7212016/So far, I have a long, complicated "IF" statement, using WEEKDAY()..
There must be an easier way!EasyRiderThu, 21 Jul 2016 15:49:17 +0200https://ask.libreoffice.org/en/question/73716/Multiplication in function returning boolean valuehttps://ask.libreoffice.org/en/question/76539/multiplication-in-function-returning-boolean-value/I am trying to write a function to sort through a list of abbreviated numbers using K and M, and converting these into numbers (e.g. 3.4K, .98M --> 3400, 980000). However, for some reason, when I add the multiplication to the function, instead of returning a number, it returns a boolean value.
So for instance, where A2 = 2.3K, the function
#####`=IF(ISNUMBER(SEARCH("K",A2)), LEFT(A2,LEN(A2)-1), IF(ISNUMBER(SEARCH("M",A2)), LEFT(A2,LEN(A2)-1), "ERROR"))`
returns 2.3, but the function
#####`=IF(ISNUMBER(SEARCH("K",A2)), (LEFT(A2,LEN(A2)-1) * 1000), IF(ISNUMBER(SEARCH("M",A2)), (LEFT(A2,LEN(A2)-1) * 1000000), "ERROR"))`
returns TRUE. Furthermore, the function
#####`=LEFT(A2,LEN(A2)-1)*1000`
returns 2300.
How can this be? Thanks!GuribotSun, 04 Sep 2016 05:52:06 +0200https://ask.libreoffice.org/en/question/76539/How to output a date as text string in a specified format?https://ask.libreoffice.org/en/question/75840/how-to-output-a-date-as-text-string-in-a-specified-format/I'm trying to concatenate text with dates.
I found this question which https://ask.libreoffice.org/en/question/21962/calc-how-to-copy-a-date-format-in-a-text-string/ helps me half the way. Using the function TEXT I can covert a date to a text string. But it only seems to work with yyyy-mm-dd as format. How can I get a text string in the dd.mm.yyyy format?FreeMindedThu, 25 Aug 2016 18:18:17 +0200https://ask.libreoffice.org/en/question/75840/How to setup 2 different calculation functions with a drop down menu or 2 radio buttonshttps://ask.libreoffice.org/en/question/68943/how-to-setup-2-different-calculation-functions-with-a-drop-down-menu-or-2-radio-buttons/ I would like to create a list drop down with Male and Female. Which I figured out how to do but what I dont know is if they chose male in the drop down that it calls calculation function and if they chose female it uses a different calculation formula.jeepnjeffThu, 28 Apr 2016 15:22:33 +0200https://ask.libreoffice.org/en/question/68943/Is there a function in Calc to get the cell comments content?https://ask.libreoffice.org/en/question/53947/is-there-a-function-in-calc-to-get-the-cell-comments-content/ Hi.
I would like to know if there is some function in Calc that get the content of the comments of one specific cell.
I need this because I want to copy the comment content to another cell, but I need this content as a cell content, not as a comment content, ok?
For example, the cell B2 content's is "lion", and there is a comment in cell B2 that says "It's a kind of animal". I intend to copy the phrase "It´s a kind of animal" to cell C2.
Best regards.Felipe EckhardThu, 30 Jul 2015 19:15:30 +0200https://ask.libreoffice.org/en/question/53947/Why, in French, does the combo of functions SI(EXACT(cell1,text);cell2;cell3) returns a boolean instead of cell2 or cell3?https://ask.libreoffice.org/en/question/53664/why-in-french-does-the-combo-of-functions-siexactcell1textcell2cell3-returns-a-boolean-instead-of-cell2-or-cell3/ LibreOffice 4.2.8.2
Build ID: 420m0(Build:2)
Example, in D2, E2, F2:
12,8 | DEBIT | VRAI [=SI(EXACT(E2;"DEBIT");D2;"")]
Interestingly, the result specified in the function wizard is correct...
Cheers,
JPP
JPPSat, 25 Jul 2015 22:06:25 +0200https://ask.libreoffice.org/en/question/53664/WORKDAY and NETWORKDAYS crash Calchttps://ask.libreoffice.org/en/question/51892/workday-and-networkdays-crash-calc/Is this a genuine problem or am I missing a setting?
I have a small spreadsheet that uses the WORKDAY() and NETWORKDAYS() functions. In LibO 4.4.3 (English), when I close Calc I get a Windows error message "LibreOffice has stopped working". If I remove those functions, the error doesn't happen.
I've reverted to 4.2.3.2 (from around the last time I was working on a similar file) and the problem goes away.
Windows 7 64-bit English. oboistSat, 13 Jun 2015 11:43:28 +0200https://ask.libreoffice.org/en/question/51892/is there a function that can count unique values within a specific column accross multiple tabs in a spreadsheet and also count how many of each unique value there are?https://ask.libreoffice.org/en/question/50842/is-there-a-function-that-can-count-unique-values-within-a-specific-column-accross-multiple-tabs-in-a-spreadsheet-and-also-count-how-many-of-each/ I have multiple tabs in one sheet of clients and would like to find some way to count each unique item ( instance of a client name) from multiple tabs in a spread sheet. Also would like to be able to count how many of each unite client name there are. Further if it is possible to also have these results sorted by tab name and totaled would be awesome. If this is possible in libre office great, if not, I would simply love to know if there is a possibility for this and how to achieve it. This way I could know how many times any unique client name appears in the whole sheet, how many times in each individual tab and which one.bodelibreTue, 19 May 2015 22:58:47 +0200https://ask.libreoffice.org/en/question/50842/Are standard functions in Calc defined by the Open Document Spreadsheet definition?https://ask.libreoffice.org/en/question/50426/are-standard-functions-in-calc-defined-by-the-open-document-spreadsheet-definition/For the sake of document longevity, I was wondering if the functions in Calc are defined by any standards or that they are specific to the implementation of LibreOffice (and/or OpenOffice). If they are, it should not matter with what software (version) formulas in spreadsheets are written.
If they are not standard functions, or if not all functions are standardised, how can users ensure formula output is usable across ODS implementations and durable over the longer term?bencompFri, 08 May 2015 16:18:14 +0200https://ask.libreoffice.org/en/question/50426/