Ask Your Question

erAck's profile - activity

2019-02-15 11:36:39 +0100 answered a question Data > Subtotals - What are these lines?

These are groupings. Go to the Birthday header cell and hit Ctrl+F12 (menu Data -> Group and Outline -> Ungroup).

2019-02-15 11:35:51 +0100 commented answer Data > Subtotals - What are these lines?

Please edit a question for an update instead of posting an answer, which it is not. Thanks. You probably did not reload

2019-02-15 11:33:23 +0100 commented answer Data > Subtotals - What are these lines?

Please edit a question for an update instead of posting an answer, which it is not. Thanks.

2019-02-15 11:32:18 +0100 commented answer How do i make a list of unique numbers from a dataset?

It would be nice if you then marked the answer as correct by clicking the checkmark and also upvote. Thanks.

2019-02-14 18:59:41 +0100 commented answer #NA - ERROR handle in formula

NOT(ISNA(A2)) or IF(ISNA(A2);...then...;...else...)

2019-02-14 18:50:50 +0100 answered a question How do i make a list of unique numbers from a dataset?

Mark/select the data range and choose menu Data -> More Filters -> Standard Filter...; there with Condition = choo

2019-02-14 18:36:48 +0100 commented question I can use Column border but not option please start this option

WHAT? (and please don't shout in all capital letters) Please ask understandable questions, see the Guidelines for askin

2019-02-12 18:17:19 +0100 answered a question backspace doesn't work

Known bug, tdf#122238 fixed for 6.2.1

2019-02-11 19:58:57 +0100 answered a question LO Calc ignores OS "short date" format

Short answer: No. Long answer: it's an RFE.

2019-02-11 19:50:15 +0100 answered a question in calc, format time

What pull down? Anyway, you get the number formats dialog with Ctrl+1, or menu Format -> Cells..., tab Numbers.

2019-02-09 20:38:23 +0100 answered a question Why can't I print outlined empty cells in Calc?

Try to fill cells with one blank just before the print. Select cell range, enter a space, close with Alt+Enter, which in

2019-02-09 20:31:55 +0100 commented answer sum only returns ###

Click on the upwards pointing arrow head above the number. Thanks.

2019-02-09 20:30:14 +0100 answered a question character set on unknown CSV-file

Wade through individual pages from https://en.wikipedia.org/wiki/Category:DOS_code_pages and see which code the Å charac

2019-02-09 20:21:47 +0100 commented question character set on unknown CSV-file

CP-437, though widely used for West/North-European DOS, has different assignments. i.e. 0x8F = Å 0x8E = Ä 0x99 = Ö 0x9

2019-02-09 19:57:27 +0100 answered a question Possible to set invalid values through macro and automation

Checking data input validity is an UI feature while the user enters values. AFAIK there is no option to check macro gene

2019-02-09 19:17:50 +0100 commented answer sum only returns ###

Great. If you then please would mark the answer as correct by clicking the check mark and possibly upvote? Thanks.

2019-02-08 11:54:42 +0100 received badge  Nice Answer (source)
2019-02-07 15:33:59 +0100 answered a question Why is this SUMIF not working?

A Criterion context of<>0 behaves as in For <>, if the value is not empty it matches any cell content except

2019-02-07 15:03:10 +0100 answered a question calc csv limits for columns

Columns up to AMJ (i.e. 1024 columns) are available, but your CSV data may be malformed with embedded separators but unq

2019-02-07 12:25:21 +0100 answered a question Do not show #Value!

Seeing the highlighted formula expression there you don't need that at all. In fact it worsens things. You try to force

2019-02-07 12:13:29 +0100 answered a question sum only returns ###

The column is too narrow to display the result, widen it.

2019-02-07 12:12:44 +0100 commented answer Do you have a rating of errors for which users voted?

Well, you can always try to contract a certified developer or company providing professional support to fix your pet pee

2019-02-07 12:07:06 +0100 answered a question Can we return an empty cell instead of Zero by keeping the formula ?

You can apply this number format [=0]"";General meaning if numeric value is 0 then display empty string, otherwise displ

2019-02-06 03:05:06 +0100 received badge  Nice Answer (source)
2019-02-05 13:06:05 +0100 answered a question Which functions take regular expressions or patterns?

Functions that support Wildcards or Regular Expressions and depend on the setting under Tools -> Options -> Calc -

2019-02-04 22:47:28 +0100 answered a question How do I set multiple rows as a header in calc?

Additionally to freezing rows in the view, for repeating column headers in prints see https://help.libreoffice.org/lates

2019-02-04 22:39:34 +0100 answered a question Can not install 6.1.4.2 in Windows 10

Maybe one of the Windows installation issues FAQ, i.e. previous version installer is requested.

2019-02-04 22:30:51 +0100 commented answer Create barcodes in calc

And btw, please don't post questions as wiki, thanks.

2019-02-04 22:30:19 +0100 answered a question Create barcodes in calc

There is an (apparently) QR-Code extension that provides a GENBARCODE() function in Calc, and an older Barcode extension

2019-02-04 22:04:57 +0100 commented answer If condition --> change background color of cell

the STYLE() function is common heritage I know, and it pre-dates conditional formatting. It was introduced for asyn

2019-02-04 22:00:32 +0100 commented question Warum verändern die Zellenbezeichnungen A und 1 bei Aktivierung sich in Kästchen?

Vermutlich nicht, sondern das wird das temporäre Verzeichnis sein, das LibreOffice anlegt und benutzt und nach Beenden w

2019-02-04 21:57:17 +0100 commented answer How do I install the different language pack on a Raspberry Pi 3?

Which doesn't imply whether it's .deb or .rpm packaging, IMHO..

2019-02-04 21:55:24 +0100 commented question I donated $10 CAD 2 days ago. Please confirm that it is received. Thank you.

Thanks Mike. Yes, I should thanked for the donation of course.

2019-02-04 21:45:52 +0100 commented answer Calculate time difference

Instead of forcing some results to Text by using the TEXT() function (whereas that textual result then maybe can't be us

2019-02-04 21:33:54 +0100 edited question I donated $10 CAD 2 days ago. Please confirm that it is received. Thank you.

I donated $10 CAD 2 days ago. Please confirm that it is received. Thank you. Donation: $10 CAD Date donated: Feb 2 or

2019-02-04 21:33:36 +0100 commented question I donated $10 CAD 2 days ago. Please confirm that it is received. Thank you.

This is not a donation confirmation site. Furthermore, as this is a public questions and answers site, anyone can read t

2019-02-03 15:18:55 +0100 commented answer How do I install the different language pack on a Raspberry Pi 3?

As the question mentions LibreOffice 5.2.7.2, pointing to language packs of version 6.1.4 is wrong; at the best case the

2019-02-03 15:11:08 +0100 commented answer How to only format 20 columns on spreadsheet

Seems that was an unhelpful comment masqueraded as an answer which it was not.

2019-02-03 15:09:39 +0100 answered a question How to only format 20 columns on spreadsheet

Just use only the columns you want to use. Empty columns are also not stored in a document so don't take space if that c

2019-02-03 15:03:47 +0100 commented question how to format only 30 columns on spreadsheet

Apparently a duplicate of https://ask.libreoffice.org/en/question/181588/how-to-only-format-20-columns-on-spreadsheet/

2019-02-03 14:58:22 +0100 commented answer If condition --> change background color of cell

Just as a side note, the STYLE() function is a LibreOffice-only function, whereas conditional formatting is supported by

2019-02-03 14:46:13 +0100 commented answer If condition --> change background color of cell

Just as a side note, the STYLE() function is a LibreOffice-only function, whereas conditional formatting is supported by

2019-02-02 20:25:47 +0100 received badge  Necromancer (source)
2019-01-26 22:10:28 +0100 commented question I have a excel file that will not open

Try to open the file with LibreOffice, maybe it will do a better job. ;-P

2019-01-26 22:07:52 +0100 answered a question How do I force recalculate on value in cell which references another spreadsheet file?

F9 (on a cell or when automatic recalculation is disabled) or Shift+Ctrl+F9 recalculate formulas with the current spread

2019-01-26 22:00:39 +0100 commented question Warum verändern die Zellenbezeichnungen A und 1 bei Aktivierung sich in Kästchen?

Eventuell LibreOffice Benutzerprofil zurücksetzen, entweder mit Hilfe -> Im abgesicherten Modus neu starten... und na

2019-01-26 21:51:15 +0100 answered a question IF-Funktion mit Divisions-Ergebnis als condition

=IF(B2=B1/60;"entspricht";"entspricht gerundet")

2019-01-23 21:16:26 +0100 answered a question How to use MONEYTEXT functions?

Haven't the Numbertext extension currently installed myself, but the second argument likely is case significant, so for

2019-01-23 20:52:04 +0100 commented answer cells locked together

You mean if you change data in a cell in column A its row automagically gets sorted to a different position? No, that's

2019-01-23 20:46:54 +0100 commented answer [Calc] DBF export filter uppercases field names in 6.1

The original dBASE software stored only upper case field names. I don't know if there is a normative reference or whethe