Re: [libreoffice-users] Re: Calc: How to refresh advanced filter automatically

2011-12-06 Thread Hladůvka Jiří
Spreadsheet is used to parse fixed-length messages. There are around 100 different messages, and each contains different fields. For example, message 01 contains 3 fields with length 10, and 1 field with length 5, and message 02 contains 2 fields with lengths 3 and 2. I have XLS file

Re: [libreoffice-users] Calc: Converting Formula to Value

2011-10-29 Thread Hladůvka Jiří
Copy the cells and paste as unformatted text (use the icon for pasting and select unformatted text) :) Dne 29.10.2011 1:28, Stefan Weigel napsal(a): Hi Tom, Am 29.10.2011 01:21, schrieb Tom Davies: Tools - Options - LibreOffice Calc - View and then UNtick the Formulas tick box in the

Re: [libreoffice-users] Libreoffice Calc Insert - Formatting Mark / Format - Control / Format - Form menu not active ?

2011-10-14 Thread Hladůvka Jiří
Try to enter some text into the cell and while typing chose the option from menu. While you do not edit some text the options stay disabled (greyed) Dne 14.10.2011 18:49, Vinod Nadiadwala napsal(a): Hi, I am having Libreoffice 3.4 installed on windows, i would like to know about following

Re: [libreoffice-users] copy from Thunderbird and paste to Calc

2011-09-14 Thread Hladůvka Jiří
Dne 14.9.2011 19:50, James napsal(a): I want to see if this works for anyone (on another than Linux platform). 1. compose a new message in Thunderbird 2. Enter libreoffice-users Mailing List users@global.libreoffice.org on the to line: 3. Select all the to: and copy it to the clipboard 4.

Re: [libreoffice-users] Mutiple sheet entries, unwanted

2011-08-21 Thread Hladůvka Jiří
You have probably sheets 1,2,3 selected. Right-click on the sheet bookmark (left down corner of the sheet) an choose Deselect All Sheets (to select some multiple sheets hold down CTRL and left click the sheets bookmarks). May it helps :) Regards, Jiri Dne 21.8.2011 8:53, sovdia napsal(a):

Re: [libreoffice-users] Re: Ability to change currency as neededacross a spreadsheet in Calc?

2011-07-15 Thread Hladůvka Jiří
Hi, in my spreadsheets there I usually have a special sheet named Parameters where I set some varying values such as - company name - period (weeknumber, year, month etc.) - local currency name or sign - other currencies used - and other ... Besides that I have a Work sheet which remains hidden

Re: [libreoffice-users] Ability to change currency as needed across a spreadsheet in Calc?

2011-07-15 Thread Hladůvka Jiří
Let, say that in parameters sheet you have - in A1 some label saying Choose your currency - in A2 some initial valu e.g. USD click to A2 and choose from Data - Validity -bookmark Criteria - field Allow select Cell range and into field source enter link to the range where you have allowed

Re: [libreoffice-users] xls file causing crash

2011-07-05 Thread Hladůvka Jiří
It crashed on LibO 3.3.3 on WIN XP/Home SP2 Regards, Jiri Dne 5.7.2011 13:14, Stephan Zietsman napsal(a): Sigrid Carrera wrote: I can open it with: LibreOffice 3.3.2 OOO330m19 (Build:202) Ver: 3.3.2.2-14.mga1 whereas LibreOffice 3.3.3 OOO330m19 (Build:301) tag libreoffice-3.3.2.2 crashes

Re: [libreoffice-users] HTML entities

2011-04-28 Thread Hladůvka Jiří
I think that if there is a metatag declaring the coding as charset=utf-8 then it is not necessary to use html entities. Did you check the html source text in the hexadecimal view ? Regards, Jiri Dne 28.4.2011 20:32, jmleyrie napsal(a): Hi, I use LibreOffice Writer to convert word doc file to