First time here? Check out the FAQ!
2020-02-06 16:53:57 +0100 | received badge | ● Good Question (source) |
2019-01-04 15:42:39 +0100 | received badge | ● Nice Question (source) |
2017-03-03 12:51:37 +0100 | received badge | ● Student (source) |
2015-12-24 10:39:34 +0100 | commented answer | How to return empty cell from function in calc Still Ctrl + arrow is fetches cell with ={} although it looks empty. Interesting enough pivot table recognizes ={} as zero and ="" as second (empty) whereas totally empty as the first (empty). |
2015-03-19 19:00:58 +0100 | received badge | ● Famous Question (source) |
2014-12-10 10:27:53 +0100 | received badge | ● Famous Question (source) |
2014-05-28 07:12:52 +0100 | answered a question | Pivot table for distinct count? Try this Row fields: Car Data fields: Colour(count) |
2014-05-28 06:47:41 +0100 | received badge | ● Commentator |
2014-05-28 06:47:41 +0100 | commented question | How to return empty cell from function in calc Yet another case is pivot table. It adds (empty) result. |
2014-05-28 06:41:29 +0100 | commented answer | Why the super slow saves in Calc? I use 4.2.3.3 on Linux x64 to edit 174,4 KiB size *.ods file. It takes 10 seconds to open. I followed your advice save in xlsx format and got 12 seconds on opening. I have an HP Mini with an Intel 2 core 1000 MHz processor, 2 GB RAM. |
2014-05-28 06:14:32 +0100 | received badge | ● Supporter (source) |
2014-05-19 12:15:09 +0100 | commented answer | How to return empty cell from function in calc I asked about returning empty cell because I want to use Ctrl + arrow. Not for using formula. Formula do well with empty cells. |
2014-05-19 12:09:55 +0100 | commented answer | How to return empty cell from function in calc Thank you! |
2014-05-15 11:19:04 +0100 | received badge | ● Notable Question (source) |
2014-05-14 14:25:00 +0100 | received badge | ● Popular Question (source) |
2014-05-14 11:20:19 +0100 | commented question | How to return empty cell from function in calc Ctrl + arrow is fetches an empty string as two double quotes. What I do not want as return of function. Is there a way to do so? |
2014-05-14 11:14:32 +0100 | received badge | ● Editor (source) |
2014-05-14 11:07:11 +0100 | asked a question | How to return empty cell from function in calc I want get a completely empty cell at return without using quotes, i.e. not like at previous question |
2014-05-14 10:50:49 +0100 | received badge | ● Scholar (source) |
2014-05-14 10:41:56 +0100 | commented answer | How to return null/empty from function in calc =IF(A1=0,1) do not return blank value. Insterd it return FALSE value. Not what topic starter whanted. |
2014-05-12 13:20:45 +0100 | commented answer | how to get visible selection button in freeze column with data validation while horizontal sheet scrolling bug 78472 |
2014-05-09 10:27:28 +0100 | commented answer | how to get visible selection button in freeze column with data validation while horizontal sheet scrolling Thank you. I reported a bag. |
2014-05-09 09:59:39 +0100 | received badge | ● Notable Question (source) |
2014-05-09 09:26:39 +0100 | received badge | ● Popular Question (source) |
2014-05-07 16:33:07 +0100 | commented question | how to get visible selection button in freeze column with data validation while horizontal sheet scrolling Can the button be moved into the cell? |
2014-05-07 16:22:56 +0100 | commented question | how to get visible selection button in freeze column with data validation while horizontal sheet scrolling I want to insert predefined values in freeze column while scrolling. |
2014-05-07 16:16:49 +0100 | asked a question | how to get visible selection button in freeze column with data validation while horizontal sheet scrolling
|