Ask Your Question

SM_Riga's profile - activity

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