Ask Your Question

bengineer's profile - activity

2018-11-28 12:11:54 +0200 received badge  Famous Question (source)
2018-09-20 21:46:47 +0200 received badge  Popular Question (source)
2018-09-19 14:58:01 +0200 commented question [Calc] Secondary x-axis for multiple datasets

Those are just dummy names - sorry if it's confusing. Trying to keep possibly confidential information confidential. Bas

2018-09-18 22:59:02 +0200 edited question [Calc] Secondary x-axis for multiple datasets

[Calc] Secondary x-axis for multiple datasets I'm trying to plot two data ranges on the same Y-axis, but cannot for the

2018-09-18 22:54:56 +0200 edited question [Calc] Secondary x-axis for multiple datasets

[Calc] Secondary x-axis for multiple datasets I'm trying to plot two data ranges on the same Y-axis, but cannot for the

2018-09-18 22:54:37 +0200 edited question [Calc] Secondary x-axis for multiple datasets

Secondary x-axis for multiple datasets I'm trying to plot two data ranges on the same Y-axis, but cannot for the life of

2018-09-18 22:51:08 +0200 asked a question [Calc] Secondary x-axis for multiple datasets

Secondary x-axis for multiple datasets I'm trying to plot two data ranges on the same Y-axis, but cannot for the life of

2018-08-30 19:19:41 +0200 received badge  Famous Question (source)
2018-08-30 19:19:41 +0200 received badge  Notable Question (source)
2018-08-16 07:08:09 +0200 received badge  Popular Question (source)
2018-08-15 18:18:33 +0200 received badge  Famous Question (source)
2018-08-15 18:18:33 +0200 received badge  Notable Question (source)
2018-08-14 22:24:16 +0200 asked a question [Calc] links saving improperly

[Calc] links saving improperly I've added links to URLs in several cells. When saving in .xls format (this sheet has to

2018-07-21 18:41:38 +0200 received badge  Famous Question (source)
2018-06-08 21:03:27 +0200 received badge  Popular Question (source)
2018-06-07 14:49:24 +0200 received badge  Enthusiast
2018-06-06 22:47:08 +0200 received badge  Organizer (source)
2018-06-06 22:46:25 +0200 asked a question [Calc] Conditional formatting disappearing when saving as .xlsx

[Calc] Conditional formatting disappearing when saving as .xlsx I'm running LibO 5.3.4.2 on Windows 10 Home, version 180

2018-05-23 23:29:49 +0200 received badge  Notable Question (source)
2018-05-17 14:50:08 +0200 answered a question [Calc] [Chart] Adding external label to a legend

I'm not sure if this helps anyone, but you can get a sort of workaround by the method used in this post. I changed the

2018-05-16 23:25:55 +0200 commented answer [Calc] [Chart] Adding external label to a legend

This sort of works. However, I can only add in one Subtitle field. It sounds like you're managing to insert multiple Tit

2018-05-16 23:18:25 +0200 received badge  Popular Question (source)
2018-05-14 18:37:30 +0200 edited question [Calc] [Chart] Adding external label to a legend

[Calc] [Chart] Adding external label to a legend I have a data series that I would like to label as follows: On the c

2018-05-14 18:37:29 +0200 received badge  Editor (source)
2018-05-14 18:37:29 +0200 edited question [Calc] [Chart] Adding external label to a legend

[Calc] [Chart] Adding external label to a legend I have a data series that I would like to label as follows: On the c

2018-05-14 16:18:39 +0200 asked a question [Calc] [Chart] Adding external label to a legend

[Calc] [Chart] Adding external label to a legend I have a data series that I would like to label as follows: On the c

2018-05-04 18:25:50 +0200 received badge  Popular Question (source)
2018-05-02 21:17:05 +0200 received badge  Scholar (source)
2018-05-02 20:44:12 +0200 commented answer [Solved] [Calc] Conditional formatting - based on cell's empty/filled status

That solved it. Thanks!

2018-05-02 20:43:59 +0200 marked best answer [Solved] [Calc] Conditional formatting - based on cell's empty/filled status

Hi, I am trying to figure out how to auto-format a cell based on whether or not another cell is filled or empty, and have not been able to find anything in the Conditional Formatting dialog box (LibO 5.3.4.2). See images below.

image description

Fig. 1. The cells in question.

image description

Fig. 2. Drop down menu for "Conditional Formatting" > "Condition".

Specifically, I want the text displayed in column C to read "Yes" IF its neighbor in column D has a date entered (that is, the cell is filled, as opposed to empty), and "No" IF its neighbor is empty.

I appreciate the help.

2018-05-02 20:43:51 +0200 edited question [Solved] [Calc] Conditional formatting - based on cell's empty/filled status

[Calc] Conditional formatting - based on cell's empty/filled status Hi, I am trying to figure out how to auto-format a c

2018-05-02 20:01:52 +0200 asked a question [Solved] [Calc] Conditional formatting - based on cell's empty/filled status

[Calc] Conditional formatting - based on cell's empty/filled status Hi, I am trying to figure out how to auto-format a c

2018-04-27 20:37:37 +0200 received badge  Notable Question (source)
2018-04-11 21:38:49 +0200 received badge  Popular Question (source)
2018-03-07 16:55:02 +0200 commented answer [Calc] displaying exact data value on Y-axis of bar graph

erAck, thanks for the help. I've gotten something more like what I'm looking for. Looking through the Data Labels format

2018-03-07 16:15:49 +0200 asked a question [Calc] displaying exact data value on Y-axis of bar graph

[Calc] displaying exact data value on Y-axis of bar graph Hello, I'm new to LibreOffice and Calc. I have a data range