Ask Your Question

erAck's profile - activity

2021-05-14 19:59:37 +0200 commented question Any luck, will we get LibreOffice Calc's "AutoSum" and "Filter by Color" features?

What would your AutoSum do that the existing AutoSum does not?

2021-05-14 19:40:48 +0200 commented answer libreoffice4.2,4.3,4.4 couldn't boot on fedora32 and 33

Please do not use the Answer field if not an answer to the original question, edit your question instead to provide furt

2021-05-14 19:31:47 +0200 commented answer importing numbers from a separate worksheet

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

2021-05-14 19:12:54 +0200 received badge  Nice Answer (source)
2021-05-13 20:08:05 +0200 commented answer BASIC+Calc: how to check assigned password

It will not work if unprotect() fails due to a wrong password. Read what I wrote about it throwing an exception resultin

2021-05-13 19:58:32 +0200 commented question Calc Update data links with macro

Make sure it's .uno:UpdateTableLinks, note leading dot.

2021-05-13 19:26:05 +0200 answered a question libreoffice4.2,4.3,4.4 couldn't boot on fedora32 and 33

Check if some library is missing that version needs, i.e. preset LD_LIBRARY_PATH correctly like it's done in the /opt/li

2021-05-13 19:05:58 +0200 answered a question importing numbers from a separate worksheet

Use external cell references, either type in the form ='file:///home/user/filename.ods'#$Sheet1.A1 or see the help se

2021-05-12 15:22:46 +0200 commented question Why can I no longer enter data into my spreadsheets?

Whatever "shipped off the working page" might mean..

2021-05-12 15:15:26 +0200 answered a question BASIC+Calc: how to check assigned password

You could ask boolean oSheet.isProtected(). However, calling unprotect() with a wrong password will already throw lang::

2021-05-12 14:49:08 +0200 answered a question vlookup fails due to trailing spaces

Select the data column you want to clean and then use Edit -> Find and Replace... (Ctrl+H) with a regular expression

2021-05-12 14:33:31 +0200 commented answer how to get last non-empty cell in row(line)

Just adapt the references: =LOOKUP(2;1/ISNUMBER(B27:DZ27);B27:DZ27)

2021-05-11 23:24:49 +0200 received badge  Nice Answer (source)
2021-05-10 10:53:49 +0200 commented question Is there a symbol sorting standard? Calc and Excel are different.

What exactly are the differences for you between Excel and Calc?

2021-05-10 00:31:56 +0200 commented answer can i populate a spreadsheet using vbs and libre office?

Please do not use the Answer field for comments that are not an answer to the original question, use add a comment inste

2021-05-08 19:44:13 +0200 answered a question can i populate a spreadsheet using vbs and libre office?

If you are willing to rewrite at least parts to use the LibreOffice API and document model then the answer most likely i

2021-05-08 10:05:31 +0200 received badge  Good Answer (source)
2021-05-07 20:34:22 +0200 commented answer Where is print to FILE option

You were answering a 5 years old question, gave a misleading answer and not even read the provided correct answer. Delet

2021-05-07 16:06:05 +0200 answered a question How to autosize column widths in Calc?

Works the same in Calc. Alternatively right click on a column header and from context menu choose Optimal Width.

2021-05-07 16:03:44 +0200 commented answer Calc is shortening fully qualified paths to external files

Sheet - Link External Data does not work in LO 4 That's years old and way outdated. Ability to use CSV as linked ex

2021-05-07 14:51:09 +0200 received badge  Nice Answer (source)
2021-05-07 14:22:21 +0200 answered a question how to get last non-empty cell in row(line)

See this question's answer: Return the last value in a column.

2021-05-06 20:14:08 +0200 answered a question Calc: Indirect problem with file reference

Remove the extra double quotes around the string in A100. You need them to quote a literal inline string as argument, bu

2021-05-06 20:13:23 +0200 answered a question Calc: Indirect problem with file reference

Remove the extra double quotes around the string in A1. You need them to quote a literal inline string as argument, but

2021-05-06 14:09:04 +0200 commented answer How to calculate in a cell the sum of just the numerators of a column of fractions?

@karolus: please do not advise to calculate with text, I already mentioned above. It depends on the detailed string conv

2021-05-06 13:54:13 +0200 commented answer How to calculate in a cell the sum of just the numerators of a column of fractions?

I don't understand why you are referring to denominators Because summing numerators of fractions with different den

2021-05-05 22:18:41 +0200 commented question Why there are two versions of L.O. on Ubuntu 20?

Duplicate of https://ask.libreoffice.org/en/question/307906/why-there-are-two-versions-of-lo-on-ubuntu-20/

2021-05-03 20:26:38 +0200 commented answer Stop auto date?

Format as ?/16 fraction, as was mentioned above.

2021-05-03 15:41:05 +0200 answered a question Steuerzeichen in Calc nicht anzeigbar?

Besser einmal die Daten bereinigen als irgendwelche Klimmzuege mit Formeln.. Suchen&Ersetzen Dialog: Fuehrende Lee

2021-05-03 14:48:44 +0200 answered a question LibreOffice 7.1 Export png/jpg only valid for first (left) sheet?

With the second sheet being the active sheet, in the export dialog activate the Selection checkbox. Same for a selected

2021-05-03 14:43:26 +0200 answered a question Using VALUE function to compare two numbers yields incorrect results

https://erack.de/bookmarks/D.html#010203

2021-05-02 18:51:12 +0200 answered a question autofilter not showing all field names

You may have defined a database range comprising only columns A to AF. Check Data -> Define Range... and modify the R

2021-05-02 18:35:41 +0200 answered a question Newlines in strings are not displayed correctly...

Apparently old behaviour since OOo, I made that an EasyHack with code pointers for whoever wants to implement it. Thank

2021-05-02 17:29:15 +0200 commented question How to disable LibreOffice's DRM-like features

Strange people flying by here..

2021-05-02 17:25:54 +0200 commented answer Stop auto date?

Using formula expressions to input simple fractions is overkill, instead enter 0 8/16 as lined out in the help article p

2021-05-02 17:10:29 +0200 commented answer How to calculate in a cell the sum of just the numerators of a column of fractions?

You either input the formula in a cell and close with Shift+Ctrl+Enter instead of just Enter, or when using the Function

2021-05-02 16:51:02 +0200 commented question How to calculate in a cell the sum of just the numerators of a column of fractions?

The example 1 2/7 is 1+2/7 or 9/7.

2021-04-30 20:16:07 +0200 commented question How to calculate in a cell the sum of just the numerators of a column of fractions?

Not sure what you mean by nominators. There's numerator (the top part) and denominator (the bottom part). Assuming you m

2021-04-30 20:08:03 +0200 commented answer Fractions do not stay as fractions in Spreadsheet

Yes. The Input Line has no notion of fractions or other numeric number formats (except date and time).

2021-04-30 19:20:11 +0200 answered a question clearContents method not found

NamedRanges.getByName() obtains a sheet::XNamedRange interface that is not a cell range and has no clearContents() metho

2021-04-30 18:18:06 +0200 commented answer How to change column title from CLEAR to CLR?

Or just continue typing until you have CLR. AutoInput will keep suggesting CLEAR also for CL but not for CLR.

2021-04-30 18:06:20 +0200 commented answer How to access addNewByScopeName()

Hum yeah, there should be an optional interface document::XEventsSupplier exported by the sheet::Spreadsheet service (I

2021-04-29 19:51:09 +0200 commented question How to disable LibreOffice's DRM-like features

This is not even DRM related, but right, it's your computer and it's free software, so load the free source code onto yo

2021-04-29 19:30:54 +0200 commented answer How to access addNewByScopeName()

It is: https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1document_1_1XEventsSupplier.html#a5c96887

2021-04-28 16:42:16 +0200 commented answer How to access addNewByScopeName()

Indeed, it's missing. Should be [optional, readonly, property] though, as versions earlier than (which? would have to di

2021-04-28 08:38:01 +0200 received badge  Nice Answer (source)