Re: [libreoffice-users] Email more than once .doc file

2012-05-07 Thread Ing. Jiří Hladůvka
, Jiri -- Ing. Jiří Hladůvka - REVIDA http://www.revida.sk mailto:m...@revida.sk -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http

Re: [libreoffice-users] OT Re: Urgent Base problem (7-zip)

2012-03-20 Thread Ing. Jiří Hladůvka
and cannot be deleted -- Ing. Jiří Hladůvka - REVIDA http://www.revida.sk mailto:m...@revida.sk -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http

Re: [libreoffice-users] Re: Address Books

2012-03-16 Thread Ing. Jiří Hladůvka
and discover the beauty of possiblities given to more experienced users. :) Best regards, Jiri P.S. users@global.libreoffice.org does not accept enclosures - I hope Nino does. If someone else wishes to get the file let him drop me a line to m...@revida.sk -- Ing. Jiří Hladůvka - REVIDA http

[libreoffice-users] CALC bug in copy as unformatted text

2012-03-08 Thread Ing. Jiří Hladůvka
bottom right cell) When I confirm th dialog then text is copied but cell B2 has the content unchanged (is not empty like in E2) How can I get the required result using the icon in the toolbar? Thanks, Jiri -- Ing. Jiří Hladůvka - REVIDA http://www.revida.sk mailto:m...@revida.sk

Re: [libreoffice-users] How do add percentage in Calc?

2012-03-03 Thread Ing. Jiří Hladůvka
-tp3794847p3794847.html Sent from the Users mailing list archive at Nabble.com. -- Ing. Jiří Hladůvka - REVIDA http://www.revida.sk mailto:m...@revida.sk -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how

Re: [libreoffice-users] How do add percentage in Calc?

2012-03-03 Thread Ing. Jiří Hladůvka
Or you can make a macro which makes the calculation and rewrites the contents of A1 with a new value. You can trigger the macro every time the value in A2 is changed. It should be very easy (using recording macro and data validation). Jiri Dne 3.3.2012 10:24, Ing. Jiří Hladůvka napsal(a): Hi

Re: [libreoffice-users] program will NOT install RE http://www.libreoffice.org/download35/

2012-02-20 Thread Ing. Jiří Hladůvka
desktop just copy the whole folder somewhere to the harddisk C: or D: Then adjust the association of odf files to the proper LibO .exe files (D:\LibreOffice 3.4\program\swriter.exe, scalc.exe ...) Best regards, Jiri -- Ing. Jiří Hladůvka - REVIDA http://www.revida.sk mailto:m...@revida.sk

Re: [libreoffice-users] Re: Renaming Tabs in a spreadsheet in bulk.

2012-02-03 Thread Ing. Jiří Hladůvka
: - keep unformatted data in Sheet1 - this is your database - have selected time period filtered in datapilot in Sheet2 - define once, change filter only - format a nice presentation of v-looked-up values in Sheet3 - define once - it presents data of Sheet2 Regards, Jiri -- Ing. Jiří

Re: [libreoffice-users] Re: Suggestions for LibreOffice

2012-01-29 Thread Ing. Jiří Hladůvka
documents using a problem structure folders (e.g. DATA/Clients/Company1/Reports/Financial/2011/...) Best regards Jiri -- Ing. Jiří Hladůvka - REVIDA http://www.revida.sk mailto:m...@revida.sk -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http

Re: [libreoffice-users] Re: LibreOffice 3.4.4 - Error: wrong data type.

2011-12-30 Thread Ing. Jiří Hladůvka
to the original context of http://nabble.documentfoundation.org/LibreOffice-3-4-4-Error-wrong-data-type-tt3614423.html ??? http://nabble.documentfoundation.org/LibreOffice-3-4-4-Error-wrong-data-type-tp3614423p3622035.html Sent from the Users mailing list archive at Nabble.com. -- Ing. Jiří Hladůvka

Re: [libreoffice-users] Re: Cell formatting with CSV files in Calc

2011-12-28 Thread Ing. Jiří Hladůvka
-- Ing. Jiří Hladůvka - REVIDA http://www.revida.sk mailto:m...@revida.sk -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org

Re: [libreoffice-users] Calc: Identifying duplicate cell values with conditional formatting?

2011-12-12 Thread Ing. Jiří Hladůvka
1) put into C1 formula =lower(a1) 2) sort te table on c column 3) put to d1 =0 4) put to d2 = if(c2=c1;1;0) and copy the formula to all rows in d column. 5) select d column, copy CTRL+C and paste special back as unformated text 6) rows with value 0 in d columns have duplicit value with the row