Ask Your Question

Erel Segal-Halevi's profile - activity

2019-08-18 04:31:25 +0200 received badge  Notable Question (source)
2019-06-18 19:12:00 +0200 received badge  Notable Question (source)
2019-06-17 13:38:06 +0200 received badge  Popular Question (source)
2019-06-17 13:37:23 +0200 marked best answer How to use MATCH and INDEX with multiple columns

In the attached file, I have a database with three columns: year, quarter, and revenue.

I want to write a formula that takes as input the year and the quarter, and returns the revenue.

Using MATCH and INDEX, I could query either the year or the quarter - but I need both together.

Can you help me fix the formula?

2019-06-17 13:25:04 +0200 received badge  Famous Question (source)
2019-06-17 12:26:07 +0200 commented answer How to use MATCH and INDEX with multiple columns

I managed to correct it - there should be another ";0" just before the last one . It should be: "=INDEX($C3:$C$14;MATCH(

2019-06-17 12:24:20 +0200 commented answer How to use MATCH and INDEX with multiple columns

It works fine when the year is 2019, but when the year is 2018 - I always get "9012" as the result (the last entry), reg

2019-06-17 12:24:03 +0200 commented answer How to use MATCH and INDEX with multiple columns

Actually, it works when the year is 2019, but when the year is 2018 - I always get "9012" as the result (the last entry)

2019-06-12 06:54:08 +0200 marked best answer Creating a keyboard shortcut for a specific font

In Impress, I would like to make "Ctrl+T" convert the currently selected text to "Times New Roman" font.

In Tools->Customize, I found only the option of "Font Name". But when I set Ctrl+T to "Font Name" and click Ctrl+T, I just get the "Font Name" dialogue where I have to manually pick this font each time.

Is there a way to create a shortcut that will automatically change the font to Times New Roman without a dialogue?

2019-06-12 06:54:03 +0200 commented answer Creating a keyboard shortcut for a specific font

This worked. Thank you so much!

2019-06-12 06:54:03 +0200 received badge  Enthusiast
2019-06-11 22:59:31 +0200 received badge  Popular Question (source)
2019-06-11 20:22:26 +0200 asked a question Creating a keyboard shortcut for a specific font

Creating a keyboard shortcut for a specific font In Impress, I would like to make "Ctrl+T" convert the currently selecte

2019-02-25 17:48:29 +0200 commented question Why is Impress so slow on Windows?

I have a similar problem with LibreOffice impress 6.1.1.2, Windows 10, on a laptop with 8th-generation i7 intel processo

2019-02-23 18:22:26 +0200 marked best answer Equations are ruined when I save as word doc

When I create equations, and then save the document as a Word doc (1997-2003), and then close and re-open the file, all the equations look different.

As a simple example: I created an equation "a = b + c". After close and re-open, the formula looks like: " size 12{ ital "a=b+c"} {}" . This is a simple case - more complicated formulas become much worse.

How can I prevent this?

2019-02-23 07:48:23 +0200 received badge  Notable Question (source)
2019-02-22 17:46:35 +0200 received badge  Popular Question (source)
2019-02-22 10:14:08 +0200 asked a question Equations are ruined when I save as word doc

Equations are ruined when I save as word doc When I create equations, and then save the document as a Word doc (1997-200

2018-09-13 06:02:22 +0200 received badge  Notable Question (source)
2018-09-07 16:06:22 +0200 received badge  Popular Question (source)
2018-09-07 13:04:38 +0200 asked a question In Calc, is it possible to calculate the sum of a function without creating an auxiliary column?

In Calc, is it possible to calculate the sum of a function without creating an auxiliary column? Suppose I have some num

2018-08-15 19:41:35 +0200 received badge  Famous Question (source)
2018-08-15 19:41:35 +0200 received badge  Notable Question (source)
2018-02-14 12:40:19 +0200 received badge  Popular Question (source)
2018-02-13 15:33:42 +0200 received badge  Supporter (source)
2018-02-13 15:33:40 +0200 marked best answer Why can't I add a column to a table in Impress?

In an Impress presentation, I have a table. I try to add a column. I right-click inside the table and select "Column". Instead of seeing the "Insert" option, I see "<no selections possible>".

This happens whether I select the entire column, only a single cell, or nothing at all.

How can I fix it?

2018-02-13 15:33:40 +0200 received badge  Scholar (source)
2018-02-13 13:49:13 +0200 asked a question Automatically change the font of all text boxes in Impress

Automatically change the font of all text boxes in Impress I received a PowerPoint presentation from a colleague. I conv

2018-02-12 18:47:57 +0200 received badge  Popular Question (source)
2018-02-12 10:54:00 +0200 asked a question Autotext without line-break

Autotext without line-break I created autotext "C++". Whenever I insert this autotext, I also get a newline that I do no

2018-02-12 10:47:50 +0200 asked a question How to correctly write C++ in a right-to-left document?

How to correctly write C++ in a right-to-left document? In a right-to-left Writer document, when I write "C++", it is sh

2018-02-12 10:45:46 +0200 commented answer Why can't I add a column to a table in Impress?

What can I do if I do not see this toolbar?

2018-02-12 10:45:06 +0200 received badge  Popular Question (source)
2018-01-11 18:07:11 +0200 edited question Why can't I add a column to a table in Impress?

Why can't I add a column to a table in Impress? In an Impress presentation, I have a table. I try to add a column. I ri

2018-01-11 18:06:39 +0200 asked a question Why can't I add a column to a table in Impress?

Why can't I add a column to a table in Impress? In an Impress presentation, I have a table. I try to add a column. I ri

2016-08-12 21:34:42 +0200 received badge  Student (source)
2015-02-16 15:33:22 +0200 received badge  Famous Question (source)
2015-02-16 15:33:22 +0200 received badge  Notable Question (source)
2015-02-16 15:33:22 +0200 received badge  Popular Question (source)
2013-12-24 16:43:09 +0200 asked a question Fill the area below/above an x-y curve

I want to draw a plot with the points:\

y >= f(x)

where f(x) is some function I define.

Using an x-y plot, I can draw only the function:

y = f(x)

Using an area plot, I can draw an area of a single column (i.e. not y as a function of x).

Is there any way I can fill the area above the x-y curve?