Re: [libreoffice-users] Calc: How to concat CTRL+ENTER to a string?
Hi William, Am 09.04.2015 um 13:17 schrieb William Drago: =CONCATENATE(Target Balance Assuming , E2*100, % Growth) I want everything after Target Balance to appear in the second line of the cell so that the cell looks like this: Target Balance Assuming xx% Growth First, you do not need to use CONCATENATE. You can just use the -operator for concatenating strings. However, you can use the CONCATENATE function, as well, if you want. ;-) For a line break, take the ASCII character no. 10. e.g. =Target Balance Assuming CHAR(10) E2*100 % Growth Cheers, Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- To unsubscribe e-mail to: users+unsubscr...@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] FEATURE REQUEST -- for the Sort options in Calc
Hi, Am 26.03.2015 um 01:57 schrieb Richard VINCK: For logical and safety reasons, and for compatibility with Microsoft Excel, I suggest that: * The Sort Option Range contains column labels be_unticked by default. Your suggestion does *not* establish compatibility with Microsoft Excel. Excel tries to *guess* whether the first row of your selection has to be sorted or not, by checking for significant differences between the first row and the subsequent rows in data type and/or formatting. Try yourself in Excel: Z 1 3 A 2 will disappoint your expectations, as well. ;-) It is good that LibreOffice has this option, but a beginner don't know that option and will sort what he/she has selected, and it is frustrating to see that the first column is not sorted at all, thinking it's a bug (like I did). When sorting, it´s not recommended to select a range, rather than a single cell. Calc (or Excel) will select the range to be sorted by its own. Selecting a specific range before sorting is only helpful for very special cases, when automatic selection fails. FYI: RTFM and study the rule For sorting, filtering, or using the Pivot Table, always select only one cell. on page no. 4 of this official manual: https://wiki.documentfoundation.org/images/6/69/CG4108-PivotTables.pdf Unfortunately, the chapter of the manual, that specifically deals with sorting, does not mention this rule. :-/ Cheers, Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- To unsubscribe e-mail to: users+unsubscr...@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 issue: display bug
Hi Eric, this might give you an idea: https://www.google.de/?q=run+vba+macro+in+libreoffice Perhaps it is possible to replicate the functionality by means of LibreOffice. Probably this requires a programming expert who can create the macro program in LibreOffice. (http://www.libreoffice.org/get-help/professional-support/) Maybe you can find an expert if you specifically ask for it here on the list or on disc...@documentfoundation.org. Greetings, Stefan Am 08.03.2015 um 22:51 schrieb Xbot: Thanks for your answer Stefan, About expectations, are you implying there is nothing to do to make this file working in LibreOffice? Le 08/03/2015 22:39, Stefan Weigel a écrit : Hi, Am 02.03.2015 um 15:52 schrieb Xbot: I've a display bug with a xlsm file opened with LO: how it is displayed in Libreoffice (4.3.4.1 and 4.4.1.2) : http://i.imgur.com/1gmRFnF.png how it is displayed in Excel (2007) : http://i.imgur.com/2ApxxVQ.png the xlsm file: http://demo.ovh.eu/download/81443811d52fef29c48908a28e57b895/1.xlsm How to fix it? Reduce your expectations. Especially because this file contains VBA-Code. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- To unsubscribe e-mail to: users+unsubscr...@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 issue: display bug
Hi, Am 02.03.2015 um 15:52 schrieb Xbot: I've a display bug with a xlsm file opened with LO: how it is displayed in Libreoffice (4.3.4.1 and 4.4.1.2) : http://i.imgur.com/1gmRFnF.png how it is displayed in Excel (2007) : http://i.imgur.com/2ApxxVQ.png the xlsm file: http://demo.ovh.eu/download/81443811d52fef29c48908a28e57b895/1.xlsm How to fix it? Reduce your expectations. Especially because this file contains VBA-Code. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- To unsubscribe e-mail to: users+unsubscr...@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: Split Move/Copy Sheet item in sheet tab menu
Hi, Am 18.02.2015 um 16:22 schrieb David Lynch: It is that the *default* behaviour is to overwrite the target (and no warning is given). Are your sure? When I try do move/copy a sheet to another document that already contains a sheet with the same name, I do get a warning and the OK button is inactive. So it´s impossible to overwrite the target. But, all this has nothing to do with splitting the Move/Copy Sheet command. Cannot lookup your bug, because the bug tracker is down at the moment. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- To unsubscribe e-mail to: users+unsubscr...@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: Split Move/Copy Sheet item in sheet tab menu
Hi, Am 18.02.2015 um 16:04 schrieb Kaj: I have not seen it being a problem, but am not against the change. I have not seen it as a problem, either. Every Calc user (and every Excel user) is used to it since decades. ;-) And I do not support changes, that do not result in a *major* improvement. Any change requires much effort, not only changing the code and doing QA, but also localisation, changing documentation, books, and so on. Let´s fix bugs instead! :-) Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- To unsubscribe e-mail to: users+unsubscr...@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] Where is Base?
Hi, Am 12.02.2015 um 08:55 schrieb pranzar: I just installed 4.4.03 on Windows 7. So did I. I'd like to use Base. I am using Base. When I click on the LibreOffice icon on my desktop, I see a screen with list of buttons on the left under Create. I select Base Database but nothing happens. The only buttons that work are Writer and Calc. What am I doing wrong? Did you unselect some components during installation? http://global.libreoffice.org/assets/Uploads/EN-Project_images/Installation/Windows/435customsetup.png Hav you tried rerunning the installation and selecting all? Greetings, Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- To unsubscribe e-mail to: users+unsubscr...@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] Website down?
Hi, Am 21.12.2014 um 11:13 schrieb Sun Shine: LibreOffice.org website is down see http://listarchives.libreoffice.org/global/website/msg13559.html Cheers, Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- To unsubscribe e-mail to: users+unsubscr...@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] Website down?
Am 21.12.2014 um 12:11 schrieb Sun Shine: Thanks Stefan - I wasn't sure how else to alert those who control the levers and pulleys to the issue. You did it right! Tanks a lot! :-) Stefan -- Stefan Weigel Volunteer on behalf of The Document Foundation LibreOffice Conference 2012 - Visa Support -- To unsubscribe e-mail to: users+unsubscr...@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] Website down?
Am 21.12.2014 um 12:11 schrieb Sun Shine: Thanks Stefan - I wasn't sure how else to alert those who control the levers and pulleys to the issue. You did it right! Tanks a lot! :-) Stefan -- To unsubscribe e-mail to: users+unsubscr...@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 and bookkeeping
Hi, Am 07.12.2014 um 14:12 schrieb Wiebe van der Worp: Input: In order to keep things simple: three columns with Description, Amount and a LedgerCode. Output: Sums per LedgerCode PivotTable aka DataPilot is exaktly what you are looking for. It´s a feature of Calc, of course. ;-) Here is the guide: https://wiki.documentfoundation.org/images/6/69/CG4108-PivotTables.pdf For better understanding I recommend reading Example 1 on pages 5 through 12 of this document, first: https://wiki.openoffice.org/w/images/5/52/0308CG3-DataPilot.pdf Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- To unsubscribe e-mail to: users+unsubscr...@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] The LOOKUP() function (Calc vs. Excel)
Hi, Am 30.11.2014 um 23:37 schrieb Carlo Strata: ... so this is an Excel problem because it behaves differently with respect to its own help...?!!! Not really. Excel states, that you must apply the first parameter and you must not leave it empty. (It´s required.) If you follow this, everything is fine. And it´s the same thing in LibreOffice. There is no specification for the behaviour of the function, in case it´s not used according to the rules. You can expect Excel and LibreOffice behave the same, if you use functions according to their definition and the instructions given in the documentation. You cannot expect identical behaviour, in case you violate the instructions. -- Your Problem is not an Excel problem neither a LibreOffice problem, it´s a users problem. ;-) Cheers, Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- To unsubscribe e-mail to: users+unsubscr...@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] The LOOKUP() function (Calc vs. Excel)
Hi, Am 30.11.2014 um 23:37 schrieb Carlo Strata: ... so this is an Excel problem because it behaves differently with respect to its own help...?!!! Not really. Excel states, that you must apply the first parameter and you must not leave it empty. (It´s required.) If you follow this, everything is fine. And it´s the same thing in LibreOffice. There is no specification for the behaviour of the function, in case it´s not used according to the rules. You can expect Excel and LibreOffice behave the same, if you use functions according to their definition and the instructions given in the documentation. You cannot expect identical behaviour, in case you violate the instructions. -- Your Problem is not an Excel problem neither a LibreOffice problem, it´s a users problem. ;-) Cheers, Stefan -- To unsubscribe e-mail to: users+unsubscr...@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] The LOOKUP() function (Calc vs. Excel)
Am 01.12.2014 um 14:58 schrieb Brian Barker: Excel needs comma separators instead of semi-colons, of course very much depending on locale, of course ;-) Stefan :-D -- To unsubscribe e-mail to: users+unsubscr...@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 forks
Hi, Am 15.10.2014 um 02:45 schrieb Bruce Byfield: For example, LibreOffice is a fork of OpenOffice.org. Not exactly. https://twitter.com/webmink/status/25769232489 For some people (including me) LibreOffice is the true OpenOffice.org, but it´s not allowed to use its original name. ;-) Stefan :-) -- LibreOffice - Die Freiheit nehm' ich mir! -- To unsubscribe e-mail to: users+unsubscr...@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 forks
Hi, Am 15.10.2014 um 21:48 schrieb Italo Vignoli: All projects using OOo code are forks under the technical point of view, as they have cloned the repository and applied significant changes to the code. Sure, the technical point of view. :-) But who cares about technics? ;-) What about the folks that build the community? And the spirit that carries the project? This does not feel like a split-off from 2010, rather a continuing evolution. Cheers, Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- To unsubscribe e-mail to: users+unsubscr...@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] Fill down with a twist.
Hi, Am 19.09.2014 um 09:01 schrieb martin f krafft: If a cell A1 contains '=B1' and I fill-down from A1 to A3, I get references to B2 and B3 for the two new cells. Is it possible to fill down, but scan right? E.g. make A2 become C1 and A3 become D1? This formula in A1 should behave as you desire: =OFFSET($B$1;0;ROW()-ROW($B$1)) Cheers, Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- To unsubscribe e-mail to: users+unsubscr...@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] Nitpicking on a name
Hi Charles, Am 25.07.2014 um 09:19 schrieb Charles-H. Schulz: Anyway the point I am trying to make is that LO does not mean anything and sends the wrong message. From my personal observation LO is a well established abbreviation for LibreOffice as well as AOO, OOo, MSO are well-known abbreviations for other products. As a kind of proof at least in german: http://de.wikipedia.org/wiki/LO ;-) Stefan -- To unsubscribe e-mail to: users+unsubscr...@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 function to return the daynumber weeknumber of the year
Hi, Am 19.07.2014 15:25, schrieb Tanstaafl: Is their one? Yes. https://help.libreoffice.org/Calc/WEEKNUM https://help.libreoffice.org/Calc/Date_and_Time_Functions#Functions Cheers, Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- To unsubscribe e-mail to: users+unsubscr...@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 convert text to numbers
Hi, What I am used to doing in Excel is copy everything in, then format the cells to be numbers and they are converted to numbers and my formula work. Really? I'm surprised. I didn't know Excel did this conversion just on formatting. I just tried in Excel 2013 and it´s simply not true. ;-) Changing the number format of a cell does not convert a text value into a number value. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- To unsubscribe e-mail to: users+unsubscr...@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] Mail Merge from different tables in database?
Hi Minhsien0330 Am 18.11.2013 09:55, schrieb minhsien0330: Suppose that I have a ods file with 2 sheets (sheet1 and sheet2), I setup a connection to this spreadsheet in Base for using Mail Merge. [...] Do you know how to include data the come from different database Tables when using Mail Merge? Look for the odb-file representing your data source, which is possibly based upon an ods-file . You can edit this database connection using LibreOffice Base. Create a query in Base that joins your two tables. In Writer refer to this query as your data source. Cheers, Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- To unsubscribe e-mail to: users+unsubscr...@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: CALC convert text to numbers
Am 15.11.2013 12:06, schrieb Brian Barker: Type '1234 into a cell, so that you get the four-character text string 1234 in the cell (not the five-character string '1234). I you do this, the content of the cell will be '1234 and the cell will display the text 1234 as a result. Now put =LEFT(Xn;1) in another cell - to extract just the first character. According to your theory, this formula should evaluate to just the apostrophe No. According to what the programme does, you will get the character 1, because it is the first character of the result in cell Xn. But it's surely not an operator when it appears in the Input Line. Yes it is. Just like an = tells the programme that the following has to be interpreted as a formula, the ' tells the programme that the following has to be interpreted as text. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- To unsubscribe e-mail to: users+unsubscr...@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: CALC convert text to numbers
Hi Paul, Am 15.11.2013 23:11, schrieb Paul: the behaviour is correct, and consistant with other spreadsheet programs. I never doubted. :-) Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- To unsubscribe e-mail to: users+unsubscr...@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 paste funnies
Hi Paul, Am 14.11.2013 22:12, schrieb Paul: When I select copy, everything works as expected, the cell gets a dashed border. If I ctrl-v, it pastes. But if I right-click, there is no Paste or Paste Special, only Paste Only, with nothing in that submenu. On the main menu at the top, under Edit, Paste and Paste Special are greyed out. I do experience this every now and then, however could not reproduce it reliably, which makes it difficult to report a bug. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- To unsubscribe e-mail to: users+unsubscr...@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: CALC convert text to numbers
Hi, Am 14.11.2013 22:39, schrieb Brian Barker: It's worth mentioning that this is a misunderstanding of what is happening. There is no apostrophe in the cell to remove. Yes there is! It's because these cell contents are very different that the apostrophe is necessary as a warning. It´s not a warning, it´s an operator. It's somewhat like the = at the beginning of a formula. Cheers, Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- To unsubscribe e-mail to: users+unsubscr...@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 bug? ] Function RANK() ranks error?
Hi minhsien0330, Am 13.11.2013 13:38, schrieb minhsien0330: There are 4 scores : 92.6, 93.6, 98.2 and 95.2 It's strange that the function RANK() rank 95.2 as no. 1 You can download this ods file to test: https://sites.google.com/site/minhsien0330/test/RANK_PROBLEM.ods?attredirects=0d=1 Is this a bug? No bug! Have a look at the references of your formulae in column C. I guess you did copy the first formula in cell C2 down to C3, C4 and C5. If you do so, you must declare absolute references instead of relative references. Change your formula in C2 from =RANK(B2,B2:B5) to =RANK(B2,B$2:B$5) before copying. :-) Cheers, Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- To unsubscribe e-mail to: users+unsubscr...@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: Engaging users: initial results of the survey
Servus Micheal, true, what you are saying, but one little thing: Am 12.11.2013 11:46, schrieb Michael Meeks: [ given the vast disparity in time-to-file (1 minute) vs. time-to-fix (5 man days avg) ] ...in correlation with 1 developer investing 5 days to fix it vs. maybe hundreds, thousands or even hundreds of thousands of users wasting for example 5 minutes per day due to the bug. :-D Cheers, Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- To unsubscribe e-mail to: users+unsubscr...@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 convert text to numbers
Hi, Am 11.11.2013 18:17, schrieb Oogie McGuire: What's a problem is that in Excel even though it also uses the leading ' to format text as numbers, if you change the format of a cell the conversions happen without any problems. That´s not true. I just tried in Excel. The leading ' stays, no matter what format you would apply. to me it makes sense that the cell format should be the controlling factor for what type of data is in a given cell. Absolutely no! Format must never have an impact on values or data types. That´s a matter of logics. Cheers, Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- To unsubscribe e-mail to: users+unsubscr...@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] vlookup with cell reference for range
Hi, Am 03.11.2013 18:19, schrieb yahoo-pier_andreit: the VLOOKUP formula is: =VLOOKUP(criteria,range,index,sort) if I write the function: =VLOOKUP(1,$A$1:$D$5,2,0) function works but if J1 is $A$1:$D$5 and the formula: =VLOOKUP(1,J1,2,0) the formula doesn't works Try the function INDIRECT https://help.libreoffice.org/Calc/Spreadsheet_Functions#INDIRECT Cheers, Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- To unsubscribe e-mail to: users+unsubscr...@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: Engaging Users in the LibreOffice Project
Hi, Am 03.11.2013 18:36, schrieb Kracked_P_P---webmaster: Access --LO Base Base does not replace Access and it´s not meant to do so. ;-) Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- To unsubscribe e-mail to: users+unsubscr...@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 IF problem
Hi, Am 10.10.2013 19:11, schrieb Hylton Conacher (ZR1HPC): Where am I making a mistake? Don´t use multiple nested IF-functions. Use the VLOOKUP-function! Get yourself Calc User Guide, Chapter 13: https://wiki.documentfoundation.org/images/5/53/CG4013-CalcAsASimpleDatabase.pdf and look for VLOOKUP. Cheers, Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- To unsubscribe e-mail to: users+unsubscr...@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
[libreoffice-users] LibreOffice Conference - Jetzt anmelden!
Hi, für alle, die an der diesjährigen LibreOffice-Konferenz teilnehmen wollen, leite ich die folgende Mitteilung über die Anmeldung weiter. Mehr Info zur LibreOffice Conference gibt es hier: http://conference.libreoffice.org Stefan. Am 30.08.2013 14:29, schrieb Florian Effenberger: Dear community, in less than four weeks, the LibreOffice Conference 2013 will take place in Milan, Italy. LibOCon is the global and annual event for the whole LibreOffice community and ecosystem, with creators, adopters and users meeting and gathering, exchanging ideas and thoughts. After the Call for Papers has been finished, we are currently working hard to prepare the schedule out of those many great proposals we have received. In order to help the organizers with their plannings, we today ask you to register if you want to take part in this year's conference. This helps us in estimating the amount of attendants and ensuring that enough capacities are available for everyone. We also need this information to send you last-minute updates via e-mail. Registering is easy - just send an e-mail to confere...@libreoffice.org and state: 1. your first and last name 2. your e-mail address 3. your organization/affiliation, if applicable 4. your IRC nickname, if you want Participation at the conference will cost 10 € per person, payable directly at the venue, which helps the local organizers in producing required material. Looking forward to seeing you in Milan! On behalf of the community Florian -- LibreOffice - Die Freiheit nehm' ich mir! -- To unsubscribe e-mail to: users+unsubscr...@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
[libreoffice-users] LibreOffice Conference - Registration is now open
Hi, for all people interested in attending this year's LibreOffice Conference I forward the following announcement about registration. For more information about LibreOffice Conference visit: http://conference.libreoffice.org Stefan. Am 30.08.2013 14:29, schrieb Florian Effenberger: Dear community, in less than four weeks, the LibreOffice Conference 2013 will take place in Milan, Italy. LibOCon is the global and annual event for the whole LibreOffice community and ecosystem, with creators, adopters and users meeting and gathering, exchanging ideas and thoughts. After the Call for Papers has been finished, we are currently working hard to prepare the schedule out of those many great proposals we have received. In order to help the organizers with their plannings, we today ask you to register if you want to take part in this year's conference. This helps us in estimating the amount of attendants and ensuring that enough capacities are available for everyone. We also need this information to send you last-minute updates via e-mail. Registering is easy - just send an e-mail to confere...@libreoffice.org and state: 1. your first and last name 2. your e-mail address 3. your organization/affiliation, if applicable 4. your IRC nickname, if you want Participation at the conference will cost 10 € per person, payable directly at the venue, which helps the local organizers in producing required material. Looking forward to seeing you in Milan! On behalf of the community Florian -- LibreOffice - Die Freiheit nehm' ich mir! -- To unsubscribe e-mail to: users+unsubscr...@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
[libreoffice-users] Ooops! (was: LibreOffice Conference - Jetzt anmelden!)
Oops, the german message was meant to appear somewhere else. Sorry. Am 30.08.2013 19:53, schrieb Stefan Weigel: Hi, für alle, die an der diesjährigen LibreOffice-Konferenz teilnehmen wollen, leite ich die folgende Mitteilung über die Anmeldung weiter. Mehr Info zur LibreOffice Conference gibt es hier: http://conference.libreoffice.org -- LibreOffice - Die Freiheit nehm' ich mir! -- To unsubscribe e-mail to: users+unsubscr...@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: A Tale of Two Office Suites
Am 11.12.2012 06:42, schrieb NoOp: Neither LO or AOO default to turning a (c) into a © - (C) does. My LibreOffice does this by default. LibreOffice 3.5.4.2 Build-ID: 350m1(Build:2) delivered with Ubuntu 12.04 Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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] Converting html into text
Hi Gary Am 28.11.2012 21:18, schrieb Gary Montalbine: I am trying to copy this website to text. http://knottsislandonline.com/kiscrapbook/cemeteriesmelinda3.html When I copy and paste into libreoffice the data in the columns is in rectangular boxes that I can not do anything with. How can I put this in text format? Thanks, Gary Try pasting by Paste Special... or press CTRL+SHIFT+V Cheers, Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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] [3.5.4.2/Win/Calc] Wrong sort order
Hi, Am 20.09.2012 16:40, schrieb Gilles: How come lait (milk) remains at the top instead of being moved after jus d'orange (OJ)? The first row is considered the heading of your list. You can uncheck this in the Options dialog. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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: No QuickStarter? (Linux)
Hi, Am 21.05.2012 11:58, schrieb Steve Edmonds: My LO 3.4.6 starts from a file click in 3 seconds so is fast enough without the quick starter. I find LO very fast these days. Yes, but... ;-) Using QuickStarter not necessarily is a question of how long does it take to start up the application. From the users point of view, QuickStarter also is an alternative (and by some users preferred) way of accessing LibrOffice in the GUI, with nice shortcuts for opening documents or creating new documents from templates. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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: No QuickStarter? (Linux)
Hi, Am 21.05.2012 14:00, schrieb James Knott: From the users point of view, QuickStarter also is an alternative (and by some users preferred) way of accessing LibrOffice in the GUI, with nice shortcuts for opening documents or creating new documents from templates. There's no reason why someone couldn't add it to the bar if so desired. How would I add a menu like this http://ipir.at/menu to the panel, without activating QuickStarter? Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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: No QuickStarter? (Linux)
Am 21.05.2012 14:37, schrieb Andreas Säger: How would I add a menu like this http://ipir.at/menu to the panel, without activating QuickStarter? swriter scalc simpress sdraw sbase smath soffice .uno:NewDoc soffice .uno:Open Ok yes. However, clicking the checkbox, available in my Ubuntu build of LibreOffice is much easier and faster. ;-) All that I am saying is: For some users the option QuickStarter is a matter of convenience and does not relate to the question, how fast the application starts up. So, eliminating QuickStarter should have a good reason, which has not been mentioned in this thread, so far, has it? Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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: No QuickStarter? (Linux)
Am 21.05.2012 14:40, schrieb James Knott: How would I add a menu like this http://ipir.at/menu to the panel, without activating QuickStarter? Stefan About all you could do is place the LO Suite icon there, and then choose what you want to do. Well, no. The LO suite icon will show me the StartCenter, but only if LO is not running already. Otherwise it´s not so easy to navigate for the Open From Template dialog, for example. :-) Sure, one can work around the missing QuickStarter, and I am immediately willing to accept it, if there is at least one good reason. But, I am not willing to accept arrogant statements like: The devs did you a great favor removed it. without any substance. ;-) Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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: Top posting
Hi, Am 25.02.2012 12:30, schrieb Caesar: On Fri, 24 Feb 2012 21:24:58 -0500, Andrew Douglas Pitonyak and...@pitonyak.org wrote What I meant was it feels mean to say that someone values a person's contributions so little that they have an automatic deletion filter on all of their contributions. If a poster insists that he be able to post in a manner that I find confusing and offensive, then I'm not interested in reading anything he is writting. I find it very effective in making this mailing list readable. True. However it´s not a solution for the main problem. The main problem is, that people who do not follow the suggested posting rules, destroy the value of the archive of this mailing list, which is intended to be a growing knowlegde base. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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: Top posting
Hi, Am 23.02.2012 19:55, schrieb Werner F. Bruhin: Lists like this are a great archive and should be promoted as such, but I seriously think they loose a lot of interest with all this top posting which makes it difficult to find if the problem is the same as the one, one tries to find a solution for. For this one has to read the question first before considering if the answer fits, which all this top posting one often has has to search for the question, instead of seeing it at the top. +1 Thank You Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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] Top posting
Again this topic? Well. Am 22.02.2012 20:19, schrieb Tom Davies: Is our main aim here to change the way people post or is it to help people move to LibreOffice? Helping people must not become a pain in the neck for the voluntary supporters. That´s why the posting quidelines should be respected. :-) There are already volunteers, who quit supporting, also because they became tired from folks frequently disregarding the ground rules. Sad. :-( Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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] Batch conversion of PPT/x and DOC/x documents ?
Hi, Am 22.02.2012 21:13, schrieb Fabian Rodriguez: I can't seem to find how to batch convert PPT (or pptx) and DOC (or docx) documents by command line. unoconv is a command line tool to convert any document format that LibreOffice can import to any document format that LibreOffice can export. https://github.com/dagwieers/unoconv :-) Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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] LO 3.5 corrupts DOCX completely
Hi, Am 14.02.2012 18:20, schrieb Philip Gillißen: I just downloaded and tested LibreOffice 3.5 on Windows 64 Bit and my test result is depressing: LibreOffice 3.5 corrupts my DOCX files completely, so that Microsoft Word 2010 cannot open it anymore! Looking at https://bugs.freedesktop.org/show_bug.cgi?id=46060 and the comments, one explanation could be: You saved the document as ODT but named it DOCX. Are you sure, you didn´t do that? Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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] database or spreadsheet
Hi, Am 08.02.2012 13:18, schrieb Chris Morgan: We all have to accept that spreadsheets will always be 'abused' when a database may be more appropriate, until someone invents a whole new database-spreadsheet hybrid. True. However, Calc (and other spreadsheet applications) offer a bunch of very usefull tools for working with data, that are held in a spreadsheet. From my observation, approx. 80% of all use cases of spreadsheets is having data in lists. In order to benefit from the usefull tools, Calc users need to understand database-like structures. For example, in order to benefit from DataPilot you must not separate your data on several sheets, just because they belong to a different time period. ;-) It´s not the users to blame for not knowing about these facts. Blame it on authors, trainers and teachers... and on people who are not willing to beleive, that productively using an office suite needs some education on it. Stefan :-) -- LibreOffice - Die Freiheit nehm' ich mir! -- 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] database or spreadsheet
Hi Drew, Am 08.02.2012 00:32, schrieb drew: The user asked how to rename sheets in Calc - end of story. But the beginning of the story is, that the user, before asking this question, first described an unfortunate way of holding data, which is the reason why he needs to rename a big number of sheets. Sometimes you serve better if you do not *only* answer the question. If you don't want to answer that question, then don't answer - but don't open the door and show him two young men in white shirts offering to save his soul.. or - answer his, perfectly valid, question first and then offer the sermon, but what he got was a sermon and no answer to his question. That´s not true. There were several suggestions how to rename the sheets. *You* even translated an Excel macro for him. So how can you say, no answer was given? Stefan :-) -- LibreOffice - Die Freiheit nehm' ich mir! -- 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] [3.4.4/Win] Printing spreadsheet as landscape?
Hi, Am 05.02.2012 11:30, schrieb Gilles: Using LibreOffice Calc 3.4.4, I created a small spreadsheet that should print as a single page in Lanscape mode, but Calc insists on printing as two pages. Here's what I tried: 1. File Printer Settings chose printer Properties : Orientation=Landscape OK You don´t want to change the printer settings. You need to change the page format: Choose Landscape in Format|Page... Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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: Renaming Tabs in a spreadsheet in bulk.
Hi, Am 03.02.2012 16:50, schrieb Andreas Säger: Am 03.02.2012 16:05, Gordon Burgess-Parker wrote: I have a spreadsheet that is used for monthly and annual collection of data, with monthly tabs, Jan 2011, Feb 2011 etc. Is there a way to rename 2011 to 2012 in bulk, or do I have to do each one manually? Splitting up equally structured data across many sheets is *always* a huge mistake. Don't do that. Yes, can´t confirm this strong enough! Have a look into Calc Guide Chapter 8 (http://www.libreoffice.org/get-help/documentation/#cg), especially read the third rule on page 24. Cheers, Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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] Renaming Tabs in a spreadsheet in bulk.
Hi Gordon, Am 03.02.2012 17:06, schrieb Gordon Burgess-Parker: On 03/02/2012 15:50, Tom Davies wrote: Hi :) Have you opened the ods as an archived-file / zip-file? Are the tab-labels in the contents.xml in there? Regards from Tom :) Did you try Toms hint? I tried adding this Macro: Sub Rename_Tabs() Dim x As Long, suffix As String Dim v as Variant suffix = 12 v = Split(Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec, ,) *For x = 1 To Worksheets.Count* If Not IsError(Application.Match(Left(Sheets(x).Name, 3), v, 0)) Then Sheets(x).Name = Left(Sheets(x).Name, 3) suffix End If Next End Sub But it fell over on the bolded portion. I'm not a macro person and this was copied from one in Excel that worked OK. Anyone tell me what I need to replace the bolded bit with? (a) Do you want to have this question answered? Or (b) do you want to be helped with your problem? If (a) then replace For x = 1 To Worksheets.Count by For x = 0 To thisComponent.Sheets.count-1 If (b) please recognize that your problem derives from an unfortunate data layout, just as Andreas and Jiri have been pointing out. However you could try to handle your situation by either replacing the relevant values inside the content.xml, just as Tom has been indicating. This can be done by the SearchReplace functionality of any simple text editor. Or, if you would rather have a BASIC macro doing the job, you will need to dive into the StarOffice object modell, which is very different to Excel, which is why it´s little help to present an Excel macro for this task. http://wiki.documentfoundation.org/Macros could be a starting point. Regards, Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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] what is the alternative of countifs function in libreoffice?
Hi, Am 25.01.2012 17:16, schrieb soumalya ray: say,in one column gender of the participants are written (male/female).in next column height of the participant is written.now i want to count how many females have height =1.55 metre. Use DataPilot. (Chosse: Data → DataPilot → Start). Your problem is exactly what it was invented for. Here is the LibreOffice manual: http://wiki.documentfoundation.org/images/5/52/0308CG3-DataPilot.pdf :-) Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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] Unsubscribing from this list
Hi, Am 22.01.2012 14:44, schrieb Jonathon Waterman: Though I hate to recommend a competitor's services, and may take a little flack for doing so. For those who do have a individual question and want an answer and nothing more, perhaps they should consider asking their question at http://user.services.openoffice.org/ Nothing wrong about your recommendation. In fact, it´s the recommendation from the LibreOffice website: http://www.libreoffice.org/get-help/ which also links to http://user.services.openoffice.org/en/forum/ ;-) Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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
[libreoffice-users] (was: UNSUBSCRIBE)
Hi, A proper official forum such as most modern projects use (Firefox, Fedora, Ubuntu, Mint and so on and on) would neatly avoid all sorts of recurring problems. Are you sure? :-D 100% sure. Mailing lists are perfect for collaboration in teams. They are totally inadequate for end user support. I did not intend to reinitiate the old discussion about having forums or not. I just wanted to express my doubts, that a forum would quoteavoid all sorts of recurring problems/quote. A forum would certainly not help against people, that manage to subscribe to a mailinglist, but won´t manage to unsubscribe, for some unexplainable reason. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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] UNSUBSCRIBE
Hi :-) Am 19.01.2012 10:58, schrieb Tom Davies: A proper official forum such as most modern projects use (Firefox, Fedora, Ubuntu, Mint and so on and on) would neatly avoid all sorts of recurring problems. Are you sure? :-D Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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] UNSUBSCRIBE
Am 19.01.2012 12:04, schrieb saro...@gmail.com: Please help me, how do I unsubscribe? This is flooding my inbox! Unsubscribing is as easy as it was to subscribe. If you do not know, what to do, please, please, please, do read the instructions, that you find at the bottom of every mail you get from this mailing list: For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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] UNSUBSCRIBE
Hi, Am 19.01.2012 12:13, schrieb Dan Lewis: It would have been nice to actually tell the person how to unsubscribe instead of all of the unnecessary commits. This is the SIXTH email reply that did not contain an answer! Some help these six replies were. Shame on the six of you. I'm disappointed in all of you. Hm? The very first reply already gave the answer. So please friends, calm down. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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] How to paste a function so Calc doesn't change addresses in it?
Hi, Am 26.12.2011 16:25, schrieb Csányi Pál: How can I copy/paste the function so so the addresses in the function remain the same as in the original cell? The answer is easy and it is here: http://help.libreoffice.org/Calc/Addresses_and_References,_Absolute_and_Relative Stefan :-) -- LibreOffice - Die Freiheit nehm' ich mir! -- 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] Small Capitals Shortcut
Hi, Am 04.12.2011 18:41, schrieb Tom Duk: unfortunately no, because I need it just for the author's last name and not for the whole citation. This sounds like you are thinking of Paragraph Styles. For your case is, what Character Styles are made for. ;-) Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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 - no grid lines in spreadsheet
Hi, Am 04.11.2011 15:08, schrieb Kamil Jońca: I have strange problem - cannot see grid lines in most of my spreadsheets. Cannot turn on them via button Toggle Grid lines for current sheet nor via Tools-Options - LibreOffice.Calc - View There is a new feature in Calc (for better MS Excel compatibility): Grid lines are visually behind the cells. So, If you have a coloured background in your cells, the grid lines are hidden behind them. You can either set your cell background to No Fill or you can use cell borders. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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] flip columns in calc
Hi Jason, Am 03.11.2011 05:12, schrieb Jason Paul Joines: Is there any way to reverse the order of columns in a Calc spreadsheet? For example, if I have columns A through Z, I want to re-order them so that the contents of Z are in A, Y in B, X in C, ..., A in Z, B in Y, C in X. (1) Insert a row at the top. (2) Fill the row with the values 1, 2, 3, ... (This is very easy, if you use the AutoFill functionality. (3) Sort your columns in descending order of row 1. (4) Delete the column insertet in step (1) In reality I need to leave the first 9 columns in order and have many more than 26 columns. I don´t get that. A sheet has 1024 columns. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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
Hi, Am 31.10.2011 08:26, schrieb Stephan Zietsman: Rich Shepard wrote: I have a column where the cells display the sum of two other columns. I want to change the contents from formula to value but cannot find the relevant information in the help pages. Please point me to instructions on how to do this. Select the relevant cell and click in the formula bar. Press F9 (the default short-cut for recalculate) followed by ENTER. This should replace the formula with the result. This will work for a single cell, but will take you very long for a whole column. ;-) Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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
Am 31.10.2011 10:08, schrieb Stephan Zietsman: I just wanted to mention an alternative. which I find generally interesting, because I didn´t think of the way you mentioned, at all. And for a single cell your alternative is faster, I think. Stefan :-) -- LibreOffice - Die Freiheit nehm' ich mir! -- 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
Hi, Am 29.10.2011 02:05, schrieb Uwe Koch Kronberg: Stefan means to select the area, copy it, go to another cell, choose edit from the menu, click on paste special and inside the menu box it opens unclick paste all, then unclick all the options below (text, date and hour, formulae, comments, formats, objects) except for numbers, which is the only option that should stay checked. Hm. Not exactly. In order to convert a formula into its result value, I wouldn´t go to *another* cell but paste special right in the *same* cell -- that means overwriting the formula by its result value. ;-) Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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
Hi Rich, Am 29.10.2011 01:50, schrieb Rich Shepard: I'm not following you. Are you writing that I can highlight two adjacent cells and have their sum pasted in the same row in a third column? No. Follow this: (1) Select the cell that contains the formula (2) Choose Edit | Copy (3) Choose Edit | Paste Special (4) Unselect Paste all and unselect Formulas and select Numbers (5) Hit OK Done. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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] cannot open rtf files
Hi, Am 28.10.2011 15:23, schrieb Uwe Koch Kronberg: http://www.2shared.com/document/lh27aD4p/rptLiqExt.html I have no problem opening this file with Ubuntu 11.04 and LibreOffice 3.3.4 (vanilla). Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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
Hi, Am 29.10.2011 01:14, schrieb Rich Shepard: I have a column where the cells display the sum of two other columns. I want to change the contents from formula to value but cannot find the relevant information in the help pages. Please point me to instructions on how to do this. The trick is to copy and then paste special (Edit menu). In the dialog check only numbers. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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
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 -- LibreOffice - Die Freiheit nehm' ich mir! -- 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] bug removal and software update policy
Dear Mrs./Mr. Noname E-Letter, Am 24.10.2011 23:01, schrieb e-letter: After reading a recent bug with calc formulas not saved in the local language and the claim that this bug could be fixed in a number of weeks, a few questions to ask. What happens next? Do programmers make change to the software code for LO34, so that users have to download the latest version of LO34 to see the error solved? This has nothing to do with the TDFs policy. This was an Ubuntu bug and a fix has already been committed to the distribution. See: https://bugs.launchpad.net/bugs/873702 Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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] False Positive Virus detection my MSE for 3.4.3 installer.
Hi, Am 25.10.2011 05:00, schrieb windyweather: Not sure if you will notify Microsoft so they can fix definitions or change LibreOffice to avoid false positive. Not sure, who do you mean by you. Why not yourself? We are all just users here helping each other. ;-) Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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] problem with formulas
Hi, Am 24.10.2011 18:34, schrieb macq22: Hello, i've got a problem. I have polish version of libreoffice but all formulas in calc are in english. I mean if i want to calculate average i have to use AVERAGE() instead of polish ŚREDNIA(). It wouldn't be problem but there are polish function names in help. What can i do to make polish formulas working? Please help me. (1) When posting a question please start with a virgin email. Do not reply to another thread and just overwrite the subject. Thanks. (2) Please specify your Operating System and exact version of LibreOffice. In case you are using LibreOffice, that came with Ubuntu 11.10, your problem is an already known bug: https://bugs.launchpad.net/bugs/873702 Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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] I want to add formulas and functions to calc
Hi, Am 23.10.2011 04:35, schrieb Alberto Sanchez: Is there a way that the community can benefit from this? so my question is, how can I add that function so that many others in my position can benefit from them? Make an Extension and put into the Extensions Repository. http://www.libreoffice.org/features/extensions/ http://extensions-test.libreoffice.org/ If you do not know how to create an extension and if you do not want to learn it (which isn´t difficult), you could post the Code and a description of your new function and hope that some other old man will pick it up and create and publish it as an extension. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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] Excel file in LibreOffice Calc
Hi, Am 21.09.2011 18:25, schrieb Luciano R. Moreira - Desenvolvimento: I'm having problem saving the report generated by my system developed in Delphi 7 to Excel (XLS) using the component with component QuickReport 5.2 Gnostice eDocEngine company. Are you sure, you are creating a real Excel-File, or just a CSV-File named .xls ? At least this could be an explanation for the symptoms you are describing. - The date fields and values ??are being displayed in the program Open Office / BR Office / LibreOffice with the character (apostrophe) and cause error in the calculation of the value field because they are as text. Take the example of incorrect visualization in OpenOffice / BROffice / LibreOffice: '$ 100.00 Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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] Libre Writer: 'view - data source' (F4) not available
Hi OpenE, Am 02.06.2011 10:19, schrieb OpenE: I run LibreOffice 3.3.2 on Ubuntu 11.04. Which means database functionality is not present by default. In all the support documentation that I have consulted this method should still be an option, but in my View drop-down there is no 'Data source' option and the F4 shortcut does not launch the data source explorer either. I have reinstalled LibreOffice but the problem still remains. I must be missing something. Did you install package libreoffice-base ? Regards, Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- Unsubscribe instructions: E-mail to users+h...@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/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Libre Writer: 'view - data source' (F4) not available
Hi, Am 02.06.2011 11:12, schrieb OpenE: Hi Stefan, Thanks for your response. LibreOffice was installed by default when I upgraded to Ubuntu 11.04. I have checked and libreoffice-base is installed. Strange. Are you sure? My observation is: (1) Install Ubuntu 11.04 on a clean PC (2) Base is not installed, in LibO F4 doesn´t do anything. (3) Install libreoffice-base, restart LibO (4) F4 is working as expected. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- Unsubscribe instructions: E-mail to users+h...@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/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Old Hat Top or Bottom Posting!
Hi, Am 02.06.2011 14:19, schrieb Tanstaafl: On 2011-06-02 8:14 AM, Ken Springer wrote: I'd never noticed that netiquette link at the bottom of the page. Maybe that's not the best way for TDF to get info out. After all, is the reader of new messages going to read the sig files for each and every message to see if there is new information? It might be a major assumption to think a lot of readers even read the sig file in the first place. That is the problem - most people/users simply don't read... My only question is - whose fault is that? Too much TV radiation as a kid? :-D Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- Unsubscribe instructions: E-mail to users+h...@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/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] OTRe: Sun Weblog Publisher broken
Hi, Am 30.05.2011 23:42, schrieb Sigrid Carrera: In your office, you can do as you want. But on this list, we have a set of rules, that everyone should take into account. And one of this rules, is to not top post, but reply *below* the paragraph your referring to and deleting the stuff, you're not replying. Not doing this shows only your ignorance. +1 Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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
Re: [libreoffice-users] How to /successfully/ unsub? A FAQ?
Hi, Am 28.05.2011 23:18, schrieb lenphil...@suddenlink.net: ... the email method is NOT working for me? When I send unsub messages to the listserv (as detailed in all the message footers, etc.), they either bounce outright, state that I'm not subscribed or say that I've been unsubscribed. [...] Thanks a million. -- Len Philpot (sent from webmail) l...@philpot.org Obviously you are using more than one mail address (e.g. l...@philpot.org, lenphil...@suddenlink.net). In order to unsubscribe you must send an email from the same mail address you were using when you subscribed. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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
[libreoffice-users] Re: [libreoffice-users] Calc, InString einer Zelle prüfen
Hallo, Am 11.05.2011 11:16, schrieb Regina Henschel: Ich suche eine Formel, die in der Spalte Ergebnis z.B. anzeigt: wenn Stelle 4 der Bankleitzahl = 4, dann Ergebnis = Commerzbank wenn Stelle 4 der Bankleitzahl = 7, dann Ergebnis = Deutsche Bank wenn Stelle 4 der Bankleitzahl = 5, dann Ergebnis = Sparkasse Du benötigst die Funktion TEIL um an die vierte (bzw. fünfte wenn Leerzeichen im Original enthalten sind) Stelle zu gelangen und die Funktion WAHL um der Ziffer einen Text zuzuordnen. Beispielsweise =WAHL(TEIL(A1;5;1)Commerzbank;Sparkasse;;Deutsche Bank) Je nach Umfang der Liste der Banken und je nach persönlichem Bedürfnis nach Übersichtlichkeit in den Formeln könnte man auch darüber nachdenken, die Liste der Banken in einem extra dafür gewidmeten Zellbereich zu führen und dann mit der Funktion INDEX oder der Funktion SVERWEIS den Namen der Bank heraus zu lesen. Gruß Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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
[libreoffice-users] Sorry, wrong mailing list (was: [libreoffice-users] Re: [libreoffice-users] Calc, InString einer Zelle prüfen)
Sorry, somehow this thread in German, lost its way and happened to hit the english list... I only realized that after having answered. Stefan Am 11.05.2011 12:19, schrieb Stefan Weigel: Hallo, Am 11.05.2011 11:16, schrieb Regina Henschel: Ich suche eine Formel, die in der Spalte Ergebnis z.B. anzeigt: wenn Stelle 4 der Bankleitzahl = 4, dann Ergebnis = Commerzbank wenn Stelle 4 der Bankleitzahl = 7, dann Ergebnis = Deutsche Bank wenn Stelle 4 der Bankleitzahl = 5, dann Ergebnis = Sparkasse Du benötigst die Funktion TEIL um an die vierte (bzw. fünfte wenn Leerzeichen im Original enthalten sind) Stelle zu gelangen und die Funktion WAHL um der Ziffer einen Text zuzuordnen. Beispielsweise =WAHL(TEIL(A1;5;1)Commerzbank;Sparkasse;;Deutsche Bank) Je nach Umfang der Liste der Banken und je nach persönlichem Bedürfnis nach Übersichtlichkeit in den Formeln könnte man auch darüber nachdenken, die Liste der Banken in einem extra dafür gewidmeten Zellbereich zu führen und dann mit der Funktion INDEX oder der Funktion SVERWEIS den Namen der Bank heraus zu lesen. Gruß Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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
Re: [libreoffice-users] I am downloading LibreOffice to try it out.
Hi, Am 07.04.2011 20:32, schrieb Diane Marie: LibO_3.3.2_Win_x86_helppack_en-US.exe 8.5 MB (en-US - English (US)) Something is goofy. Well, that´s the help pack only. It´s isn´t of any help unless you download and install the main package first. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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
Re: [libreoffice-users] Zeros when linking cells between sheets
Hi John, Am 21.03.2011 12:07, schrieb John Kennedy: If Phone.a3 is empty then All.a3 has a 0 (zero). I would prefer, for readability, for the cell to be blank like the referenced cell. Is there a way to do this? Tools | Options... | LibreOffice Calc | View | Zero values Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] What happened to the delete row/column icons?
Hi Bill, Am 21.03.2011 15:13, schrieb bill purvis: OpenOffice Calc had toolbar items to delete rows and columns but I can't find these in LibreOffice. I found the insert rows and columns Ok and have added them to the toolbar, but miss those for deleting. When look at Tools | Customize... | Toolbars | Add... | Edit I can see an icon for Delete Columns as well as an icon for Delete Rows. I am using LibreOffice 3.3.1 on Ubuntu Linux 10.10. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Re: Has it all except ... #2
Hi, Am 16.03.2011 04:34, schrieb NoOp: On 03/15/2011 12:52 AM, Stefan Weigel wrote: Evidence: http://office.microsoft.com/en-us/products/?CTT=97 You're missing the boat... and flogging the wrong horse. ...whatever that means. Here, download it and try it yourself: http://office.microsoft.com/en-us/try/?CTT=3 Office Professional 2010 Best-in-class tools to grow your business What's included: Word, Excel, PowerPoint, Outlook, OneNote, Access, and Publisher Let us know if Project is included in that. We all know, what´s included in such bundles. Nobody said, MS Project was included. I've already pointed out that Project is a separate package costs $$ above and beyond MSO. Yes. MS Project is sold seperately. But it belongs to MS Office. Now, if you find OpenProj lacking (http://openproj.org/), contribute. Otherwise just buy (or look for) something else. I have never said, that I find something lacking. LO is already bloated enough without adding yet another Microsoft project (pun intended). Should LO also include Visio? How about Adobe Acrobat, or Autocad? Wait... lets also include Google's Picasa, Chrome, and Google Docs. How about adding Skype, and QGIS? I have never suggested to add anything to LibreOffice. All I am saying is: Do not compare LibreOffice to MS Office, because it creates wrong expectations. We have experienced that for years. I don´t need to repeat myself: http://www.mail-archive.com/users@libreoffice.org/msg03605.html Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Re: Has it all except ... #2
Hi, Am 16.03.2011 04:07, schrieb NoOp: That´s true. However, Microsoft Project *is* a part of the Microsoft Office Family. Microsoft Office is more than Word, Excel and Powerpoint. See: http://en.wikipedia.org/wiki/Microsoft_Office#Other_desktop_applications_.28Windows_version_only.29 Perhaps you missed reading this in your link: quote Microsoft Project — project management software to keep track of events and to create network charts and Gantt charts (not bundled in any Office suite) /quote That´s exactly, what I am saying. MS Project is not bundled in any MS Office suite, but it *is* part of MS Office. MS Office is much more, than the applications you can buy in one bundle. And that´s the point: Do not compare LibreOffice to MS Office, because it´s not comparable. If you compare (at all) then compare to Word, Excel and Powerpoint. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Re: Has it all except ... #2
Hi, Am 15.03.2011 02:17, schrieb NoOp: http://office.microsoft.com/en-us/professional/ It does *not* include project planning. So let's put that bit to bed: http://www.microsoft.com/project/en/us/try-buy.aspx That´s true. However, Microsoft Project *is* a part of the Microsoft Office Family. Microsoft Office is more than Word, Excel and Powerpoint. See: http://en.wikipedia.org/wiki/Microsoft_Office#Other_desktop_applications_.28Windows_version_only.29 Some people, e.g. some journalists, should stop creating the impression that OpenOffice.org, LibreOffice and others are a full replacement for Microsoft Office. LibreOffice is great software and there are many good reasons to choose it. LibreOffice does not need to always compare itself to Microsoft Office. But, if someone compares LibreOffice to Microsoft products, then it should be compared to Word, Excel and Powerpoint and *not* to Microsoft Office. Stefan LibreOffice - Die Freiheit nehm' ich mir! -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Re: Has it all except ... #2
Hi Larry, Am 15.03.2011 08:13, schrieb Larry Gusaas: Microsoft Project has never been included any version of MS Office. Its branding as part of the Office family is irrelevant if it is not included in any version of MS Office. See: http://en.wikipedia.org/wiki/Microsoft_Project Yes, MS Project is not part of any MS Office suite. But still, sorry you are wrong: MS Project *is* part of MS Office. Microsoft itself defines the following applications as parts of Microsoft Office: * Access * Excel * InfoPath * Lync * OneNote * Outlook * PowerPoint * Project * Publisher * SharePoint Workspace * Visio * Word Evidence: http://office.microsoft.com/en-us/products/?CTT=97 Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Re: Has it all except ... #2
Hi Gordon, Am 15.03.2011 13:25, schrieb Gordon Burgess-Parker: So I think that it is perfectly sound to compare LO with MO - certainly for the average user. Well, our bad experience over many years is, that comparing OpenOffice.org to Microsoft Office and claiming that OOo could replace MSO, produced many, many wrong expectations and disappointment. People were expecting that OOo is just the same as MSO, but for free. People were complaining about functions that were not exactly the same as in Word, Excel or Powerpoint. People were complaining that they could not use their MDB-Applications. People were missing a groupware client and yes, people were missing a tool for Gantt charts and so on. So, for LibreOffice we should have learned from OpenOffice.org: It´s great software. It contains a word processor, a spreadsheet application and a presentation application. It can handle and create documents from Word, Excel and Powerpoint. But it´s not a replacement for MS Office and it does not claim to be. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Problems ACCESS --- LibreOffice
Am 05.03.2011 13:32, schrieb Isabel Marc: I have MICROSOFT Office XP Pro and use a lot of databases (self)made with ACCESS. Because I want to use some of these programs/files on another computer I have installed Open- and LibreOffice. - the navigationbars Query's and Forms and Reports are empty I cannot find a way to have the forms/reports in this. The original Access-file also is setup to open this with a particular form so this also will not function. Do I have missed something? LibreOffice or OpenOffice.org are not a clone of MS Office. With LibreOffice or OpenOffice.org you can Access Data, that´s stored in a MS Access Database. With LibreOffice or OpenOffice.org you cannot use Forms, Reports, Macros and so on, that were created with MS Access. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] LO Calc copy/paste problem
Hi Cliff, Am 05.03.2011 23:03, schrieb Cliff Scott: Now I have to figure out how to write a macro to select the correct Paste Special option and paste in one key stroke operation. Pulling down the options from the Paste toolbar object makes it a two click process which isn't bad, but the keystroke macro would be ideal. Do you really think a macro is worthwhile for that? Without a macro, it´s only three keystrokes maximum anyway: (1) CTRL+SHIFT+V (2) type the first characater of the desired option, if necessary (3) ENTER done. ;-) Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Bug - Calc, merged cells adjustment
Hi, Am 04.03.2011 23:56, schrieb Luiz Oliveira: For this we have the wiki[1]. No. The wiki ist not meant for uploading sample files for individual user problems. Stefan [1]wiki.documentfoundation.org On 04/03/11 21:23, Klaus Friis Østergaard wrote: I have attached one small file The list doesn't accept attachments... -- LibreOffice - Die Freiheit nehm' ich mir! -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Re: Mail List Etiquette
Hi, Am 18.02.2011 09:33, schrieb Marc Paré: So we are trying to make ourselves as inaccessible as possible to the vast majority of people that might need this list. I don't believe this is the issue. It is more of a mentorship and guiding suggestion for people joining and making use of the list. I don't believe for a second that we would jump on newcomers and demand they follow a list-writing protocol. However, if a member decides to make regular use of the list(s), then, yes, there should be a gentle reminder that we have an accepted use of bottom posting at LibreOffice. Eaxctly. Thanks. :-) It would be a great step forward, if the poeple, who regularly post on the mailing lists, would recognize the basic rules. This particular list here, is for user support and is somewhat special, of course. But please also consider the other lists, where community work is discussed and coordinated. At least these lists should helpfully be kept in a certain order. ;-) Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Mail List Etiquette
Hi Simon, Am 18.02.2011 00:55, schrieb Simon Cropper: Information should be available somewhere, associated with the libreoffice-users list, on what sort of questions the list addresses, subject line format, preferences with top-posting versus bottom-posting, snipping of text, etcetera. Maybe the list moderator(s) could draft something up ... This already exists in German: http://www.eschkitai.de/libreoffice/netikette.html Maybe someone can/wants to translate this. I don´t know if Google does a good job in translating: http://translate.google.de/translate?u=http%3A%2F%2Fwww.eschkitai.de%2Flibreoffice%2Fnetikette.htmlsl=detl=enhl=ie=UTF-8 Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] top- or bottom- quoting
Hi Luuk, Am 15.02.2011 16:13, schrieb Luuk: When replying to a message on this list, What is the best method when talking abot quoting? Bottom quoting is what i like because it preserves the reading order of the story. Please refer to this: http://www.netmeister.org/news/learn2quote.html Thank you! :-) Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Re: where is the guidelines on what to put on a CD/DVD distro of LibreOffice?
Hi plino, Am 09.02.2011 10:20, schrieb plino: (I'm curious: why is the Slimcase Inlay so low res? Isn't the original an SVG like for the labels? Can someone post the original?) Not the original, but perhaps of help: http://www.ooodev.org/images/downloads/LibO/libo_dvd_inlet_feb2011.pdf Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] How to copy multiple diverse cells in Calc?
Hi Luuk, Am 08.02.2011 09:47, schrieb Luuk: On 08-02-11 05:26, klonuo wrote: An example: I selected multiple diverse cells with Ctrl+Click, then pressed Ctrl+C, expecting that selected cells content would be placed in clipboard. Unfortunately clipboard contains value from only one cell - the top-most it seems. Why is this, and is there a way that I can copy data this way? I sure hope that you are doing soemething wrong, because if this does not work, than LO is. So, i tried on my Windows7 64b, and here it works No folks. ;-) :-D Yes, it does work. And no, it does not work. ;-) Try this: (1) Click on cell A1 and Ctrl+Click on cell B1. Type Ctrl+C. You will get a warning, that Calc won´t do it this way. (2) Click on cell A1 and Ctrl+Click on A3. Type Ctrl+C. Click on cell C1 and type Ctrl+V. Works fine. (3) Click on cell A1 and Ctrl+Click on A3. Type Ctrl+C. Open any simple text editor on your system and type Ctrl+V. You get the content of A1 only. (LibreOffice 3.3, Ubuntu 10.10) Stefan :-) -- LibreOffice - Die Freiheit nehm' ich mir! -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] How to copy multiple diverse cells in Calc?
Hi, Am 08.02.2011 15:06, schrieb Luuk: Ok, This function cannot be used with multiple selections hmmm, this would be a nice 'feature-request'. Developer´s comment on this topic: Copying multiple selections is not supported in Excel. And in Quattro Pro I do not see any sensible way to actually use this selection when copied to clipboard (which is the reason why Excel and Oo.o do not support it I guess) (http://de.openoffice.org/issues/show_bug.cgi?id=7357) Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] [BUG] Background colors remove cell lines
Hi Stevie, Am 08.02.2011 20:47, schrieb Stevie: i found a bug which wasnt in openoffice. When you fill cells with a background color the border lines of the cells will disappear. Not a bug. It´s a feature. Works like MS Excel now and increases compatibility with documents created by Excel. (I am not saying I like it, but it works as designed.) Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Re: [bug] wrong import of pdf file
Hi Glenn, Am 06.02.2011 14:04, schrieb Glenn: If LibrO is based on OOo why does LibrO have these problems? You will encounter the same problems with OOo. These problems are not related to LibreOffice nor to OOo. PDF Import is an extension from Oracle. You should direct your complaints to the author of the extension, which is Oracle. My complaint is not with all of the problems cited here. However, what about PDF compatibility? This is critical. PDF compatibility of OOo/LO is excellent. You can perfectly create PDF files. PDF file format by it´s definition is not meant to open it for reediting. IMO the PDF import function should have never been introduced to OOo/LO at all. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Re: [bug] wrong import of pdf file
Hi, Am 07.02.2011 01:01, schrieb Michel Gagnon: One option I find *very* interesting is the hybrid PDF format. I agree 100%. But the naming of the PDF import extension and the way it has been promoted by OOo marketing makes people beleive, that they can just open any PDF file for editing. This creates disappointment, which IMO is bad. Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
