## New answers tagged libreoffice

0

I needed to do that conversion some time ago, and I used unoconv in this way:
$ unoconv -f pdf -e PageRange=1-3 file.doc
It will convert to pdf only the first three pages.
Let me know if that works for you.

0

Another option is the Power Query Add-In - this can create filtered and sorted tables based on another table. It has the advantage over Pivot Tables that the PQ output is a regular Excel table, whereas a Pivot Table output is limited to a summary of numeric values by dynamic rows and/or columns.
PQ also has a lot of data transformation capabilities, that ...

0

You should have your source data as a data table and create a series of pivot tables to show subsets of the original data

0

It is clearly a legitimate functionality (I've just lost a few hours worth of work in LO Writer after non recoverable crash, which is why I'm searching fo such a solution), but strangely enough I haven't been able to find a perfect solution. The closest might be the following macro published 6 years ago, so I don't know if it will be compatible "out of the ...

0

Reverse the test, use:
=IF(NOT(ISBLANK(B2)),A2)
or
=IF(ISNUMBER(B2),A2)
or
=IF(ISBLANK(B2),0,A2)

1

I am going to assume that 1) You want this numbering to appear in a header or footer, 2) that you definitely want the "of new page count total" to appear (i.e. of 2-- would have been a lot easier if you didn't need that) and 3) that you don't have the header or footer already created--if you do, start from "Explanation as to why the following steps are ...

1

If you changed your 14:00 to currency you will get 0,583333333333333, so if you multiply by 10 you get 5,83 €.
Number comes from division of 14 and 24. 14/24=0.58333. 24 are hours in a day.
So the answer is to change your formula to turn the fraction back into a number of hours:
=G2*24*10

Top 50 recent answers are included