Ask Your Question

erAck's profile - karma

erAck's karma change log

15 0 How do i make a list of unique numbers from a dataset? ( 2019-02-15 12:01:22 +0100 )

0 -15 Can calculated data from one sheet create a row with results on another? ( 2019-02-12 18:58:48 +0100 )

15 0 Can calculated data from one sheet create a row with results on another? ( 2019-02-12 18:58:43 +0100 )

10 0 LO Calc ignores OS "short date" format ( 2019-02-11 22:12:19 +0100 )

0 -10 LO Calc ignores OS "short date" format ( 2019-02-11 22:12:04 +0100 )

10 0 LO Calc ignores OS "short date" format ( 2019-02-11 22:12:04 +0100 )

15 0 LO Calc ignores OS "short date" format ( 2019-02-11 22:12:03 +0100 )

0 -15 LO Calc ignores OS "short date" format ( 2019-02-11 22:12:02 +0100 )

15 0 LO Calc ignores OS "short date" format ( 2019-02-11 22:11:08 +0100 )

15 0 Can we return an empty cell instead of Zero by keeping the formula ? ( 2019-02-11 10:29:46 +0100 )

15 0 Possible to set invalid values through macro and automation ( 2019-02-11 10:18:37 +0100 )

15 0 sum only returns ### ( 2019-02-09 19:59:18 +0100 )

0 -15 sum only returns ### ( 2019-02-09 19:59:17 +0100 )

15 0 sum only returns ### ( 2019-02-09 19:53:34 +0100 )

15 0 calc csv limits for columns ( 2019-02-08 20:51:36 +0100 )

10 0 Why is this SUMIF not working? ( 2019-02-08 11:54:42 +0100 )

0 -15 sum only returns ### ( 2019-02-08 11:37:31 +0100 )

15 0 sum only returns ### ( 2019-02-08 11:24:49 +0100 )

10 0 Why is this SUMIF not working? ( 2019-02-07 15:51:40 +0100 )

10 0 Do not show #Value! ( 2019-02-07 12:34:57 +0100 )

10 0 Which functions take regular expressions or patterns? ( 2019-02-06 03:05:06 +0100 )

10 0 Which functions take regular expressions or patterns? ( 2019-02-05 13:12:42 +0100 )

10 0 In Calc, what does block selection mode do? ( 2019-02-02 20:25:47 +0100 )

15 0 In Calc, what does block selection mode do? ( 2019-02-02 20:25:37 +0100 )

2 0 I dont know the password, how do I unlock Protected Cells? ( 2019-01-23 20:13:51 +0100 )

0 -2 I dont know the password, how do I unlock Protected Cells? ( 2019-01-21 15:21:57 +0100 )

10 0 Moving in Calc using short-cut keys ( 2019-01-16 19:21:09 +0100 )

0 -2 Moving in Calc using short-cut keys ( 2019-01-16 18:27:43 +0100 )

10 0 Calc function to calculate percentage difference. ( 2019-01-15 13:42:58 +0100 )

10 0 When I press PgDn, Writer starts a numbered list that I DON'T want. How do I stop this? ( 2019-01-11 00:15:38 +0100 )

10 0 When I press PgDn, Writer starts a numbered list that I DON'T want. How do I stop this? ( 2019-01-10 16:32:22 +0100 )

0 -2 Spreadsheet not copying formula down to next row ( 2019-01-07 19:21:20 +0100 )

2 0 Calc: Number of cells which don't have any of a set of values ( 2019-01-02 02:50:23 +0100 )

10 0 Calc: Number of cells which don't have any of a set of values ( 2019-01-02 01:14:04 +0100 )

15 0 Where is the transpose operation on clipboard in LO 6 ( 2018-12-22 15:25:18 +0100 )

15 0 Incorrect display of xlxs file ( 2018-12-22 05:02:38 +0100 )

10 0 Incorrect display of xlxs file ( 2018-12-21 21:46:22 +0100 )

10 0 Detailed tutorial regarding LibreOffice to Python macro writing, especially for Calc ( 2018-12-20 04:06:38 +0100 )

10 0 when entering a number with a leading zero, the zero is not displayed. eg account numbers ( 2018-12-15 21:37:59 +0100 )

10 0 How to import Quatro-pro ( 2018-12-10 21:11:56 +0100 )

15 0 Open Librecalc file without execute formulas ( 2018-12-06 09:47:27 +0100 )

10 0 How can I distribute X-Axis Values not equally but relativ to their size? ( 2018-12-05 20:35:32 +0100 )

10 0 csv files issue ( 2018-12-04 19:34:09 +0100 )

10 0 Calculating median using dates ( 2018-12-04 17:55:49 +0100 )

10 0 Calculating median using dates ( 2018-12-04 16:51:45 +0100 )

15 0 Calc: If-Statement pulling data from multiple cells - date is not shown correctly ( 2018-12-04 14:33:19 +0100 )

0 -2 Calc sheet tab numbering? ( 2018-12-03 17:47:01 +0100 )

15 0 How to set up a formatted output from data ( 2018-11-19 08:43:35 +0100 )

10 0 CALC: Undocumented cell format found, for astro-nav calcs in degrees:minutes:seconds and decimal seconds. I request full info soon if available. ( 2018-11-17 16:37:58 +0100 )

10 0 In calc i'm trying to use =percentile. I'm trying to have it exclude certain items from my selection, but don't know how. ( 2018-11-12 23:04:32 +0100 )

0 -2 How do I make formulas automatically recalculate? ( 2018-11-10 20:23:02 +0100 )

0 -2 I tried to install Libreoffice but the wizards in Russian. WTF ? ( 2018-11-10 20:17:58 +0100 )

0 -2 I tried to install Libreoffice but the wizards in Russian. WTF ? ( 2018-11-10 20:16:29 +0100 )

10 0 How to create a type of Procv but find result with the text and just with initials letters of the text? ( 2018-11-08 01:01:06 +0100 )

15 0 Don't run LibreOffice 6... . By double clicking on the icon, nothing happens. All versions 5 ... start normally. ( 2018-10-31 10:15:03 +0100 )

15 0 why are the name of the days not shown in my spread sheet? ( 2018-10-30 02:01:28 +0100 )

10 0 Using Calc to open a csv file that has cr/lf mid field ( 2018-10-28 08:41:42 +0100 )

15 0 how to install dictionary or not displayed ? ( 2018-10-27 18:43:31 +0100 )

10 0 Does LibreOffice support animated firefox themes? ( 2018-10-27 09:06:57 +0100 )

10 0 how to install dictionary or not displayed ? ( 2018-10-27 08:41:45 +0100 )

10 0 how to install dictionary or not displayed ? ( 2018-10-26 23:19:48 +0100 )

10 0 How to format cells for Hex numbers? ( 2018-10-23 07:25:01 +0100 )

0 -10 On startup LO tries to recover "Untitled 1". Can not discard or recover or complete startup. How to clear this? ( 2018-10-22 23:11:16 +0100 )

10 0 On startup LO tries to recover "Untitled 1". Can not discard or recover or complete startup. How to clear this? ( 2018-10-22 23:11:05 +0100 )

15 0 Number format not applying to conditionally formatted cells ( 2018-10-22 20:51:53 +0100 )

2 0 How to add '@example.com' to multiple cells at once? ( 2018-10-20 18:38:47 +0100 )

2 0 Calc: How to convert time in MM:SS into seconds ( 2018-10-20 18:20:54 +0100 )

2 0 what does wiki karma mean, should i tick the box ( 2018-10-16 14:19:16 +0100 )

10 0 Conditional Formatting not working with list cell ( 2018-10-12 19:39:22 +0100 )

15 0 Error on trying to clone from "git://gerrit.libreoffice.org/core" ( 2018-10-12 15:26:56 +0100 )

0 -15 Error on trying to clone from "git://gerrit.libreoffice.org/core" ( 2018-10-12 15:26:52 +0100 )

15 0 Error on trying to clone from "git://gerrit.libreoffice.org/core" ( 2018-10-12 15:25:53 +0100 )

0 -15 Error on trying to clone from "git://gerrit.libreoffice.org/core" ( 2018-10-12 15:25:47 +0100 )

15 0 Error on trying to clone from "git://gerrit.libreoffice.org/core" ( 2018-10-12 15:25:46 +0100 )

10 0 Why does Libre spreadsheet only use US format dates on Macbook? ( 2018-10-11 19:24:35 +0100 )

15 0 Can Indirect adressing use a cell value to change the "sheet" value? ( 2018-10-09 17:48:04 +0100 )

10 0 how do I remove the red outline on changed cells ( 2018-10-09 16:10:39 +0100 )

10 0 Edit a named range ( 2018-10-07 07:14:34 +0100 )

10 0 Edit a named range ( 2018-10-06 03:04:37 +0100 )

10 0 how to set the "line" data on a column and line chart ( 2018-10-05 22:05:51 +0100 )

10 0 Calc: Number of cells which don't have any of a set of values ( 2018-10-03 00:01:43 +0100 )

15 0 Calc: disable spell check for range of cells ( 2018-10-02 21:46:16 +0100 )

10 0 what does error code 510 mean when using formula using calc ( 2018-10-02 00:00:16 +0100 )

10 0 VLOOKUP issue (data limit?) ( 2018-09-22 15:16:01 +0100 )

10 0 How do I delete a file in Libre Calc ( 2018-09-21 20:49:17 +0100 )

0 -10 How do I delete a file in Libre Calc ( 2018-09-21 20:49:15 +0100 )

10 0 How do I delete a file in Libre Calc ( 2018-09-20 21:43:50 +0100 )

0 -2 How to print pages double-sided or print separately even and odd pages ( 2018-09-18 16:45:19 +0100 )

10 0 how can I secure a spreadsheet? ( 2018-09-05 22:54:46 +0100 )

0 -2 how can I secure a spreadsheet? ( 2018-09-05 20:59:23 +0100 )

15 0 How can I navigate through applied instances of any style (paragraph, character, etc)? ( 2018-09-03 19:17:45 +0100 )

15 0 LibreCalc: How do I delete a row? ( 2018-09-03 18:28:21 +0100 )

10 0 Show total when selecting cells in Calc? ( 2018-09-03 11:17:38 +0100 )

0 -2 After upgrading to Ubuntu 18.04 most english fonts were removed. ( 2018-08-31 18:34:36 +0100 )

15 0 CALC: How do I set the language for a selection of cells? ( 2018-08-31 16:11:25 +0100 )

10 0 CALC: How do I set the language for a selection of cells? ( 2018-08-30 16:08:11 +0100 )

0 -10 CALC: How do I set the language for a selection of cells? ( 2018-08-30 16:08:10 +0100 )

10 0 CALC: How do I set the language for a selection of cells? ( 2018-08-30 16:06:49 +0100 )

2 0 CALC: How do I set the language for a selection of cells? ( 2018-08-30 12:21:30 +0100 )

0 -2 CALC: How do I set the language for a selection of cells? ( 2018-08-30 12:19:30 +0100 )