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

Ask Your Question

rama's profile - activity

2021-02-23 18:21:57 +0200 received badge  Notable Question (source)
2021-02-14 20:54:02 +0200 received badge  Popular Question (source)
2021-02-14 15:33:52 +0200 received badge  Popular Question (source)
2021-02-13 18:52:40 +0200 asked a question How can I get two separate ranges printed on the same page?

How can I get two separate ranges printed on the same page? I have defined a print range: A1:A9999;C1:C9999 When I pr

2021-02-13 16:12:48 +0200 commented question how to create a formula ?

Have you been looking into using a pivot table for this? Taking a quick look at your problem that might provide a simple

2021-02-13 16:10:58 +0200 commented question how to create a formula ?

Hello, it would be nice if you could change your subject/question to something more useful so other people also can bene

2021-02-13 16:08:27 +0200 commented question How do I put 2 documents on my screen at one time, so I can edit from one to the other. Example: agenda and minutes

Hello! Some more info would be good to make it easier to give you a good answer. Which software are you talking about? C

2021-02-13 16:06:15 +0200 asked a question Is there a shortcut for selecting the row I'm on in Calc?

Is there a shortcut for selecting the row I'm on in Calc? I've selected a cell in Libreoffice calc and would like to hav

2020-10-17 21:56:28 +0200 marked best answer How can I disable the use of standard ligatures?

I'm using a fixed width font, and Libre Office Writer replaces some letter sequences with the standard ligatures:

fi ff

That's great in most cases but in the case of a fixed width font it looks terrible of course. How can I disable this?

2020-09-11 08:25:51 +0200 received badge  Notable Question (source)
2020-09-11 08:25:51 +0200 received badge  Popular Question (source)
2018-06-02 08:31:44 +0200 received badge  Student (source)
2017-12-07 10:15:38 +0200 received badge  Famous Question (source)
2017-10-22 06:26:23 +0200 received badge  Notable Question (source)
2017-10-18 08:02:29 +0200 received badge  Popular Question (source)
2017-10-17 22:28:58 +0200 asked a question How can I disable the use of standard ligatures?

How can I disable the use of standard ligatures? I'm using a fixed width font, and Libre Office Writer replaces some let

2016-08-27 19:18:59 +0200 asked a question How can I export a multiselection in calc to PDF? (to include column headings)

I have a regular calc sheet where the first row is the headings for the column. How can I export a multiselection to PDF? That is, I want the headings and some rows of the table, but not everything inbetween. See example below where > denotes selection <:

> NAME        VALUE     <
  Lisa        hot dog
> Raggis      ice cream <
2016-03-18 12:30:07 +0200 received badge  Notable Question (source)
2016-03-18 12:30:07 +0200 received badge  Popular Question (source)
2016-03-18 12:30:07 +0200 received badge  Famous Question (source)
2015-10-07 11:20:14 +0200 answered a question How can I display the result from a time calculation as hours with two decimals, for example "1.25 hours"

Calc stores all timestamps as a decimal value where 1 equals 24 hours. So you could just do the calculation and display it in a cell without setting the format of the cell and get the decimal hours format by multiplying the cell by 24.

Example:

   A                         B                           C
2  12:00                     13:30                       =(B2-A2)*24

You will see 1,5 in cell C2.

2015-10-07 11:20:10 +0200 asked a question How can I display the result from a time calculation as hours with two decimals, for example "1.25 hours"

I'm doing a calculation where I deduct one timestamp from another. I want the result in hours with two decimals, for example 16:00-15:30 would be 0.5 hours. What cell format should I use?