Ask Your Question

erAck's profile - activity

2020-05-26 21:35:48 +0200 answered a question Calc: LINEST formula stopped working - {1,2,3} gets replaced with #NAME?

Formula Wizard. I check/tick the "Array" box and hit RETURN or click on OK. Then {1;2;3} in my formula turns into #NA

2020-05-26 21:24:35 +0200 commented question macro to save all .xls files in directory to .csv

Fwiw, in the "Linux" (rather (POSIX) shell) version the ls subshell command is not only superfluous but may have the und

2020-05-26 02:22:43 +0200 commented answer What is the maximum number of characters in a Calc cell?

Some spreadsheet functions though may still be limited to process only up to 64k characters per cell.

2020-05-26 02:20:33 +0200 commented answer What is the maximum number of characters in a Calc cell?

Probably the data is malformed for CSV and opens a quoted field that is never closed, thus the remainder correctly is al

2020-05-26 02:01:29 +0200 commented question how can i make libreoffice not use gpu in my linux

What is your problem with LibreOffice using the GPU? What setting are you setting to what value in the GUI exactly?

2020-05-26 01:42:56 +0200 commented question How can I import a csv in Calc WITH the leading zeros that are in the csv file?

How Calc converts text to numeric on the fly (not import) during calculations depends on the settings under Tools ->

2020-05-26 01:14:05 +0200 commented answer Libreoffice Calc Sum of values depending of month and year of a range of dates

Then probably your date values are not numeric dates but text that looks like dates. See this FAQ.

2020-05-20 16:24:57 +0200 answered a question Refresh/reapply an auto-filter in Calc

Sounds like tdf#130770 that is fixed for upcoming 6.4.5 and 7.0

2020-05-20 16:08:03 +0200 commented answer compare to open office

¯_(ツ)_/¯ .

2020-05-20 16:04:18 +0200 commented answer appdata/roaming error message?

Yes, it looks like a relative reference problem. My guess is the original document was created as user leigh with an ext

2020-05-20 00:47:45 +0200 answered a question appdata/roaming error message?

Likely the Excel file you opened has external references to a file similar to the one displayed in the dialog and Calc t

2020-05-20 00:34:12 +0200 answered a question In Calc, how do I expand cell-size to fill the sheet?

However, you can achieve that if you lookup the paper format size and subtract the margins, under File -> Print Previ

2020-05-20 00:29:25 +0200 commented question In Calc, how do I expand cell-size to fill the sheet?

Erm.. why don't you use Writer then? It automatically prints content to margins. Are you sure you want to (mis|ab)use Ca

2020-05-20 00:14:50 +0200 commented answer compare to open office

I'd say that "is it worth" can be answered anyway: Yes, absolutely.

2020-05-19 08:18:16 +0200 received badge  Nice Answer (source)
2020-05-19 02:36:55 +0200 answered a question Live stock quotes(?)

You'll find Link to External Data under the Sheet menu, not Insert (that was some versions ago). See also the help.

2020-05-19 02:21:03 +0200 answered a question compare to open office

This has years of continuous development, the other has years of continuous stagnation.

2020-05-19 01:53:16 +0200 commented answer Libreoffice Calc Sum of values depending of month and year of a range of dates

You just omit the range of data to sum so that the elements are summed/counted where the (products of) condition(s) is(a

2020-05-14 18:46:25 +0200 commented question Typed Capital letter. Enter. Lower case letter shows up

Calc follows the same AutoCorrect settings regarding two INitial CApitals.

2020-05-14 18:44:15 +0200 commented question Why do charts not filter the data using Autofilter or Pivot Tables

There's even help for it ;-) And charts do respect filtered and hidden rows' data, so maybe you are doing something dif

2020-05-14 08:38:45 +0200 received badge  Nice Answer (source)
2020-05-14 01:20:34 +0200 commented answer Using conditional formatting to change the number format

The Ubuntu LTS releases don't catch up on newer software. There's an Ubuntu LibreOffice PPA with more recent releases.

2020-05-14 01:08:40 +0200 commented answer download newer version of LibreOffice didn't work

Apart from that it's not an answer to the original question (so please do not use the Answer field for such), any reason

2020-05-13 17:49:15 +0200 answered a question Regexp for several search&replace

First, do not use string results ("2,2";"2,4";"2,6") if you want to calculate with numbers, use numeric data instead (2,

2020-05-13 16:33:12 +0200 answered a question autofill date increase by a day seems broken in 6.4.3

Your date seems to be displayed as DD/MM/YY and incrementing a sequence of 05/11/20 05/12/20 (i.e. one month difference)

2020-05-13 13:15:53 +0200 commented answer Find Array Function Issue [Bug]

Fixed for 6.4.5

2020-05-12 18:58:29 +0200 commented question Custom date format with [$-xxx] language code while ex/im-port .xls (97)

Not necessary anymore as already implemented, see tdf#73063 and tdf#128649.

2020-05-12 18:56:34 +0200 answered a question Custom date format with [$-xxx] language code while ex/im-port .xls (97)

Your LibreOffice version does not support saving the number format's locale information to Excel file formats yet, that

2020-05-12 18:32:24 +0200 answered a question Using conditional formatting to change the number format

The conditional format style's number format not taking precedence over the underlying hard number format attribute was

2020-05-12 18:23:05 +0200 answered a question How do I get rid of the apostrophe before a number in Calc?

See this FAQ.

2020-05-12 10:07:32 +0200 received badge  Nice Answer (source)
2020-05-11 17:57:23 +0200 answered a question No simple SUBSTITUTE in macros?

The Replace() function.

2020-05-11 17:49:59 +0200 commented question Date showing as $ unless clicked into

Please attach a (redacted) sample document, edit your question and use the paperclip to do so.

2020-05-11 15:20:50 +0200 commented answer How to make sure Calc copies cell data (Using Ctrl C) instead of copying an image of the cell ?

Note that clipboard managers breaking copy&paste is not a problem of LibreOffice. For the specific case of recent Ub

2020-05-08 18:23:23 +0200 commented answer Calc: changes being tracked - never asked for this

Fwiw, the same functionality is under Edit -> Track Changes -> Record.

2020-05-07 18:33:03 +0200 answered a question My default path for documents is not correct.

To mass adjust things, if you are brave and can handle an editor to edit a bit more complicated data you could close all

2020-05-07 18:09:12 +0200 commented answer VLookup is not adding correctly?

You didn't have enough karma. I upped your question so attaching a file should be possible now.

2020-05-07 08:28:36 +0200 received badge  Nice Answer (source)
2020-05-07 00:00:21 +0200 answered a question Where can i download a duch language pack as the language is not in the installer?

The Windows installer includes all language packs built, not running Windows myself I heard that simply opening the inst

2020-05-06 20:42:57 +0200 commented answer how to convert filenames to links en masse

If you are still reading this, could you point out how I could have discovered that function, and the semantics of th

2020-05-06 19:57:14 +0200 commented answer how to convert filenames to links en masse

Of course do not enter the formula in A1 but for example B1. Then pull copy-paste down.

2020-05-06 19:53:40 +0200 commented question base data import from excel

Readability hint: start a new paragraph now and then by hitting Enter twice, i.e. have a blank line between.

2020-05-06 19:48:09 +0200 answered a question How can I stop the "currency format" button turning negative numbers red?

The default format of the currency format button can't be individually changed other than choosing the default currency.

2020-05-06 19:39:28 +0200 answered a question How to convert specific sheet in xlsx file to csv file?

You can't from the command line. The command line conversion always converts the first sheet.