質問する

# 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