Ask Your Question

SM_Riga's profile - activity

2019-01-15 23:55:21 +0100 edited answer Sort Data by Background Color

Hello @libreofficeUser30872 Your research should also include this topic and end there with the answers of @librebel an

2019-01-15 23:54:37 +0100 answered a question Sort Data by Background Color

Hello @libreofficeUser30872 Your research should also include this topic and end there with the answers of @librebell a

2019-01-14 21:03:46 +0100 commented answer How to copy Row 1 and Paste Row 2,3 loop till end?

The idea would be the same in code also. I will add info a bit later

2019-01-14 20:53:49 +0100 answered a question How to copy Row 1 and Paste Row 2,3 loop till end?

Hello @shodge You can achieve goal easily without any coding. Step 1. Add helper column before data range and fill it

2019-01-14 18:33:12 +0100 commented answer Running a recorded macro gives strange results

Edited an answer to explain how to adjust Sheet selection in the sample code

2019-01-14 18:31:30 +0100 edited answer Running a recorded macro gives strange results

Hello @fritsje25 Macro recorder has a very limited functionality and is of a little use even with such a simple tasks a

2019-01-14 18:15:18 +0100 commented answer Running a recorded macro gives strange results

While I do fully agree with @Lupp about less code = better spreadsheet statement, sometimes you need to code some script

2019-01-14 16:33:33 +0100 edited answer Running a recorded macro gives strange results

Hello @fritsje25 Macro recorder has a very limited functionality and is of a little use even with such a simple tasks a

2019-01-14 16:16:06 +0100 edited answer Running a recorded macro gives strange results

Hello @fritsje25 Macro recorder has a very limited functionality and is of a little use even with such a simple tasks a

2019-01-14 16:14:34 +0100 answered a question Running a recorded macro gives strange results

Hello @fritsje25 Macro recorder has a very limited functionality and is of a little use even with such a simple tasks a

2019-01-13 23:46:20 +0100 received badge  Organizer (source)
2019-01-11 23:16:10 +0100 commented question how to get around white space problem

Why do state that it is ISBLANK issue? Try to divide formula to pieces and test each of them to determine #VALUE! cause.

2019-01-11 23:13:14 +0100 commented question how to get around white space problem

Why do state that it is ISBLANK issue? Try to divide formula to pieces and test each of them to determine #VALUE! cause.

2019-01-11 23:12:52 +0100 commented question how to get around white space problem

Why do state this it is ISBLANK issue? Try to divide formula to pieces and test each of them to determine #VALUE! cause.

2019-01-11 15:26:35 +0100 commented question For Mac OS X 14 in Writer document find & replace functions fail.

What is your LO version? Version: 6.1.3.2 OS, Mac OS X 10.14.2 - all works fine.

2019-01-11 15:17:24 +0100 commented answer Page up/down in LibreOffice spreadsheet, Mac - how to

I am the same user as you are :) You can always edit your own question, adding new details (images and files as well), c

2019-01-11 14:49:44 +0100 commented answer Page up/down in LibreOffice spreadsheet, Mac - how to

Please edit you own question in case additional information comes into play. Do not use answer section for this, cause i

2019-01-11 14:42:38 +0100 edited answer Page up/down in LibreOffice spreadsheet, Mac - how to

Hello @AnneEst Select Tools -> Customize... in menu, then go to Keyboard tab. There you can check, assing or modify

2019-01-11 14:15:03 +0100 commented answer Page up/down in LibreOffice spreadsheet, Mac - how to

I am using Apple full-size keyboard with Navigation and Numeric keypads, so in my LO there are separate keys assigned to

2019-01-11 14:14:33 +0100 commented answer Page up/down in LibreOffice spreadsheet, Mac - how to

I am using Apple full-size keyboard with Navigation and Numeric keypads, so in my LO there are separate keys assigned to

2019-01-11 13:45:55 +0100 edited answer Page up/down in LibreOffice spreadsheet, Mac - how to

Hello @AnneEst Select Tools -> Customize... in menu, then go to Keyboard tab. There you can check, assing or modify

2019-01-11 13:43:36 +0100 answered a question Page up/down in LibreOffice spreadsheet, Mac - how to

Hello @AnneEst Select Tools -> Customize... in menu, then go to Keyboard tab. There you can check, assing or modify

2019-01-11 06:35:16 +0100 commented answer How to find the Date of Sunday of the current week.

I thought of =TODAY()-WEEKDAY(TODAY(),2) Was bit confused of X :)

2019-01-11 06:34:49 +0100 commented answer How to find the Date of Sunday of the current week.

I thought of =TODAY()-WEEKDAY(TODAY(),2)

2019-01-10 21:35:42 +0100 edited answer How to escape double quote in INDIRECT()

Hello @-rob- To escape double quotes you need to use triple or quadruple quotes, it depends, please see image for refe

2019-01-10 21:34:54 +0100 edited answer How to escape double quote in INDIRECT()

Hello @-rob- To escape double quotes you need to use triple or quadruple quotes, it depends, please see image for refe

2019-01-10 20:46:41 +0100 edited answer How to escape double quote in INDIRECT()

Hello @-rob- To escape double quotes you need to use triple or quadruple quotes, it depends, please see image for refe

2019-01-10 20:43:36 +0100 answered a question How to escape double quote in INDIRECT()

Hello @-rob- To escape double quotes you need to use triple or quadruple quotes, it depends, please see image for refe

2019-01-09 21:07:49 +0100 commented answer Drop Menus that Filter Subsequent Drop Down Menus

I have added updated spreadsheet, where you can select categories before performing data filtering.

2019-01-09 21:04:52 +0100 edited answer Drop Menus that Filter Subsequent Drop Down Menus

Hello @Roly You can use a Data -> Validity... tool to define allowed entries for each of the three cells where each

2019-01-09 12:40:40 +0100 commented answer How to calculate an additive tax in Calc?

I also like @Lupp method better, cause it is not so obvious as VLOOKUPs, so it seems more interesting to me :) Voted for

2019-01-08 23:22:05 +0100 answered a question How to calculate an additive tax in Calc?

Hello @mmalmeida One of the possibilities is to use combination of VLOOKUP functions on the predefined Tax Table, as @

2019-01-05 14:06:51 +0100 answered a question Row duplication dependent on cell data?

Hello one again @evertiro I have attached this sample spreadsheet with a little demonstration how it can be done in Cal

2019-01-04 18:06:28 +0100 answered a question how can I create a manual filter in calc?

You can create a "based on formulas filter", which will display only some matched values based on predefined test condit

2019-01-04 16:17:56 +0100 edited answer Timetable "transformation" (pivot tables..?)

Hello @alex72gr To transform rows to columns you can use TRANSPOSE function entered as an array function (https://help.

2019-01-04 16:17:16 +0100 answered a question Timetable "transformation" (pivot tables..?)

Hello @alex72gr To transform rows to columns you can use TRANSPOSE function entered as an array function (https://help.

2019-01-03 20:34:52 +0100 commented question Row duplication dependent on cell data?

You mean, that if Quantity is 5, you need to insert 4 more rows with identical contents? Should the Quantity be changed

2019-01-03 20:13:12 +0100 edited answer How do I replace a value that appears in multiple rows if one of the rows contains a certain value in a different column?

Hello @lgreene I hope I understood you correctly. Please find an example attached. Firstly, you need to filter all v

2019-01-03 20:11:31 +0100 answered a question How do I replace a value that appears in multiple rows if one of the rows contains a certain value in a different column?

Hello @lgreene I hope I understood you correctly. Please find an example attached. Firstly, you need filter all valu

2019-01-03 15:26:51 +0100 commented answer Calc: Find & delete last- or first certain amount of positions in a line of text

I think you answer is more precise and even easier to implement and @NoLogo also mentioned Search & Replace functio

2019-01-03 15:18:16 +0100 edited answer Calc: Find & delete last- or first certain amount of positions in a line of text

Hello @NoLogo There are few ways of doing this: Assuming column A contains text string last name, first name(s), place

2019-01-03 15:11:24 +0100 answered a question Calc: Find & delete last- or first certain amount of positions in a line of text

Hello @NoLogo There are few ways of doing this: Assuming column A contains text string last name, first name(s), place

2019-01-03 00:35:38 +0100 edited answer Find previous occurrence of text in same column

Hello @libreofficeUser30872 The main part of the formula is SUMPRODUCT(MAX(($C$1:$C11=C12)*$D$1:$D11)) which returns t

2019-01-03 00:22:57 +0100 edited answer Find previous occurrence of text in same column

Hello @libreofficeUser30872 The main part of the formula is SUMPRODUCT(MAX(($C$1:$C11=C12)*$D$1:$D11)) which returns t

2019-01-03 00:12:54 +0100 answered a question Find previous occurrence of text in same column

Hello @libreofficeUser30872 The main part of the formula is SUMPRODUCT(MAX(($C$1:$C11=C12)*$D$1:$D11)) which returns t

2019-01-02 23:29:07 +0100 commented question Find previous occurrence of text in same column

Small edit for formula readability and corrected $D$3:$D11 range reference to $D$1:$D11

2019-01-02 23:28:59 +0100 commented question Find previous occurrence of text in same column

Small edit for formula readability and corrected $D$3:$D11 range reference to $D$3:$D11

2019-01-02 23:27:37 +0100 edited question Find previous occurrence of text in same column

Find previous occurrence of text in same column Given text in a cell C, search column C to find the previous occurrence

2019-01-02 23:25:20 +0100 edited question Find previous occurrence of text in same column

Find previous occurrence of text in same column Given text in a cell C, search column C to find the previous occurrence

2019-01-02 02:39:07 +0100 received badge  Nice Answer (source)