質問する

libreoffiguess's profile - activity

2019-06-15 09:19:48 +0200 バッジを受け取った  卓越した質問 (source)
2018-11-05 21:27:24 +0200 コメント付き回答 Calc cell style background colour uses only the default palette

For some reason the workaround isn't working 100% for me. I had to add the colour in question as a custom palette (it ha

2018-11-05 21:02:49 +0200 質問に回答する Calc cell style background colour uses only the default palette

For some reason the workaround isn't working 100% for me. I had to add the colour in question as a custom palette (it ha

2018-10-18 21:24:20 +0200 バッジを受け取った  有名な質問 (source)
2018-10-13 09:45:37 +0200 バッジを受け取った  人気の質問 (source)
2018-10-12 19:37:57 +0200 質問をする Date of last document change in Calc?

Date of last document change in Calc? I know it's possible to insert the document's last modification date in Writer, bu

2018-09-20 20:25:03 +0200 バッジを受け取った  卓越した質問 (source)
2018-07-31 22:42:30 +0200 バッジを受け取った  サポーター (source)
2018-07-31 07:40:00 +0200 バッジを受け取った  人気の質問 (source)
2018-07-30 23:05:09 +0200 コメント付き回答 Using an OR function/operator in a COUNTIFS?

Number 1 did it. Thank you!

2018-07-30 23:04:11 +0200 ベストアンサーマーク Using an OR function/operator in a COUNTIFS?

Is it at all possible to include an OR function or alternation as part of the criterion of a COUNTIFS function, and if so, how is it done?

I want to count the number of times an entry/row within a certain date range, and with one of two specific text values, appears in a given table. I did try using SUMPRODUCT instead, but couldn't get it to cooperate and it was harder to read. Currently the formula that I'm using to give me the number I want is:

=SUM(COUNTIFS($I$14:$I,">=2018-1-1",$I$14:$I,"<=2018-12-31",$H$14:$H,"Website"),COUNTIFS($I$14:$I,">=2018-1-1",$I$14:$I,"<=2018-12-31",$H$14:$H,"Email"))

I would prefer something along the lines of:

=SUM(COUNTIFS($I$14:$I,">=2018-1-1",$I$14:$I,"<=2018-12-31",$H$14:$H,"(Website|Email)"))

But nothing I input seems to work. The wiki states that COUNTIFS takes regular expressions, and "Web*" will return a count for all entries with "Website" just fine, but for some reason the | regex operator doesn't work. (||, and "Website|Email" without brackets also don't work.) I also can't use OR() since there doesn't appear to be any way to reference the COUNTIFS criteria within the criterion (attempting OR(H14="Website",H14="Email") doesn't appear to work at all; even when H14 does contain either "Website" or "Email", the resulting count is 0).

The example I've used may look pretty minor as a use case, but I'm going to be SUMing several more of these together across sheets and would prefer to eliminate the need to double up on functions.

2018-07-30 23:04:09 +0200 コメント付き回答 Using an OR function/operator in a COUNTIFS?

Weird, I swore that indefinite range end was working before; maybe I got it confused with Google Sheets functionality.

2018-07-30 20:36:37 +0200 バッジを受け取った  人気の質問 (source)
2018-07-30 20:36:37 +0200 バッジを受け取った  卓越した質問 (source)
2018-07-30 20:36:37 +0200 バッジを受け取った  有名な質問 (source)
2018-07-30 20:35:52 +0200 質問をする Using an OR function/operator in a COUNTIFS?

Using an OR function/operator in a COUNTIFS? Is it at all possible to include an OR function or alternation as part of t

2018-04-13 20:06:27 +0200 コメント付き回答 Conditional Formatting not working with list cell

Augh, that did it, thank you so much!

2018-04-13 20:06:15 +0200 ベストアンサーマーク Conditional Formatting not working with list cell

LO Version: 5.1.6.2
Build ID: 1:5.1.6~rc2-0ubuntu1~xenial3
OS: Ubuntu 16.04 LTS

I have a Calc sheet where I want the formatting of a given row to be dependent on the value of a specific cell within that row. For some reason, I can get this to happen with the STYLE() formula, but not with the Conditional Formatting setting (which would be preferable so that I don't have to slap a STYLE() on every single row).

The specific cell being used to determine the formatting has text content restricted by a List criteria: the contents can either be "Active" or "Inactive". If the cell's contents are "Inactive", I want the "Inactive" formatting style to be applied to the row. If the contents are "Active", I want the "Active" formatting style applied.

If I apply the following STYLE() formula to a cell within the row, it executes just fine and behaves as expected:

STYLE(IF(C4="Inactive";"Inactive";"Active"))

However, if I go to Conditional Formatting and use the following details:

Condition 1
Formula is C4="Inactive"
Apply style Inactive
Cell Range: A4:Z4

and

Condition 2
Formula is C4="Active"
Apply style Active
Cell Range: A4:Z4

Nothing happens. No formatting is applied, and toggling the value of C4 doesn't make a difference.

I've tried setting "Formula is" to IF(C4="Inactive"), C4=="Inactive", and anything else I can think of, but nada. What's going on here?

2018-04-13 20:06:15 +0200 バッジを受け取った  学者 (source)
2018-04-13 19:49:00 +0200 質問をする Conditional Formatting not working with list cell

Conditional Formatting not working with list cell LO Version: 5.1.6.2 Build ID: 1:5.1.6~rc2-0ubuntu1~xenial3 OS: Ubunt