2019-03-20 21:23:44 +0100 edited answer Data > Group on Pivot table creates a mirror date column instead of grouping into hours Hello @Tobruk Make sure your date column holds actually date/time values, not text string representing date. That is t 2019-03-20 21:23:33 +0100 edited answer Data > Group on Pivot table creates a mirror date column instead of grouping into hours Hello @Tobruk Make sure your date column holds actually date/time values, not text string representing date. That is t 2019-03-20 21:07:35 +0100 answered a question Data > Group on Pivot table creates a mirror date column instead of grouping into hours Hello @Tobruk Make sure your date column holds actually date/time values, not text string representing date. That is t 2019-03-09 22:17:59 +0100 commented question Counting duplicate numbers in various rows on a sheet Hi there. I am not sure if I understood your logic. 1. Single cells do not qualify for counting duplicates, correct? Oth 2019-03-09 20:48:43 +0100 commented answer hide columns via code Here are some samples to define range object: theRange = ThisComponent.Sheets(0).getCellRangeByName("A:E") 'Get sheet b 2019-03-09 19:54:04 +0100 commented answer Is there a way to get a subrange from a given range, specifically a named range? I also tried other solutions with tildes (~) inside one single INDEX() function, but with no result other than 2019-03-01 10:10:26 +0100 edited answer Averageif and Weekday Hello @steveTu You can use WEEKDAY function and pass there cell range address as first parameter. This is called an arr 2019-03-01 10:10:06 +0100 edited answer Averageif and Weekday Hello @steveTu You can use WEEKDAY function and pass there cell range address as first parameter. This is called an arr 2019-03-01 10:09:34 +0100 answered a question Averageif and Weekday Hello @steveTu You can use WEEKDAY function and pass there cell range address as first parameter. This is called an arr 2019-02-28 14:58:58 +0100 commented answer tabs deleted upon saving A bit of correction - saving multiple-sheet spreadsheet to CSV will save currently active sheet, not the first one and w 2019-02-28 14:58:32 +0100 commented answer tabs deleted upon saving A bit of correction - saving multiple-sheet spreadsheet to CSV will save currently active sheet, not the first one and w 2019-02-27 10:04:55 +0100 commented answer calc, large numbers show as 2E+05 3E+05 Oh no, the link I provided is about changing representation from scientific notation to general numbers, I didn't see co 2019-02-27 08:52:08 +0100 commented answer calc, large numbers show as 2E+05 3E+05 Yes, that is correct. While Calc can not fit general number in cell's width, but can fit scientific notation -scientific 2019-02-27 06:36:54 +0100 commented question calc, large numbers show as 2E+05 3E+05 This is the scientific notation. Please see if this can help. You can remove all irrelevant information from copy of you 2019-02-27 06:33:42 +0100 commented question calc, large numbers show as 2E+05 3E+05 This is the scientific notation. Please see if this can help. 2019-02-23 10:13:07 +0100 edited answer how do I find the top 10 values including duplicates along with names. Hello @dwood505 This could be easily done using Pivot Table functionality. Please find these Sample spreadsheet attache 2019-02-23 10:10:58 +0100 answered a question how do I find the top 10 values including duplicates along with names. Hello @dwood505 This could be easily done using Pivot Table functionality. Please find these Sample spreadsheet attache 2019-02-21 22:59:52 +0100 commented answer [SOLVED] Retreiving data from different column every month Please mark @Opaque answer as accepted then. You have closed this question as answered, while no answer is accepted. Tha 2019-02-20 15:54:28 +0100 commented question what is the formula to calculate a simple spreadsheet Changed tag to Calc 2019-02-18 22:11:40 +0100 commented answer SPLIT CELLS (HOURS) It is possible to use HOUR(), MINUTE() and SECOND() functions in case the result shall be in numeric format. MINUTE(A1) 2019-02-16 10:34:09 +0100 commented question error in calc: what's wrong? You will always get Left work result with this formula. "exited"="entered" test condition will always return False. What 2019-02-15 08:11:37 +0100 commented question LibreOffice Calc Macro to Remove Link and Formulas Edited code for readability 2019-02-15 08:11:29 +0100 commented question LibreOffice Calc Macro for the Excel Macro Edited code for readability 2019-02-15 08:10:57 +0100 edited question LibreOffice Calc Macro for the Excel Macro LibreOffice Calc Macro for the Excel Macro I used the following Macro Code in MS-Excel to insert = sign. Sub MakeFmla() 2019-02-15 08:08:51 +0100 edited question LibreOffice Calc Macro to Remove Link and Formulas LibreOffice Calc Macro to Remove Link and Formulas I used following Macro in MS-Excel to remove link and formulas and pa 2019-02-14 21:01:45 +0100 edited answer How to refer to slice within named column? Hello @Cerin While INDEX function allows you to refer one single cell (when row or column parameter is defined and is n 2019-02-14 20:46:33 +0100 edited answer How to refer to slice within named column? Hello @Cerin While INDEX function allows you to refer one single cell (when row or column parameter is defined and is n 2019-02-14 20:44:40 +0100 answered a question How to refer to slice within named column? Hello @Cerin While INDEX function allows you to refer one single cell (when row or column parameter is defined and is n 2019-02-13 21:30:22 +0100 edited answer Select values from cells according to contents of other cells Hello, @galaxian You can use formula =INDEX(P1:R1;0;MATCH(MAX(A1:C1);A1:C1;0)) --- Edit --- Please note that if there 2019-02-13 21:29:24 +0100 edited answer Select values from cells according to contents of other cells Hello, @galaxian You can use formula =INDEX(P1:R1;0;MATCH(MAX(A1:C1);A1:C1;0)) --- edit --- Please note that if there 2019-02-13 20:59:11 +0100 answered a question Select values from cells according to contents of other cells Hello, @galaxian You can use formula =INDEX(P1:R1;0;MATCH(MAX(A1:C1);A1:C1)) 2019-02-10 13:23:07 +0100 answered a question selecting a date range for an advanced filter Hello @Peter Keogh A filter with 2 columns headed "Date" holding criteria of the lower and upper limits does not 2019-02-09 13:10:15 +0100 commented question How do I fix 2 different macros not working properly on 2 PCs? Try to spot the problem cause and try to run problematic macro directly, go to Tools > Macros > Run macro, select 2019-02-08 17:39:50 +0100 commented answer Why is this SUMIF not working? SUMPRODUCT function returns the sum of the products of corresponding array elements - ir calculates product of first ele 2019-02-08 12:37:34 +0100 commented answer Why is this SUMIF not working? SUMPRODUCT function returns the sum of the products of corresponding array elements - ir calculates product of first ele 2019-02-07 16:15:06 +0100 commented answer Why is this SUMIF not working? Voted for SUMPRODUCT solution. To @ptoye Wonder why row78 and row80 are considered as correct in the question. "<> 2019-02-07 15:43:31 +0100 commented question LibreOffice - Comparing Records Hello @donpaul0110 The information provided is not enough to give you the correct answer. What is the identifier/key, wh 2019-02-07 15:11:33 +0100 commented question Why is this SUMIF not working? Hello @ptoye Does condition ">0" return correct result? 2019-02-06 23:26:57 +0100 answered a question csv freezing Calc Hello @limaunion The sample provided has only one common thing with standard comma separated values structure, it is f 2019-02-06 21:52:03 +0100 edited answer Calc: Conditional Formatting based on cell above Hello @wootowl Assuming your data range is A1:A30 Select cells A2:A30, go to Conditional Formatting dialog and add a co 2019-02-06 21:50:00 +0100 answered a question Calc: Conditional Formatting based on cell above Hello @wootowl Assuming your data range is A1:A30 Select cells A2:A30, go to Conditional Formatting dialog and add a co 2019-02-06 12:46:43 +0100 edited question Do not show #Value! DONT SHOW #VALUE! Hello im having some trouble with office calc. As you can see bellow on the image i am getting as a re 2019-02-06 12:41:59 +0100 answered a question Do not show #Value! Hello @kik94 You can nest your formula in IFERROR formula to display something different, than error code if some error 2019-02-05 20:51:29 +0100 commented answer Convert field from text to numeric values in Calc 6 Had hoped that fields in the CSV file surrounded by quotation marks ("") should be autiomatically interpreted a 2019-02-05 20:50:42 +0100 commented answer Convert field from text to numeric values in Calc 6 Had hoped that fields in the CSV file surrounded by quotation marks ("") should be autiomatically interpreted a 2019-02-05 12:13:52 +0100 edited answer Duplicate Sheet changes Sheet References This is exactly absolute/relative cell references what you are talking about. Placing $sign before sheet name gives you 2019-02-05 12:08:10 +0100 edited answer Duplicate Sheet changes Sheet References This is exactly absolute/relative cell references what you are talking about. Placing$ sign before sheet name gives you 2019-02-05 12:07:46 +0100 answered a question Duplicate Sheet changes Sheet References That is exactly absolute/relative cell references what you are talking about. Placing \$ sign before sheet name gives you 2019-02-04 21:27:50 +0100 answered a question How can I get the current cell Column letter ? Hello @fabe. The thing goes weird, cause =CHAR(column()+64) formula returns a character from ASCII table according to n 2019-01-25 23:36:47 +0100 commented answer calc data advanced filter/ needs exact match to extract Oh, it's just fine! :) RegEx is not my favorite thing and your answer on Regular expressions part is much more informati