Tag Info

New answers tagged

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