[libreoffice-users] LibreOffice Conference - Jetzt anmelden!

2013-08-30 Thread 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 Stefan. Am 30.08.2013 14:29, schrieb Florian Effenberger: Dear

[libreoffice-users] LibreOffice Conference - Registration is now open

2013-08-30 Thread Stefan Weigel
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

[libreoffice-users] Ooops! (was: LibreOffice Conference - Jetzt anmelden!)

2013-08-30 Thread Stefan Weigel
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

Re: [libreoffice-users] [3.5.4.2/Win/Calc] Wrong sort order

2012-09-20 Thread Stefan Weigel
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

Re: [libreoffice-users] Converting html into text

2012-11-28 Thread Stefan Weigel
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

Re: [libreoffice-users] Re: A Tale of Two Office Suites

2012-12-11 Thread Stefan Weigel
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

Re: [libreoffice-users] Calc IF problem

2013-10-10 Thread Stefan Weigel
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

Re: [libreoffice-users] vlookup with cell reference for range

2013-11-03 Thread Stefan Weigel
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

Re: [libreoffice-users] Re: Engaging Users in the LibreOffice Project

2013-11-03 Thread Stefan Weigel
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?

Re: [libreoffice-users] CALC convert text to numbers

2013-11-11 Thread Stefan Weigel
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,

Re: [libreoffice-users] Re: Engaging users: initial results of the survey

2013-11-12 Thread Stefan Weigel
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

Re: [libreoffice-users] [Calc bug? ] Function RANK() ranks error?

2013-11-13 Thread Stefan Weigel
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

Re: [libreoffice-users] Calc paste funnies

2013-11-14 Thread Stefan Weigel
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

Re: [libreoffice-users] Re: CALC convert text to numbers

2013-11-14 Thread Stefan Weigel
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

Re: [libreoffice-users] Re: CALC convert text to numbers

2013-11-15 Thread Stefan Weigel
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

Re: [libreoffice-users] Re: CALC convert text to numbers

2013-11-15 Thread Stefan Weigel
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?

Re: [libreoffice-users] CALC convert text to numbers

2013-11-18 Thread Stefan Weigel
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.

Re: [libreoffice-users] Mail Merge from different tables in database?

2013-11-18 Thread Stefan Weigel
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

Re: [libreoffice-users] Excel file in LibreOffice Calc

2011-09-22 Thread Stefan Weigel
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

Re: [libreoffice-users] I want to add formulas and functions to calc

2011-10-23 Thread Stefan Weigel
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.

Re: [libreoffice-users] problem with formulas

2011-10-24 Thread Stefan Weigel
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

Re: [libreoffice-users] bug removal and software update policy

2011-10-25 Thread Stefan Weigel
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

Re: [libreoffice-users] False Positive Virus detection my MSE for 3.4.3 installer.

2011-10-25 Thread Stefan Weigel
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 -

Re: [libreoffice-users] cannot open rtf files

2011-10-28 Thread Stefan Weigel
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:

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

2011-10-28 Thread Stefan Weigel
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

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

2011-10-28 Thread Stefan Weigel
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 -

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

2011-10-29 Thread Stefan Weigel
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,

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

2011-10-29 Thread Stefan Weigel
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)

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

2011-10-31 Thread Stefan Weigel
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

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

2011-10-31 Thread Stefan Weigel
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

Re: [libreoffice-users] flip columns in calc

2011-11-03 Thread Stefan Weigel
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

Re: [libreoffice-users] Calc - no grid lines in spreadsheet

2011-11-04 Thread Stefan Weigel
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

Re: [libreoffice-users] Small Capitals Shortcut

2011-12-04 Thread Stefan Weigel
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

Re: [libreoffice-users] How to paste a function so Calc doesn't change addresses in it?

2011-12-26 Thread Stefan Weigel
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 :-) --

Re: [libreoffice-users] UNSUBSCRIBE

2012-01-19 Thread Stefan Weigel
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

Re: [libreoffice-users] UNSUBSCRIBE

2012-01-19 Thread Stefan Weigel
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

Re: [libreoffice-users] UNSUBSCRIBE

2012-01-19 Thread Stefan Weigel
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

[libreoffice-users] (was: UNSUBSCRIBE)

2012-01-20 Thread Stefan Weigel
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

Re: [libreoffice-users] Unsubscribing from this list

2012-01-22 Thread Stefan Weigel
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

Re: [libreoffice-users] what is the alternative of countifs function in libreoffice?

2012-01-25 Thread Stefan Weigel
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

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

2012-02-03 Thread Stefan Weigel
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

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

2012-02-03 Thread Stefan Weigel
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:

Re: [libreoffice-users] [3.4.4/Win] Printing spreadsheet as landscape?

2012-02-05 Thread Stefan Weigel
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 :

Re: [libreoffice-users] database or spreadsheet

2012-02-07 Thread Stefan Weigel
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

Re: [libreoffice-users] database or spreadsheet

2012-02-08 Thread Stefan Weigel
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

Re: [libreoffice-users] LO 3.5 corrupts DOCX completely

2012-02-14 Thread Stefan Weigel
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

Re: [libreoffice-users] Top posting

2012-02-22 Thread Stefan Weigel
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

Re: [libreoffice-users] Batch conversion of PPT/x and DOC/x documents ?

2012-02-22 Thread Stefan Weigel
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.

Re: [libreoffice-users] Re: Top posting

2012-02-23 Thread Stefan Weigel
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

Re: [libreoffice-users] Re: Top posting

2012-02-25 Thread Stefan Weigel
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

Re: [libreoffice-users] Re: No QuickStarter? (Linux)

2012-05-21 Thread Stefan Weigel
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

Re: [libreoffice-users] Re: No QuickStarter? (Linux)

2012-05-21 Thread Stefan Weigel
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

Re: [libreoffice-users] Re: No QuickStarter? (Linux)

2012-05-21 Thread Stefan Weigel
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

Re: [libreoffice-users] Re: No QuickStarter? (Linux)

2012-05-21 Thread Stefan Weigel
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

Re: [libreoffice-users] sum function in libreoffice calc doesn't seem to work

2010-11-04 Thread Stefan Weigel
Hi, Am 04.11.2010 17:54, schrieb Mark: Semicolon? No, it should be a colon. Well this depends on what you aim for. =SUM(A1:B10) sum up all from A1 to B10 =SUM(A1;B10) sum A1 and B10 Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- E-mail to users+h...@libreoffice.org for

Re: [libreoffice-users] which is better?

2011-01-17 Thread Stefan Weigel
Hi Tom, Am 17.01.2011 18:51, schrieb Tom Davies: Hi Edmund :) ... [lots of TOFU] you are answering to Edmund, not me, right? Could you please learn to quote (http://learn.to/quote/), avoid TOFU, and post your reply to the message you are answering to? Readers will be thankful. Stefan.

Re: [libreoffice-users] which is better?

2011-01-17 Thread Stefan Weigel
Hi Tom, Am 17.01.2011 22:33, schrieb Tom Davies: Thanks for the link. Yes, i think i was answering Edmund but i felt that your comment was also directly relevant. It is a bit difficult to tell because you have chopped off all the mails Well that´s just what you are supposed to do.

Re: [libreoffice-users] which is better?

2011-01-18 Thread Stefan Weigel
Hi, Am 17.01.2011 23:03, schrieb MR ZenWiz: On Mon, Jan 17, 2011 at 1:43 PM, Stefan Weigel stefan.wei...@bildungskreis.org wrote: Am 17.01.2011 22:33, schrieb Tom Davies: Thanks for the link. Yes, i think i was answering Edmund but i felt that your comment was also directly relevant

Re: [libreoffice-users] How to sort this dataset in Calc?

2011-01-18 Thread Stefan Weigel
Hi Arda, Am 18.01.2011 11:08, schrieb Arda Tunccekic: I have a dataset like this. There are empty rows. Is there a way to sort these values by choosing the first column? (1) Select the whole range from 90 on the top left to g on the bottom right, including the empty cells. (2) Use the

Re: [libreoffice-users] How to sort this dataset in Calc?

2011-01-18 Thread Stefan Weigel
Hi Arda, Am 18.01.2011 12:21, schrieb Arda Tunccekic: I wish it could also be done by clicking on Column A and clicking on the Sort Icon (simpler) No, not simpler, because when you click on column A, how should your Computer know, that you do not want to sort only the values in column A, but

Re: [libreoffice-users] How to sort this dataset in Calc?

2011-01-18 Thread Stefan Weigel
Hallo Sigrid, Am 18.01.2011 12:56, schrieb Sigrid Carrera: *It only sorts the column that is highlighted* the rest of the other columns stay as they are. I know what you mean. But since some time, in this case Calc shows a special Dialog asking the user, if he really means, what he is doing.

Re: [libreoffice-users] Re: How to sort this dataset in Calc?

2011-01-18 Thread Stefan Weigel
Hi, Am 18.01.2011 12:58, schrieb plino: Actually it does work. Just select columns A and B and press the sort icon Not exactly. In this case the sort criteria would be the values in column B. As said in my first posting: You need to move the active cell to a position in column A first. Stefan

Re: [libreoffice-users] which is better?

2011-01-19 Thread Stefan Weigel
Hi, Am 18.01.2011 21:06, schrieb MR ZenWiz: 2) Calling it TOFU, which is an acronym I've never seen before and, based on how tricky it was to find in Google, I suspect is not often used, is worse. :-) http://en.wikipedia.org/wiki/TOFU Don´t ask Google, better ask Wikipedia! :-D Stefan --

Re: [libreoffice-users] which is better?

2011-01-19 Thread Stefan Weigel
Hi, Am 19.01.2011 09:52, schrieb Sigrid Carrera: TOFU is a widely used acronym in german speaking areas. TOFU means Text oben, Fullquote unten translation: Text above full quote below TOFU is an acronym for Text Over, Fullquote Under and it´s not special for german speaking areas. At least

Re: [libreoffice-users] [bug] wrong import of pdf file

2011-02-05 Thread Stefan Weigel
Hi, thanks for your report. Am 05.02.2011 20:20, schrieb Raffaele Mancuso: I have tried to import a pdf file into LibreOffice draw, but the result is not correct. This is well-known. http://de.openoffice.org/issues/show_bug.cgi?id=94306 Stefan -- LibreOffice - Die Freiheit nehm' ich

Re: [libreoffice-users] Re: [bug] wrong import of pdf file

2011-02-05 Thread Stefan Weigel
Hi, Am 05.02.2011 21:55, schrieb NoOp: BTW, what´s your name, NoOp? On 02/05/2011 11:39 AM, Stefan Weigel wrote: http://de.openoffice.org/issues/show_bug.cgi?id=94306 Which version of PDF import are you using? I just updated to 1.0.4 (http://extensions.services.openoffice.org/en/project

Re: [libreoffice-users] Re: [bug] wrong import of pdf file

2011-02-06 Thread Stefan Weigel
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

Re: [libreoffice-users] Re: [bug] wrong import of pdf file

2011-02-06 Thread Stefan Weigel
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.

Re: [libreoffice-users] Re: [bug] wrong import of pdf file

2011-02-06 Thread Stefan Weigel
Hi, Am 07.02.2011 06:45, schrieb NoOp: Stephan, I wasn't defending the extension issues... I filed the issue of not being able to import EPS graphics back in 2008: http://www.openoffice.org/issues/show_bug.cgi?id=90739 [* Summary: PDF Import not importing eps graphic] I was merely

Re: [libreoffice-users] How to copy multiple diverse cells in Calc?

2011-02-08 Thread Stefan Weigel
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 -

Re: [libreoffice-users] How to copy multiple diverse cells in Calc?

2011-02-08 Thread Stefan Weigel
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

Re: [libreoffice-users] [BUG] Background colors remove cell lines

2011-02-08 Thread Stefan Weigel
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

Re: [libreoffice-users] Re: where is the guidelines on what to put on a CD/DVD distro of LibreOffice?

2011-02-09 Thread Stefan Weigel
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

Re: [libreoffice-users] top- or bottom- quoting

2011-02-15 Thread Stefan Weigel
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:

Re: [libreoffice-users] Mail List Etiquette

2011-02-17 Thread Stefan Weigel
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.

Re: [libreoffice-users] Re: Mail List Etiquette

2011-02-18 Thread Stefan Weigel
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

Re: [libreoffice-users] Bug - Calc, merged cells adjustment

2011-03-04 Thread Stefan Weigel
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

Re: [libreoffice-users] Problems ACCESS --- LibreOffice

2011-03-05 Thread Stefan Weigel
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

Re: [libreoffice-users] LO Calc copy/paste problem

2011-03-05 Thread Stefan Weigel
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

Re: [libreoffice-users] Re: Has it all except ... #2

2011-03-15 Thread Stefan Weigel
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.

Re: [libreoffice-users] Re: Has it all except ... #2

2011-03-15 Thread Stefan Weigel
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

Re: [libreoffice-users] Re: Has it all except ... #2

2011-03-15 Thread Stefan Weigel
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,

Re: [libreoffice-users] Re: Has it all except ... #2

2011-03-16 Thread Stefan Weigel
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

Re: [libreoffice-users] Re: Has it all except ... #2

2011-03-16 Thread Stefan Weigel
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

Re: [libreoffice-users] Zeros when linking cells between sheets

2011-03-21 Thread Stefan Weigel
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 --

Re: [libreoffice-users] What happened to the delete row/column icons?

2011-03-21 Thread Stefan Weigel
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... |

Re: [libreoffice-users] I am downloading LibreOffice to try it out.

2011-04-07 Thread Stefan Weigel
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

[libreoffice-users] Re: [libreoffice-users] Calc, InString einer Zelle prüfen

2011-05-11 Thread 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

[libreoffice-users] Sorry, wrong mailing list (was: [libreoffice-users] Re: [libreoffice-users] Calc, InString einer Zelle prüfen)

2011-05-11 Thread Stefan Weigel
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

Re: [libreoffice-users] How to /successfully/ unsub? A FAQ?

2011-05-29 Thread Stefan Weigel
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.

Re: [libreoffice-users] OTRe: Sun Weblog Publisher broken

2011-05-30 Thread Stefan Weigel
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,

Re: [libreoffice-users] Libre Writer: 'view - data source' (F4) not available

2011-06-02 Thread Stefan Weigel
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

Re: [libreoffice-users] Re: Libre Writer: 'view - data source' (F4) not available

2011-06-02 Thread Stefan Weigel
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

Re: [libreoffice-users] Re: Old Hat Top or Bottom Posting!

2011-06-02 Thread Stefan Weigel
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

Re: [libreoffice-users] Calc function to return the daynumber weeknumber of the year

2014-07-19 Thread Stefan Weigel
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:

Re: [libreoffice-users] Nitpicking on a name

2014-07-25 Thread Stefan Weigel
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

Re: [libreoffice-users] Fill down with a twist.

2014-09-19 Thread Stefan Weigel
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

Re: [libreoffice-users] LibreOffice forks

2014-10-15 Thread Stefan Weigel
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. ;-)

Re: [libreoffice-users] LibreOffice forks

2014-10-15 Thread Stefan Weigel
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

Re: [libreoffice-users] [Calc] The LOOKUP() function (Calc vs. Excel)

2014-12-01 Thread Stefan Weigel
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,

  1   2   >