We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Laniakea's profile - activity

2021-05-05 09:15:24 +0200 commented answer [LibreCalc] Adding date cell that is always up to date

Thanks, you're the best! That's exactly what I was looking for.

2021-05-05 09:14:33 +0200 marked best answer [LibreCalc] Adding date cell that is always up to date

Hello!

I'd like to have a cell in LibreOffice Calc that always displays the current date when the file is being opened.

Is that something that is possible? If so how would I do that?

Kind regards, Laniakea

2021-05-05 07:24:59 +0200 received badge  Notable Question (source)
2021-05-04 16:47:17 +0200 received badge  Popular Question (source)
2021-05-04 13:26:11 +0200 asked a question [LibreCalc] Adding date cell that is always up to date

[LibreCalc] Adding date cell that is always up to date Hello! I'd like to have a cell in LibreOffice Calc that always d

2021-04-22 10:00:55 +0200 received badge  Popular Question (source)
2021-04-21 14:22:13 +0200 marked best answer [LibreCalc] Sortierung von VLOOKUP-Ergebnissen

Hallo liebe Forumsmitglieder,

ich habe ein Problem mit einem Dokument. Da es sensible Daten enthält habe ich es mal mit "Spaßdaten" nachgestellt. Es sind genau genommen zwei Dokumente.

Dokument "Datenbank", worin Artikel mit Preisen und anderen Informationen hinterlegt sind und Dokument "Abrechnung", welches sich diese Daten selektiv, anhand einer Dropdown-Liste, holt und diese weiterverarbeitet. C:\fakepath\Abrechnung.ods C:\fakepath\Datenbank.ods

Mein Problem ist nun wie folgt. Ich will im Dokument "Abrechnung" die Spalte A sortierten. Die Daten sollen aufsteigend nach dem Alphabet angezeigt werden.

Tue ich dies im Originaldokument, so werden sämtliche Daten, die zu Spalte A gehören durcheinander gebracht.

Woran könnte das liegen?

P.S.: Mein OS ist Ubuntu Linux 64-bit & die Version von Libre: 6.2.8.2 Build ID: 1:6.2.8~rc2-0ubuntu0.16.04.1

2021-04-21 14:22:10 +0200 commented answer [LibreCalc] Sortierung von VLOOKUP-Ergebnissen

Hallo Opaque, vielen Dank für deine Antwort! Das hat den Fehler behoben. Ich habe auch die zwei zusammengefassten Bere

2021-04-21 14:05:27 +0200 marked best answer Different colors for databar

Hey there!

Does an option exist that can turn the databar different colors for certain ranges?

image description

i.e. can the bars turn from green (100% to 75%) through yellow (>75%; ≤50%) to red (>50%) ?

2021-04-21 13:54:07 +0200 asked a question [LibreCalc] Sortierung von VLOOKUP-Ergebnissen

[LibreCalc] Sortierung von VLOOKUP-Ergebnissen Hallo liebe Forumsmitglieder, ich habe ein Problem mit einem Dokument. D

2021-03-14 19:09:45 +0200 received badge  Famous Question (source)
2021-01-28 19:55:31 +0200 received badge  Notable Question (source)
2021-01-28 10:17:17 +0200 commented answer VLOOKUP not giving back correct values

Brilliant! That worked. Also simply sorting the column "Name" first helped too. Then you don't need the ;0 at the end.

2021-01-28 10:11:53 +0200 marked best answer VLOOKUP not giving back correct values

Hello!

The VLOOKUP feature is giving me incorrect values.

I have two files. File A C:\fakepath\List.ods is where the VLOOKUP is.

The data is coming from File B C:\fakepath\Prices.ods

Now I want to be able to select an item from the drop down list in File A and then receive the corresponding data from File B.

As you can see it isn't working correctly. For example: The item beer is supposed to be categorized as "beverage" yet VLOOKUP falsely declares it a fruit and also gives the wrong unit and price.

How do I fix this from happening?

Kind Regards Laniakea

P.S.: My OS is Ubuntu Linux 64-bit & I'm running Version: 6.2.8.2 Build ID: 1:6.2.8~rc2-0ubuntu0.16.04.1

2021-01-26 00:40:44 +0200 received badge  Popular Question (source)
2021-01-25 13:48:02 +0200 asked a question VLOOKUP not giving back correct values

[CALC] VLOOKUP not giving back correct values Hello! The VLOOKUP feature is giving me incorrect values. I have two fil

2021-01-05 13:59:38 +0200 commented answer [CALC] Conditional formatting overriding background color

Unfortunately clicking on "Standard" and confirming with "OK" doesn't seem to get rid of the transparent setting. But yo

2021-01-05 13:59:22 +0200 commented answer [CALC] Conditional formatting overriding background color

Unfortunately clicking on "Standard" and confirming with "OK" doesn't seem to get rid of the transparent setting. But yo

2021-01-05 13:55:52 +0200 received badge  Famous Question (source)
2021-01-05 13:54:30 +0200 commented answer [CALC] Conditional formatting overriding background color

While this is a workaround I feel it won't scale well. Also it's not flexible should I need to change the color pattern

2021-01-05 13:51:58 +0200 received badge  Supporter (source)
2021-01-05 13:51:57 +0200 marked best answer [CALC] Conditional formatting overriding background color

Hello, I'd like to have rows alternating background colors (grey/white), so I used Format > AutoFormatStyles to achieve that. However in the row "Reserve" I have 3 conditional format rules. If the cell contains one of three words it gets colored with the proper color I chose for that word. "Ja" gets colored green "Nein" gets colored red "Nachbestellt" gets colored yellow.

In the rules for the conditional formatting I have made sure to leave the background on "none". Yet it still somehow overrides the autoformats grey color. image description

How do I fix this?

Example file

EDIT: My OS is Ubuntu Linux 64-bit & I'm running Version: 6.2.8.2 Build ID: 1:6.2.8~rc2-0ubuntu0.16.04.1

2021-01-05 13:51:41 +0200 commented answer [CALC] Conditional formatting overriding background color

Unfortunately clicking on "Standard" and confirming with "OK" doesn't seem to get rid of the transparent setting. But yo

2021-01-05 08:45:13 +0200 commented question [CALC] Conditional formatting overriding background color

Uploaded an example file & added my OS/LibreOffice Version

2021-01-05 08:44:22 +0200 edited question [CALC] Conditional formatting overriding background color

[CALC] Conditional formatting overriding background color Hello, I'd like to have rows alternating background colors (g

2021-01-05 08:43:55 +0200 edited question [CALC] Conditional formatting overriding background color

[CALC] Conditional formatting overriding background color Hello, I'd like to have rows alternating background colors (g

2021-01-05 01:34:31 +0200 received badge  Notable Question (source)
2021-01-04 21:16:59 +0200 received badge  Student (source)
2021-01-04 18:46:10 +0200 received badge  Popular Question (source)