Ask Your Question

erAck's profile - activity

2019-08-21 20:56:22 +0200 answered a question Wie kann ich neue Schrift Fonts installieren

LibreOffice benutzt die Schriften des Systems. Also: Alle LibreOffice Fenster schließen. Schrift in deinem Betriebssys

2019-08-19 21:23:09 +0200 commented question How do i add amounts in a column

Duplicate of https://ask.libreoffice.org/en/question/205297/how-do-i-add-totals-in-a-column/

2019-08-19 21:17:40 +0200 answered a question How do I get Calc to look like Excel 2003

Assuming that you actually mean LibreOffice instead of OpenOffice (then please also write the proper name) ... otherwise

2019-08-16 20:53:14 +0200 commented answer need formula

Actually the formula in A7 can be simplified to =INDEX(A1:A4; MATCH(B7; B1:B4; 0)) Maybe that's even another cause why i

2019-08-16 19:37:11 +0200 commented answer How to make Calc update links to other files automatically?

you must trust your local file and not the source of your data. Another strange way of thinking required It's not s

2019-08-16 19:31:06 +0200 commented answer How to make Calc update links to other files automatically?

found on another forum website that Ctrl + Shift + F9 updates all the links in a sheet. That's not true, it recalcu

2019-08-16 19:27:02 +0200 commented answer How to make Calc update links to other files automatically?

a strange place for this setting, since no general user associates this path to the setting and its name Macro Securi

2019-08-16 17:40:53 +0200 commented answer need formula

Note that the formula expressions given contain extraneous spaces within the range references, which does not work (plus

2019-08-16 17:28:21 +0200 commented answer what is the shortcut key for autosum ?

Please do not use Answer for comments that are not an answer to the original question, use add a comment instead. Thanks

2019-08-16 17:22:47 +0200 commented answer How to turn off visualization for ifsum()

Probably by hitting Shift+F9 or Shift+F5 at some point.. If the answer solves your problem then please mark it as corre

2019-08-14 17:26:38 +0200 commented answer Problem with hlookup and indirect

INDIRECT() treats a database range differently than specifying it direct. Reason is that Excel does it the way INDIRECT(

2019-08-14 17:24:20 +0200 commented answer Problem with hlookup and indirect

INDIRECT() treats a database range differently than specifying it direct. Reason is that Excel does it the way INDIRECT(

2019-08-14 14:19:30 +0200 commented answer How to remove trailing spaces in calc

It works, as said the expression starts with a space so it is " +$" not "+$". The Highlighting munges that.

2019-08-14 14:15:10 +0200 answered a question Problem with hlookup and indirect

First, the formula in F18 is =HLOOKUP(G17;INDIRECT("F17");2;0) which INDIRECT() produces the address of the literal s

2019-08-14 13:55:42 +0200 commented question Problem with hlookup and indirect

what you call "ranges" should possibly work as auto-assigned column/row names No, in this case those names are defi

2019-08-14 13:54:27 +0200 commented question Problem with hlookup and indirect

what you call "ranges" should possibly work as auto-assigned column/row names No, in this case those names are defi

2019-08-14 13:47:25 +0200 commented answer How to remove trailing spaces in calc

I'd rather use +$ (note the expression starts with a space character which isn't that visible..) so a replacement is onl

2019-08-14 13:46:51 +0200 commented answer How to remove trailing spaces in calc

I'd rather use +$ so a replacement is only done when there actually is at least one trailing space. Using * matches also

2019-08-14 13:31:07 +0200 commented question Pipe + Right arrow cursor?

I've never seen that.

2019-08-14 13:25:01 +0200 commented answer How to reset LANG/Font

Wrong or broken font used for UI maybe. Anything under Tools -> Options -> LibreOffice -> Fonts in the Replacem

2019-08-13 21:42:51 +0200 received badge  Nice Answer (source)
2019-08-13 17:13:42 +0200 commented question Pipe + Right arrow cursor?

I think no one can guess what you're talking about. Is it the mouse cursor? Something else? Have other input devices att

2019-08-13 17:02:36 +0200 answered a question How to turn off visualization for ifsum()

It's the Detective, turn off with menu Tools -> Detective -> Remove All Traces.

2019-08-13 16:59:35 +0200 commented answer determine min and max dates (date/month) froma series of dates

Caveat, assuming this DATE(0;...) would yield year 0 is wrong, in fact it produces year 2000 because of the two-digit ye

2019-08-13 16:47:32 +0200 answered a question How to reset LANG/Font

Looks like the user has activated the Greek UI translation, take a look (best with your laptop aside) at what in the Eng

2019-08-13 16:28:37 +0200 answered a question Incorrect average of time in Calc

Make sure one of the values isn't actually 24 hours plus the displayed time, for example 32:00:00 instead of 8:00:00, wh

2019-08-13 16:20:05 +0200 commented answer Disable password protection

A clear indication not to give them admin access..

2019-08-13 16:10:36 +0200 commented answer Why does column AMJ show up after issuing "show columns"?

Glad to help. Then please mark the answer as correct by clicking the check mark icon. Thanks.

2019-08-13 16:09:08 +0200 commented answer How do I save my advanced filter to a new list?

Glad to help. Then please mark the answer as correct by clicking the check mark icon.

2019-08-12 17:32:37 +0200 answered a question Why does column AMJ show up after issuing "show columns"?

Ctrl+A then Show Columns (surprise ;-) Or to show only columns A to C input A:C in the Name Box and hit Enter, then Show

2019-08-12 17:21:54 +0200 answered a question How do I save my advanced filter to a new list?

Assign a criteria cell range a name (Sheet -> Named Ranges and Expressions -> Define (or Manage, or Ctrl+F3)) and

2019-08-12 17:11:14 +0200 answered a question Disable password protection

Different users share one single admin account and do their regular work under the admin account? Good luck with that..

2019-08-12 16:50:09 +0200 commented question How to send a request to developers?

This is nothing ODF related though.. ZoomText is a screen reader and accessibility technology (AT) handler.

2019-08-12 16:41:59 +0200 answered a question How to send a request to developers?

LibreOffice emits IAccessible2 events, a cross-platform accessibility interface standard, while ZoomText probably only s

2019-08-12 16:21:56 +0200 commented question libre office converted (broke) my .wps files to google files

And what are Google files anyway?

2019-08-12 14:34:39 +0200 commented question how to do in-text citations?

Changed common tag to writer so the question gets proper visibility.

2019-08-12 14:25:30 +0200 commented answer Getting #N/A with INDEX and MATCH

Might be due to that IFS() does not short circuit it's arguments (contrary to IF() and CHOOSE() that calculate only the

2019-08-01 22:32:44 +0200 commented answer LibreOffice Calc - read-only files

Please use add a comment for comments and thank you messages instead of adding them as answer to the the original questi

2019-08-01 22:18:55 +0200 commented answer Does LibreOffice support Adobe Type 1 fonts or not

And really, if you are a graphics designer you shouldn't rely on outdated and inferior font technology.

2019-08-01 22:17:43 +0200 edited answer Does LibreOffice support Adobe Type 1 fonts or not

First hit when typing type 1 into the Search or ask your question box: https://ask.libreoffice.org/en/question/92370/ho

2019-08-01 22:17:22 +0200 answered a question Does LibreOffice support Adobe Type 1 fonts or not

First hit when typing type 1 into the Search or ask your question box: https://ask.libreoffice.org/en/question/92370/how

2019-08-01 22:10:03 +0200 answered a question date displays wrong

You didn't say anything about your LibreOffice version nor the locale you work in, but it may be bug tdf#125109 which wa

2019-08-01 13:17:49 +0200 answered a question Libre office not starting in Debian Buster/Testing

Apparently you tried the snap from Canonical on Debian, I don't know if that is even supposed to work and I would not re

2019-08-01 12:44:54 +0200 commented answer Calculate total from fillable form

The question didn't mention PDF, but if that was meant then, yes, there's no such thing in a PDF export.

2019-08-01 12:40:26 +0200 commented question CSV to XLS in UNIX commands w/out losing any data or format

Without a sample file to investigate the crystal ball is foggy..

2019-08-01 12:38:18 +0200 commented answer Calc: How to enter equal sign as text

Even the @ setting does not allow to enter - - - as text It does, if you answer the dialog about formula correction

2019-08-01 12:37:47 +0200 commented answer Calc: How to enter equal sign as text

Even the @ setting does not allow to enter - - - as text It does, if you answer the dialog about formula correction

2019-07-23 17:34:33 +0200 commented question CSV to XLS in UNIX commands w/out losing any data or format

And please edit your question to add details, do not use the answer/solution text input. Thanks.

2019-07-23 17:31:05 +0200 commented question How build 4th "target" col based on earlier values compared to 3 cols?

Please try to not upload screenshots but a small sample document instead. Use the paperclip button for attachments. Than

2019-07-23 17:27:14 +0200 commented answer How build 4th "target" col based on earlier values compared to 3 cols?

This is not an answer, please edit your question instead. Thanks.