Ask Your Question

orschiro's profile - activity

2019-04-11 04:43:20 +0100 received badge  Famous Question (source)
2016-01-06 12:09:17 +0100 received badge  Notable Question (source)
2016-01-06 12:09:17 +0100 received badge  Popular Question (source)
2015-10-28 18:46:38 +0100 commented answer Deutsche Rechtschreibprüfung in LO5?

Das hat funktioniert. Herzlichen Dank!

2015-10-27 11:45:24 +0100 asked a question Deutsche Rechtschreibprüfung in LO5?

Die Erweiterung enthält keinen Hinweis zur Kompatibiltät mit LO5.

Wie installiere ich die deutsche Rechtschreibprüfung unter Ubuntu Linux 15.10?

2015-08-27 23:17:20 +0100 received badge  Notable Question (source)
2015-08-27 23:17:20 +0100 received badge  Famous Question (source)
2015-05-18 17:01:35 +0100 received badge  Enthusiast
2015-05-12 12:30:34 +0100 received badge  Popular Question (source)
2015-05-11 11:12:51 +0100 received badge  Famous Question (source)
2015-04-29 21:28:54 +0100 commented answer Variable reference to a sheet name

Stupid typing error on my side. Sorry! Your solution does work perfectly. :)

2015-04-29 17:26:33 +0100 received badge  Notable Question (source)
2015-04-29 17:25:24 +0100 commented answer Variable reference to a sheet name

Hi karolus, This only returns 0.00, unfortunately.

2015-04-29 11:49:42 +0100 asked a question Variable reference to a sheet name

Example:

Column 1 | Column 2
19       | ='19'.D19

In column 2 I reference to a sheet with the name 19. How can I make this reference to a sheet name variable based on the id in column 1?

For example, the next row could contain another ID for which I want to automatically reference to.

26        | ='$A3'.D19

The cell containing 26, in this case, is the cell A3.

Thanks!

2015-04-29 10:39:36 +0100 received badge  Supporter (source)
2015-04-29 10:39:14 +0100 commented answer Why LibreOffice is not using the Stack Exchange platform for Q&A?

I must admit that I also prefer the stackexchange platform:

  • their software is more mature
  • they have a large user base
  • they have connected areas (unix, stackoverflow)

Is someone willing to pursue a proposal with me?

2015-04-18 06:51:54 +0100 received badge  Notable Question (source)
2015-04-17 18:51:45 +0100 received badge  Popular Question (source)
2015-04-17 14:17:58 +0100 received badge  Scholar (source)
2015-04-17 10:18:48 +0100 asked a question How do I ignore cells with #N/A in a function?

I have thousands of rows of which a number contain #N/A. Running functions such as SUM or AVERAGE report an error when selecting a row sample that includes cells with #N/A. It's time consuming to remove these lines individually. Furthermore, I prefer to keep them for transparency reasons.

Is there any way to ignore these cells?

2015-04-17 09:48:54 +0100 received badge  Popular Question (source)
2015-04-14 15:36:36 +0100 asked a question Fill Data Series: Set hatching for entire chart automatically

Hi all,

I recently got the comment to please format my charts with a hatching fill to account for colorblind people. Is there any way to set hatching automatically for an entire chart in LibreOffice Calc?

I couldn't find this option but only the possibility to change the background colour to hatching for a single data series.

Thanks!