Re: [libreoffice-users] Basic Calc Question
Barry Premeaux wrote: Thank you. I will give this a try. I guess a better description might have been a basic check book. The balance cell is empty until an associated transaction is entered. Then it updates the balance to reflect the transaction just made. If F4 is current balance, a transaction entered in E5 updates F5 to reflect the new balance. F6, 7, 8.. are still blank. OK, that makes sense. So it is not about the transaction being 0, but empty. Here is a working formula: =IF(ISBLANK(E4);;SUM(E$2:E4)) I have supposed that the transactions start at row 2. If not you have to change the E$2 accordingly. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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] Basic Calc Question
-Original Message- From: Barry Premeaux bpreme...@gmail.com To: users@global.libreoffice.org Sent: Mon, 13 Apr 2015 16:17 Subject: [libreoffice-users] Basic Calc Question I'm a novice at spreadsheets, and google hasn't turned up an answer. Probably because I haven't worded the question properly. I am trying to build a general ledger. I have my running balance in the F column and transactions in the E column. I am trying to construct a conditional statement that takes the running balance in F4 and adds it to the -/+ transaction in E5 and put the new balance in F5. But when the E5 is $0.00, I want F5 to remain $0.00 as well until a new transaction is entered. Reply: Barry, Try one of these formulas. The first does what you said you want. The second does what I think you want. =IF(E5=0,0,F4+E5) =IF(E5=,,F4+E5) -- Jim -- 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] Re: converting txt to dates
Yes It is 12-April-2015. I am using US Locale i.e. (English) US and it shows 12-04-2015 as 12-April-2015. -- View this message in context: http://nabble.documentfoundation.org/converting-txt-to-dates-tp4143826p4146197.html Sent from the Users mailing list archive at Nabble.com. -- 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] Re: converting txt to dates
I am using US Locale i.e. (English) US so it uses dd-mm-yy format. But your dates are in mm-dd-yy format. Inorder to convert 04-14-2015 to 14th April, 2015 , I need to change Date and Time settings from Control panel. I kept my US locale as it is and changed date format to mm-dd-yy and converted your dates as 13-April-2015, 14-April-2015, and so on. Hope this is useful. -- View this message in context: http://nabble.documentfoundation.org/converting-txt-to-dates-tp4143826p4146198.html Sent from the Users mailing list archive at Nabble.com. -- 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: Heads up -- LibreOffice 5.0 is on the horizion
Hi Stuart, Le 13/04/2015 20:01, V Stuart Foote a écrit : @Sophie, Happy to do what I can to move this along with both Design (I'm a member) and the Marketing teams. After last weeks Design meeting, Kendy was going to approach Marketing--specifically regards status of the LibreOffice Tango based icons as branding --- https://wiki.documentfoundation.org/images/d/d4/LibreOffice_Initial_Icons-pre_final.svg And, as well to propose contest for Visual design and Branding for 5.0--don't know where that stands. Opening the stub on the Design Wiki just gets it all moving--I hope ;-) But, I did poke Italo in his LibreOffice 5.0 Visual Identity task on the LibreOffice Marketing Redmine site. Great, thanks a lot for coordinating, everybody is in the loop :) Cheers Sophie -- Sophie Gautier sophie.gaut...@documentfoundation.org GSM: +33683901545 IRC: sophi Co-founder - Release coordinator The Document Foundation -- 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] Basic Calc Question
Try this in F5 =IF(E5=0,0,F4+E5) I tried the other formulas, but kept getting error codes. This one works and gives me the results I was looking for. F5 remains blank until their is an actual data entry in E5. Thank you for the help. Barry On Tue, Apr 14, 2015 at 12:10 AM, Piet van Oostrum p...@vanoostrum.org wrote: Barry Premeaux wrote: Thank you. I will give this a try. I guess a better description might have been a basic check book. The balance cell is empty until an associated transaction is entered. Then it updates the balance to reflect the transaction just made. If F4 is current balance, a transaction entered in E5 updates F5 to reflect the new balance. F6, 7, 8.. are still blank. OK, that makes sense. So it is not about the transaction being 0, but empty. Here is a working formula: =IF(ISBLANK(E4);;SUM(E$2:E4)) I have supposed that the transactions start at row 2. If not you have to change the E$2 accordingly. -- Piet van Oostrum p...@vanoostrum.org WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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: Heads up -- LibreOffice 5.0 is on the horizion
On April 13, 2015 7:31:03 AM PDT, V Stuart Foote wrote: jonathon wrote For some of us, those thumbnails are a security flaw. And all cleared with a single menu button click. So, it never has been a flaw--rather as designed Even with the ability to clear with a single menu click, there are user-cases were that remains a security flaw.(I'm hoping an extension can overide that fuctionality.) jonathon -- Multilingual ODF Office Suite 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] Re: Heads up -- LibreOffice 5.0 is on the horizion
toki kantoor wrote: On April 13, 2015 7:31:03 AM PDT, V Stuart Foote wrote: jonathon wrote For some of us, those thumbnails are a security flaw. And all cleared with a single menu button click. So, it never has been a flaw--rather as designed Even with the ability to clear with a single menu click, there are user-cases were that remains a security flaw.(I'm hoping an extension can overide that fuctionality.) jonathon A quick search turned up a feature request: https://bugs.documentfoundation.org/show_bug.cgi?id=74834 so the concerns are known and an option requested. And a couple of possible workarounds... https://bugs.documentfoundation.org/show_bug.cgi?id=74834#c11 Sets the history list size to 0, so no thumbnails, but nothing under File Recent Documents either. If you're really concerned about security / privacy, that's probably what you want anyway since listing file names has the potential to reveal information. http://ask.libreoffice.org/en/question/29139/can-the-new-start-screen-in-v42-be-reverted-to-that-in-v41/?answer=36673#post-id-36673 Nars gives a hack to hide the thumbnails. I haven't tried it. As noted, it's editing one of the main installation files so will affect all users. You probably also need administrator/root access to edit that file, and may need to re-do that customisation after installing updates. Hopefully there's something useful there. Mark. -- 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: Heads up -- LibreOffice 5.0 is on the horizion
Hi :) Yup, we are all loopy ;)) The weather where i am is unbelievably fantastic. Just a couple weeks ago i was wearing tons of layers and huge gloves and still shivering in the cold. Now i've got the windows open and listening to the birds making a right racket (in a good way). I hope it is good where all of you are too :) Good luck and regards from Tom :) on a lazily warm day On 14 April 2015 at 08:28, Sophie gautier.sop...@gmail.com wrote: Hi Stuart, Le 13/04/2015 20:01, V Stuart Foote a écrit : @Sophie, Happy to do what I can to move this along with both Design (I'm a member) and the Marketing teams. After last weeks Design meeting, Kendy was going to approach Marketing--specifically regards status of the LibreOffice Tango based icons as branding --- https://wiki.documentfoundation.org/images/d/d4/LibreOffice_Initial_Icons-pre_final.svg And, as well to propose contest for Visual design and Branding for 5.0--don't know where that stands. Opening the stub on the Design Wiki just gets it all moving--I hope ;-) But, I did poke Italo in his LibreOffice 5.0 Visual Identity task on the LibreOffice Marketing Redmine site. Great, thanks a lot for coordinating, everybody is in the loop :) Cheers Sophie -- Sophie Gautier sophie.gaut...@documentfoundation.org GSM: +33683901545 IRC: sophi Co-founder - Release coordinator The Document Foundation -- 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 -- 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] Re: Heads up -- LibreOffice 5.0 is on the horizion
Sorry, but all this crud about security of the StartCenter thumbnail view is FUD. Since 4.3.2 and commit http://cgit.freedesktop.org/libreoffice/core/commit/?id=a628ea1cd72585b889d591052680ebf79887dcefh=libreoffice-4-3 one simply needs to set a password for a document, and no thumbnail of the document will be created. Those of you with legitimate security concerns *are* password protecting your files right? See tdf#80755 https://bugs.documentfoundation.org/show_bug.cgi?id=80755 . Now, that said--there are some legitimate UX issues of textual vs. graphical thumbnails on the StartCenter as in the tdf#74834 https://bugs.documentfoundation.org/show_bug.cgi?id=74834 enhancement. -- View this message in context: http://nabble.documentfoundation.org/Heads-up-LibreOffice-5-0-is-on-the-horizion-tp4145906p4146273.html Sent from the Users mailing list archive at Nabble.com. -- 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] Test Message
Please disregard this message. It is a test of the use of an identity in Pegasus Mail. This identity is used only for posts to the LibreOffice Users mailing list and cannot be properly tested without that address in the To header. -- Jim -- 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] FrameMaker conversion
I run LO 4.4.2 on my Xubuntu 14.04.2 machines (work and home). I have some old files I created way back in the late 90s that are in Aldus/Adobe FrameMaker format. I'd really like to get them into a more suitable, portable format, like ODT. I tried to have my old FM create PDFs, but that piece does not work and the best I can get is postscript files that a) don't really print right and b) don't convert into ODT easily. Even .DOC format or .RTF would be better than the FM internal format that nothing else can read. I can do it manually, though I'd really rather not, so... Is there any app or plugin that does this? Thanks. MR -- 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