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, y
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
Ex
ing 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
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.e
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
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*
improvem
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
> hap
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.libreoffic
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
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?
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 i
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-lis
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, everyth
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, everyth
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 t
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. ;-)
St
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
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
abbrevia
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.
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 M
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 t
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.libreo
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
> =
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
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, u
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
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 o
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,
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
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 func
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 V
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
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 co
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 com
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 ins
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. Ho
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!
--
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 ic
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,
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 reas
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 applicatio
Hi,
Am 25.02.2012 12:30, schrieb Caesar:
> On Fri, 24 Feb 2012 21:24:58 -0500, Andrew Douglas Pitonyak
> 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".
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 s
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
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 respect
Hi,
Am 15.02.2012 09:28, schrieb Dag Wieers:
> There's also a tool I wrote that should work on Windows, Linux and
> MacOSX called 'unoconv'
I have deployed unoconv on a Linux file server in a cron script in
order to convert some XLS file to PDF every 15 Minutes
automatically. It runs into an err
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.or
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
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
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 :
> Orient
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 thi
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 d
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
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://
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
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 di
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
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 u
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
:-)
--
Lib
Hi,
Am 26.12.2011 11:24, schrieb Luuk:
> Before creating the 'auto' filter, select all columns that are involved,
> or (better) select all the cells involved.
I would rather recommend to select one single cell inside the list
of data. Calc will automatically detect the data range.
Stefan
--
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 Freihe
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
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) In
Hi Steven,
Am 01.11.2011 22:26, schrieb Steven Dayton:
> I installed Libre Office recently and today I am working on
> learning about Macros. I want to record a macro and the direction
> in Help say to go to Tools > Macros > Record Macro but I get no
> Record Macro option that appears in the Macr
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
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
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) Cho
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, commen
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
--
LibreO
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
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:
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 -
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
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
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.lib
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 Exce
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 ea
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
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 sou
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, y
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 unsubscribe
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 Form
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,
Hi,
Am 03.05.2011 01:08, schrieb Helmar:
> A direct link to unsubscribe just as:
> "To unsubscribe send a blank message to users+unsubscr...@libreoffice.org"
Well, this is not correct in every case. That´s why you are supposed
to read the instructions, which you get by mailing to
users+h...@libr
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 ne
Hi,
Am 23.03.2011 21:25, schrieb william dockeray:
> Gentlemen:
What about the ladies? ;-)
> I created a two field, data base, and I can not even enter one record.
Are you sure you defined a primary key in your table? Without a PK
you won´t be able to add records.
Stefan
--
LibreOffice - Di
Hi,
Am 21.03.2011 17:59, schrieb James Wilde:
> I have a calc sheet with full names in one column, thus:
>
> John Smith
> Jane Smollett
>
> I want to create a column with forenames and one with surnames.
No need for formulae.
Have a look at: "Data | Text to Columns..."
See: http://help.libre
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...
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
--
Lib
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, downloa
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
Hi,
Am 15.03.2011 18:49, schrieb Gordon Burgess-Parker:
> On 15/03/11 15:51, Stefan Weigel wrote:
>> 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 Power
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,
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
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 Famil
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
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
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
Hi Pete,
Am 02.03.2011 19:50, schrieb Pete Bradbury:
> What function will enable me to access the data in the last used
> cell of a column of data?
For the value of the last used cell of column A use this formula in
any other cell outside of column A:
{=OFFSET($A$1;MAX(IF($A$1:$A$1048576<>"";RO
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
1 - 100 of 133 matches
Mail list logo
