We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

rcw's profile - activity

2017-12-27 09:15:55 +0200 received badge  Taxonomist
2015-05-12 19:52:41 +0200 received badge  Famous Question (source)
2015-05-12 19:52:41 +0200 received badge  Notable Question (source)
2015-05-12 19:52:41 +0200 received badge  Popular Question (source)
2014-05-24 18:03:08 +0200 commented answer Calc: Hide columns but use data

This works. It gives total control but requires individual settings for each data series.

2013-10-27 10:32:54 +0200 received badge  Popular Question (source)
2013-10-27 10:32:54 +0200 received badge  Famous Question (source)
2013-10-27 10:32:54 +0200 received badge  Notable Question (source)
2013-08-29 08:00:30 +0200 received badge  Popular Question (source)
2013-08-29 08:00:30 +0200 received badge  Famous Question (source)
2013-08-29 08:00:30 +0200 received badge  Notable Question (source)
2013-05-01 03:04:13 +0200 commented answer First Column has different color with Column or Column and Line Chart type.

Thank you, that did it.

2013-05-01 01:48:15 +0200 asked a question First Column has different color with Column or Column and Line Chart type.

The spreadsheet chart has column data and the first column is always a different color. Have I done something wrong?

image description

ColumnQuestion.ods

2013-04-07 22:12:48 +0200 received badge  Commentator
2013-04-07 22:12:48 +0200 commented answer Test number for 2^x in Calc

Looking at the the download page I now see that Main Installer, torrent, and Info are different choices. As they are all inside a big green box I did not notice the different links until you said I should be able to not use torrent. Sigh. Thanks for your time.

2013-04-06 06:47:32 +0200 received badge  Self-Learner (source)
2013-04-06 06:47:32 +0200 received badge  Teacher (source)
2013-04-05 20:47:45 +0200 answered a question Test number for 2^x in Calc

Use BITAND() to test for binary values. Your version of LibreOffice must be 3.6 or greater. TRUE=BITAND(4,20) - from JohnSUN Previous to version 3.6 use this text based test =NOT(ISERROR(SEARCH(SUBSTITUTE(BASE(4;2);"0";".")&"$";BASE(109;2)))) using =IF(B3;Formula;0) to prevent a search for 0 returning a TRUE - from mariosv

Comment: I installed LibreOffice Version 3.6.5.2 as itsGetting started doc stated it had added BITx as declared in the ODF 1.2 specification." The new LibreOffice download seemed to require Torrent if I didn't want to build my own downloader. I DID NOT LIKE THE EXPERIENCE OF GETTING RID OF uTORRENT AT ALL!

I recently (Version 4.2.0.4) tested =BITAND($B14,4), =BITAND($G17,2^2), and =IF(BITAND($L17,2^2),1,0) which returned 4, 4, and 1. All work depending on the form of the test and desired answer. Thanks to JohnSUN and mariosv.

2013-04-05 18:22:38 +0200 commented question Test number for 2^x in Calc

I installed LibreOffice Version 3.6.5.2 as itsGetting started doc stated it had added BITx as declared in the ODF 1.2 specification." Tested BITAND() and it works fine. However the new LibreOffice download seemed to require Torrent if I didn't want to build my own downloader. I DID NOT LIKE THE EXPERIENCE OF GETTING RID OF uTORRENT AT ALL! If you prefer to avoid that the text solution works, otherwise BITAND() is cleaner. Thanks to JohnSUN and mariosv.

2013-04-05 04:44:08 +0200 commented answer Test number for 2^x in Calc

Yes, Thank you very much. Dick

2013-04-05 01:29:26 +0200 commented question Test number for 2^x in Calc

Thanks for your time. Yes this sounds just right. However BITAND() is not listed in functions and BITAND() returns #NAME? for me in LibreOffice 3.4.3 OOO340m1 (Build:302). Is there an extension to download? Thanks again.

2013-04-05 01:24:42 +0200 commented answer Test number for 2^x in Calc

Thanks for your time. This text solution works for all but case "0" where it always returns True. If I can't get a math method running this will work. Thanks again.

2013-04-03 23:11:37 +0200 commented answer Test number for 2^x in Calc

2^2+2^4=20. I was looking for the test: Does number (example 20) contain a 4? In binary, 00100+10000=10100. I am trying to test for the binary position. This can be used for a mask or as a flag.

2013-04-03 19:56:10 +0200 asked a question Test number for 2^x in Calc

In many languages you can test (2^x)==y to see if y contains a 4 for example. Or you can pull out a 0 or 4 with (2^2)&y.

Can you help me find this functionality?

Thanks, Dick

2013-03-10 20:50:32 +0200 commented answer Calc: Hide columns but use data

@rmfaile - That's both interesting - and - it works. Thanks.

2013-03-10 15:32:22 +0200 received badge  Scholar (source)
2013-03-10 15:31:34 +0200 commented answer Calc: Hide columns but use data

@rmfaile - I was already using freeze to keep row labels and column titles visible. The (previously unexpressed) idea was to use hide with scroll to make one week at a time visible for data entry while being able to see both the beginning of the row labels and the end of row summary data and look on another sheet for the averages. I hoped that the display of data and the use of data could be made separately controllable. Thank you and @qubit for your help

2013-03-10 05:21:39 +0200 commented answer Calc: Hide columns but use data

Added a jpg and an ods. The picture got there, I hope the spread sheet did.

2013-03-10 05:18:50 +0200 received badge  Editor (source)
2013-03-10 03:35:46 +0200 received badge  Student (source)
2013-03-10 00:51:48 +0200 commented question Calc: Hide columns but use data

Thank you for looking at this. The data range of the hidden cells is included but the chart data disappears when the columns are hidden. I'd upload a picture but it says I need karma>3. I could email the jpg to you if that would help. Or I could setup an example spreadsheet and send that.

2013-02-26 20:01:16 +0200 asked a question Calc: Hide columns but use data

HiddenColumnIssue.jpg

I want to hide columns of data to make data entry easier but I want charts to be able to use the visually hidden data so I can still see averages, bar charts, and so on.

SimpleExample.ods