Re: [libreoffice-users] Re: Calc: How to refresh advanced filter automatically
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 (prepared by another person) like: A | B | C | D M02My-very-complex-message M01 | =MID($A$1;C2;D2) | 1 | 10 M01 | =MID($A$1;C3;D3) | 11 | 10 M01 | =MID($A$1;C4;D4) | 21 | 10 M01 | =MID($A$1;C4;D4) | 31 | 5 M02 | =MID($A$1;C5;D5) | 1 | 3 M02 | =MID($A$1;C6;D6) | 4 | 2 So when I need to parse a message, I enter it into A1, then go to autofilter and select message type (01, if it's message 01) What I want is to eliminate this last step, so filter should change automatically when I enter message into A1. ... You can have a better solution Create a PARAMETERS sheet (it can be even in an external file) like M011 | 1 | 10 M012 | 11 | 10 M013 | 21 | 10 M014 | 31 | 5 M021 | 1 | 3 M022 | 4 | 2 which says : The 1st parsing result of the message of the type M01 is found in the source message at position 1 and is 10 chars long etc Let the parameters are in PAR.A1:C100 for example In the main document you can have a hiden sheet WORK besides the main sheet MESSAGE where in WORK.A1 is =MESSAGE.A1 WORK.A2 is a message type =left(A1;3) The first field: in WORK.B1 is the offset of the 1st field =vlookup(WORK.$A$2 1;PAR.$A$1:$C$100;2;0) in WORK.C1 is the field length =vlookup(WORK.$A$2 1;PAR.$A$1:$C$100;3;0) in WORK.D1 is the 1st field text =mid(WORK.A1;WORK.B1;WORK.C1) The second field: in WORK.B2 is offset of the 2st field =vlookup(WORK.$A$2 2;PAR.$A$1:$C$100;2;0) etc. You can have prepared let's the maximal number of fields And in the column WORK.C there will be parsed fields. You should maintain #NA values in the column if there is less fields In the mai sheet MESSAGE you can refer to the C column of the hidden WORK sheet. As soon as you type the message you can see the result without filtering. Thus the parsing rules are save from editing if the PARAMETERS sheet is read only or locked. Regards, Jiri -- 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/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calc: Converting Formula to Value
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 Display section at the top of the 2nd column. This does not *convert* formula to value. It only changes the display. ;-) Stefan -- 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/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Libreoffice Calc Insert - Formatting Mark / Format - Control / Format - Form menu not active ?
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 Calc menu's CALC : : 1) Insert - Formatting Mark 2) Format - Control 3) Format - Form I have checked Calc documentation and calc online help but didn't found much information about the same, i am learning libreoffice and above menus are new for me, so if anybody have detailed information on these menu and how above menus can be activated please let me know, for reference i have enclosed screenshots of the same. -- 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/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] copy from Thunderbird and paste to Calc
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. Create an empty spreadsheet 5. Past the clipboard in a cell It should work. Now try (quotes around the name): libreoffice-users Mailing List users@global.libreoffice.org It only pastes what is inside the quotes. Even past-special doesn't work. Past into the expression bar, it works. On WinXP/Home it appears as a text in the cell if pasted into the expression bar as well as pasted into the cell being edited (after double clicked the cell and pasted into the text cursor position. If the cell is only selected (not being edited) the CTRL+V pastes twoo lines into the cell and the second line includes the link mailto:users@global.libreoffice.org Regards, Jiri -- 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/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Mutiple sheet entries, unwanted
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): I have a spreadsheet consisting of 4 sheets with totally different data on each sheet. When I enter data on sheet 1 it is automatically copied into sheet 2 and 3. Sheet 4 remains unchanged. How can I limit the change only to sheet 1? -- View this message in context: http://nabble.documentfoundation.org/Mutiple-sheet-entries-unwanted-tp3272310p3272310.html Sent from the Users mailing list archive at Nabble.com. -- 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/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Ability to change currency as neededacross a spreadsheet in Calc?
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 from printing and eventually locked from users which sheet contains only supporting formulas and computations based on the parameters and data enterd somwhere else. It usually contains current exchange rates vlookup-ed in a separate spreadsheet. Currency used in the report is usually placed in the report header ( first several rows of the sheet) e.g. All numbers in EUR (that is as a formula for example =All numbers in $Parameters.$D$4 ) or in the column headers of the report actually linked from Parameters or Work. Changing the currency is then only a matter of adjusting the Parameters sheet. I never use the number format with currency sign, as the reports are better readible, it saves the column width (and the printer toner) and usualy there are not mixed financial values with kilometers, liters or emploies number :) Regards, Jiri Dne 14.7.2011 20:58, Twayne napsal(a): In news:1310666739.4101.16.camel@planas-pinguy, planasjsloz...@gmail.com typed: Hi Geoff, On Thu, 2011-07-14 at 08:04 -0700, floridabrits wrote: Hello LibreOffice fans... I'm looking for some help with calc on a spreadsheet that I have set up. I'm not sure if it needs a macro set up, or if there's something in LibreOffice that will do this for me, or if I have to seek custom development to do this Here's the problem: - I have a large risk management spreadsheet that contains a number of cells with currency based risk numbers in it; some of these are manually entered by the user and some are calculated from cells where the user enters the information. - Currently, the financial risk cells are all in USD ($) currency. - If I have a user in another country that wants to use this spreadsheet, I'd like that person to be able to either press a button, or select from a drop-down list, a list of available currencies to choose from. - When they choose their currently, I want a macro (or something!) to go and find all the US currency based cells in the spreadsheet and change them to the currency selected by the user. - If I can get this to work, then this spreadsheet could pretty much be used in any country/currency and the user would not have to go into every single currency based cell and make the changes needed (which would be time prohibitive). - i.e. Looking for a minimum click solution to achieve this. I do realize that the local install will change the currency for the user by default, but I want to be able to over-ride this so that if a local user sees the spreadsheet in USD and changes it to, for example, GBP, then when he sends it back to me, I see the numbers in GBP and not my local language setting (which would default back to USD). I hope I have explained this clearly! If not please don't hesitate to ask... Has anyone done this before or have any ideas how to achieve what I am looking for? Many thanks in advance. Regards, Geoff -- View this message in context: http://nabble.documentfoundation.org/Ability-to-change-currency-as-needed-across-a-spreadsheet-in-Calc-tp3169381p3169381.html Sent from the Users mailing list archive at Nabble.com. If I understand you problem, you want to show the currency in a user defined manner. One possibility is to have a cover worksheet that summarizes the data in any currency. You might use a macro to set the proper currency and exchange rates. One idea that might make finding all the cells with data to be converted is to name each one as a one-cell range (ex the cell sheet4!C3 is named 'Fred'). -- Jay Lozier jsloz...@gmail.com You could only make that work if you included a look-up on the exchange rates for every monetary system you wanted to use as they change daily, even hourly in some cases, and a number today m,ight not be accurate tomorrow. How much accuracy do you requre in other words? You could take a bath in some cases. Otherwise, just set up your currency multipliers in hidden columns and do the multiplication. HTH, Twayne` -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Ability to change currency as needed across a spreadsheet in Calc?
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 curencies e.g. D1:D4 ( in D1:D4 should then be e.g. USD, EUR, GBP, PLZ ) The user will be able to expand the list and to select what he/she needs when the cell A2 gets the focus (when the cursor is in the cell). You can fill in the bookmarks Input Help and Error alert, too. The users will be happy :) Jiri Dne 14.7.2011 17:04, floridabrits napsal(a): ... - i.e. Looking for a minimum click solution to achieve this -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] xls file causing crash
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 repeatedly. Dave Griffiths wrote: I just tried and found no problem opening the file. I run openSUSE 11.4 64 bit with: LibreOffice 3.3.3 OOO330m19 (Build:301) tag libreoffice-3.3.3.1 El Cico wrote: I can open the file and see data and chart. LibreOffice 3.3.2 OOO330m19 (Build:202) tag libreoffice-3.3.2.2, Ubuntu package 1:3.3.2-1ubuntu5 Thanks for all your replies. It seems that the responses are pretty varied, and not really consistent. For instance, it crashed my LibO 3.3.2 in Win7, and Sigrid Carrera's LibO 3.3.3 (not sure what OS). But it worked on El Cico's LibO 3.3.2 and Dave Griffiths' LibO 3.3.3. I've tested it again today, and I found it working in both OOo 3.2.0 and LibO 3.3.2 (which didn't work yesterday). Also, I notice that sometimes it maintains the chart data, but other times it loses it (my own case, OOo 3.2.0 maintained the data, LibO 3.3.2 lost it). I was hoping that I could narrow down the possibilities to file a proper bug report, but I can make no sense of this. Regards Stephan -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] HTML entities
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 html. Is it normal that libreoffice do not use html entities? (eacute; instead of é) I didn't have this problem with OOo LibreOffice 3.3.2 - Linux debian 64 Example : !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTML HEAD META HTTP-EQUIV=CONTENT-TYPE CONTENT=text/html; charset=utf-8 TITLE/TITLE META NAME=GENERATOR CONTENT=LibreOffice 3.3 (Unix) META NAME=CREATED CONTENT=20110428;20121400 META NAME=CHANGED CONTENT=20110428;20130700 STYLE TYPE=text/css !-- @page { margin: 2cm } P { margin-bottom: 0.21cm } -- /STYLE /HEAD BODY LANG=fr-FR DIR=LTR P STYLE=margin-bottom: 0cmééé/P /BODY /HTML Regards, sms. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted