Ask LibreOffice - RSS feed and answers for LibreOfficeenMon, 29 Apr 2019 17:16:12 +0200How to Reference the value of the filter in autofilter? the [attached example Reference data in autofilter.ods](/upfiles/15565505848811236.ods) Is there a way for cell A1 to display "Data belonging to Acme" or "Data belonging to MGM" depending on which filter I have active in the autofilter? FYI, the end result is that every month I will have a table like this, and then I need to export and print one sheet per client. Best solution I found so far is to filter by client, then export a PDF of it. migueldealmeidaMon, 29 Apr 2019 17:16:12 +0200 to copy formula from calc to excel Is any way copy the formula from calc to excelseichingWed, 20 Mar 2019 14:05:51 +0100 ranges from Excel sheet was working earlier. Now it has stopped working. ranges from Excel was working fine earlier. Working on Excel 2016 OpenLibre 5.0 can some one please tell me what settings need to be changed for it to work.[C:\fakepath\sample_Excel.xlsx](/upfiles/15287024548174887.xlsx) you will see that the pie chart and the bar chart in the excel is supposed to update automatically. it is using named ranges. the same thing with formulas assigned to text boxes. (in the last page) they all worked fine last week. now it does not! :(akadidalSat, 09 Jun 2018 06:04:33 +0200 it possible to convert a text string to a formula? it possible to convert text to a formula or to otherwise run a formula in a different cell? I am working on a series of spreadsheets for an RPG, each fine contains a dozen or so character sheets with identical formulae if I want to change one formula I have to then go through every player character and non-player Character sheet and paste in the new formula, is it possible to emulate Excel's Evaluate function? for example, Formulas.B2 contains the formula =MID(CELL("filename",A1),FIND("$",CELL("filename",A1))+1,255) would it be possible to have something along the lines of =Evaluate(Formula($Formulas.B1)) that way only writing the formula once without having to make it a named expression it would also mean that canges to any formual will impact all sheets rather than one sheet at a time?hhaddowThu, 22 Feb 2018 17:14:49 +0100 err 504 with complex function am using a file created in excel and when I go to use the file in calc I am getting err 504 from many formulas. The formulas use info contained inside sheets and tables in the file. =IF(ISBLANK(B9),"",VLOOKUP(B9,grains_table[#all],6))dhuskyThu, 11 Jan 2018 19:06:45 +0100 to create a custom formula? searching and didn't get anything so I apologize if this is already covered. I feel like what I'm looking for is pretty simple. Trying to make our company time sheet more simple. I need to create a formula (or multiple) that basically says Company A = Group A, Company B = Group C, Company C= Group B, etc. So when someone selects Company A from the drop down menu in cell B2, in the corresponding cell B4, Group A automatically populates. I tried searching youtube and found videos about conditional formatting and creating a formula within the developer section, but frankly I didn't really understand. Hoping one of you good folks can give me a hand. *Edit* Alright trying to wrap my head around what you said. If I'm just too simple for this, please don't hesitate to tell me. They can pay someone else to do this if they have to. I have my lookup table created, but I don't understand the formula. I'm going to try and explain it very simply and hopefully you can tell me where I'm wrong or what I need to do. I've got all the companies listed in column A and their corresponding group in column B. What would the formula be to assign value? Then tell me if this is correct. On my billing sheet I'd put this formula into a cell in Column D which is where the group name goes for the company listed in Column B in the corresponding row. =VLOOKUP(B2;A1:B192;2;0) - Admittedly, I don't understand the formula, just pasting from your comment while changing the value to match my lookup sheet. *Edit #2* I've attached a version of my spreadsheet that has sensitive info removed for privacy concerns. As for the formula, I don't have one myself, just copied and pasted what was given on here. I tried both given and one gave me a "Err:511" and the other "#N/A".[C:\fakepath\example.ods](/upfiles/1514936983706269.ods)jtysonSat, 30 Dec 2017 10:10:42 +0100 do I lookup and return a most recent value?, I am working on a spreadsheet in which I need a formula to return the most recent value in a row from a lookup. I have had the formula working whilst I have been using the lookup function using Microsoft Excel but when i have transferred my file over to Libre the formula's no longer work. The excel formula I have been using is LOOKUP(2,1/($A$1:A5=A6),$B$1:B5)). Sheet as follows: A1 = A B1 = 10 A2 = B B2 = 20 A3 = A B3 = 15 A4 = C B4 = 12 A5 = D B5 = 30 A6 = ????? Cell B6 should be able to return a value of 15 and does so using the above formula in excel but using Libre I get #value. I can only seem to get the Libre LOOKUP function to return a value of 10 or #value. Can you please tell me how I get Libre to perform the same function as excel can. Regards, Mark mark.simpson.3572Fri, 20 Mar 2015 00:35:13 +0100 function predictive type and autocomplete When I use Ms excel and type a new formula into a cell, the editor has a predictive algorithm that shows the formula that it thinks I might be trying to use. If this formula is indeed the one I'm searching for, then I just hit *tab* and the formula automatically completes. Is there an option in LibreOffice Calc that could provide a similar behavior? Thank you.AugustinWed, 13 Nov 2013 23:19:38 +0100 error office vs calc everyone first of all sorry for my bad english... I have a problem.. I work with 10 files, something like 1 server file and 9 client files linked to the server file to sum the numbers contained in every one The problem is: if I open one of those with **excel** and I accept to upgrade everything works but if I do the same with **calc** it's like I lose formula and I have something like #REF The same happens if I prepare a file with **calc** at home and then try to use with **office** at work where I have both installed but can't use **calc** with this files Do you have some good advice?? TkschanceThu, 28 Mar 2013 22:00:27 +0100 with Excel compatibility?! Calc have COUNT.IF and SUM.IF (or CONTAR.SI and SUMAR.IF in spanish version of Calc) but not AVARAGE.IF! so, What solution could I use to solve this? (hopefully, with compatibility with Excel)ShackraWed, 09 May 2012 00:44:11 +0200