Re: [libreoffice-users] Base PostgreSQL Transactions

2013-07-19 Thread mcmurchy1917-libreoffice
Have you read this document? http://www.baseprogramming.com/OOBasicDatabaseDev.pdf Iain On Thursday 18 Jul 2013 18:32:01 Don Parris wrote: On Thu, Jul 18, 2013 at 4:27 PM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) If you are looking for a good guide about Macros then Andrew

Re: [libreoffice-users] Printing with HP 960C Deskjet

2013-07-19 Thread Tom Davies
Hi :) Errr, sorry about my little outburst earlier.  C410 looks like it might be an even earlier model than the 960C.  However the 960C is specifically listed on Hewlett Packard page of printers that have recently had support withdrawn, at least withdrawn from newer versions of OS X

Re: [libreoffice-users] Base PostgreSQL Transactions

2013-07-19 Thread Tom Davies
Hi :) Ahhh, i usually try to ask first and then start reading through documentation.  If i find the answer first then i post it back to the list.  It doesn't always work out that way as a google search and an initial quick glance through documentation can sometimes become too absorbing and

Re: [libreoffice-users] Re: Errores de certificado en la web

2013-07-19 Thread Tom Davies
Hi :) It's good to disagree.  I think that is how we develop new ideas or new things.  Also if wee were all the same and all thought the same it would be mind-blowingly irritating (see various films such as Logans Run).  If you try to do exactly the same thing in exactly the same way on a

Re: [libreoffice-users] Re: Errores de certificado en la web

2013-07-19 Thread Andrew Brown
Hi all As to Tom's reference about broken systems, I cannot wholly agree. In my years of IT support to many clients and still current, I find resistance to change is more about a way of learning to do something with software apps, broken or not, and then having to relearn it, when approached

Re: [libreoffice-users] Printing with HP 960C Deskjet

2013-07-19 Thread Tom Davies
Hi :) Yes, duplexing and other features do work on some other printers.  The problem is that we can't always be certain of what will and what wont work.  As Virgil often grumbles it seems organisations like to change things around just to break things.  In this case the HP 960C Deskjet was

[libreoffice-users] Re: Some content in ODP slide appears only in slide show view of Impress, not in normal view or PDF output

2013-07-19 Thread vi5u0
Tom wrote Hi :) Sorry you haven't received many replies to this yet! You could upload the files to Nabble so that people can see them and see the problem. It's not as tough as it sounds! Just use the links in this email or navigate to the right thread through the official site Get

Re: [libreoffice-users] Cell references - apply formats too?

2013-07-19 Thread Tanstaafl
On 2013-07-18 10:52 PM, Brian Barker b.m.bar...@btinternet.com wrote: What you can do, of course, is to set up another column or row in which you put suitable values which can then control conditional formatting of both the target cell and the referencing one. To change the background of both,

Re: [libreoffice-users] Calc - allow users to format cells on protected sheets

2013-07-19 Thread Tanstaafl
On 2013-07-18 4:52 PM, Dave Liesse dslie...@liessefamily.net wrote: I think what the OP is referring to is that in Excel you can do whatever you want to a protected spreadsheet -- you just can't save the changes. That is actually a completely different issue, but one that I have been meaning

[libreoffice-users] Re: Some content in ODP slide appears only in slide show view of Impress, not in normal view or PDF output

2013-07-19 Thread Tom
Hi :) When i first opened the Odf it looked fine. Lots of white space (actually blue-sky). The Pdf looked the same. Slide_with_vanishing_content.pdf http://nabble.documentfoundation.org/file/n4066185/Slide_with_vanishing_content.pdf So, i thought there was no problem until i hit the F5

Re: [libreoffice-users] Calc - allow users to format cells on protected sheets

2013-07-19 Thread Tom Davies
Hi :) Ahh, i think it happens the other way too.  That if you protect a document in LibreOffice then people opening it in MS Office will find the protection gets ignored.  Personally i find it difficult enough to get people to edit and add their ideas into documents that are open and meant to

Re: [libreoffice-users] Cell references - apply formats too?

2013-07-19 Thread Tom Davies
Hi :) I think what you are asking for can't be done.  It might be worth asking on the devs list to see if they have some quick way of diving into the code or it might be worth posting a bug-report about it as a feature request.  There might already be a bug-report although i seem to remember

Re: [libreoffice-users] Re: Some content in ODP slide appears only in slide show view of Impress, not in normal view or PDF output

2013-07-19 Thread Dan
IIRC, the equations were originally copied and pasted into Impress from a pptx presentation that I had open in PowerPoint 2010.  I have a vague memory that, immediately after pasting them, they looked right in Normal view until the first time that Impress was closed and restarted. -

Re: [libreoffice-users] Calc - allow users to format cells on protected sheets

2013-07-19 Thread Tom Davies
Hi :) It sounds like a proper database would be better.  Then reports can show the information in different ways, in different orders, without affecting the under-laying data.  The front-end could be Writer and could be restricted to just certain fields (columns).  Once set-up it could well

Re: [libreoffice-users] Re: Errores de certificado en la web

2013-07-19 Thread Tom Davies
Hi :) I do think Andrew has valid points and it makes sense intuitively.  I had just been having a bad hair day and feeling a bit disheartened.  Really just having another spin on The Matrix quote about losing the entire 1st crop due to not stressing the system enough.  Regards from Tom :) 

Re: [libreoffice-users] Re: Some content in ODP slide appears only in slide show view of Impress, not in normal view or PDF output

2013-07-19 Thread Tom Davies
Hi :) Ahhh, they might have pulled some bad formatting with them.  I often find it's good to make a fresh start in LibreOffice at some point.  For normal text doing Ctrl Shift v to Paste Special and then choose unformatted text gets rid of a lot of messy formatting.  Then apply and modify

Re: [libreoffice-users] Base PostgreSQL Transactions

2013-07-19 Thread Andrew Douglas Pitonyak
The ODF Authors are working on a DB guide, I do not know the current state of it, have you looked for it (or at it)? https://wiki.documentfoundation.org/images/5/50/BH40-BaseHandbook.odt These may also be of interest:

Re: [libreoffice-users] Error in Calc custom formats between closing and opening a file

2013-07-19 Thread Paul
Hi All, Haven't had a chance to test in LO 4.1 beta, but I was hoping someone could at least confirm that they are getting the same results in 4.0 or prior, and maybe even someone with 4.1 could comment on if it is still happening. Anybody? Regina, you said you weren't getting the weird

Re: [libreoffice-users] Cell references - apply formats too?

2013-07-19 Thread Brian Barker
At 06:44 19/07/2013 -0400, Charles Marcus wrote: On 2013-07-18 10:52 PM, Brian Barker wrote: What you can do, of course, is to set up another column or row in which you put suitable values which can then control conditional formatting of both the target cell and the referencing one. To

Re: [libreoffice-users] Cell references - apply formats too?

2013-07-19 Thread Tanstaafl
On 2013-07-19 9:11 AM, Brian Barker b.m.bar...@btinternet.com wrote: At 06:44 19/07/2013 -0400, Charles Marcus wrote: On 2013-07-18 10:52 PM, Brian Barker wrote: What you can do, of course, is to set up another column or row in which you put suitable values which can then control conditional

Re: [libreoffice-users] Pull-down styles menu

2013-07-19 Thread Séamas Ó Brógáin
This is not a new feature. I have seen in in Writer since OOo 2.0 or before. What you want to remove is a tool in one of the toolbars. You can hide this menu by right clicking between any of the tools in that toolbar. Click Visible Buttons in the pop up window. Then selectApply

Re: [libreoffice-users] Errores de certificado en la web

2013-07-19 Thread Valter Mura
In data lunedì 15 luglio 2013 13:27:09, Jairo de Jesús López Ayola ha scritto: Thank you for your quick answer, y really appreciate it, So, IE8 is working fine and it starts an automatic download (i'm not sure if it has to behave like that). And What about IE9 ? It is not really a big problem

[libreoffice-users] Re: Some content in ODP slide appears only in slide show view of Impress, not in normal view or PDF output

2013-07-19 Thread vi5u0
I've managed to narrow things down a bit further: the troublesome content is in this SVM file: SVM_file_containing_equations.svm http://nabble.documentfoundation.org/file/n4066225/SVM_file_containing_equations.svm When the SVM file is opened in LibreOffice Draw, the missing content still

Re: [libreoffice-users] Pull-down styles menu

2013-07-19 Thread Mirosław Zalewski
On 19/07/2013 at 15:25, Dan Lewis elderdanle...@gmail.com wrote: No, it’s the pull-down menu of paragraph styles––beside the font names. I already have the latter de-embellished (?), but I don’t see a similar option for the former. And I’m pretty sure this is a new feature. This is

Re: [libreoffice-users] Creating a good looking document with videos in it

2013-07-19 Thread anne-ology
There are a couple ways to accomplish what I think you want - 1 - Probably the simplest - upload the videos then place the URL into the document - (Dropbox is what I use) 2 - add the videos through LO ... in the insert-tab, rather than clicking on image, click

Re: [libreoffice-users] Re: Some content in ODP slide appears only in slide show view of Impress, not in normal view or PDF output

2013-07-19 Thread anne-ology
I merely meant going through the various tabs-menu ;-) [insert tab - scrolling down to whichever option desired - 'browsing' to that item on the computer - choosing that item - LO places it into the document ... ... ... ] From: vi5u0 vi5u0-libreoff...@yahoo.co.uk Date: Fri,

Re: [libreoffice-users] Pull-down styles menu

2013-07-19 Thread Mirosław Zalewski
On 15/07/2013 at 12:46, Séamas Ó Brógáin s...@iol.ie wrote: My version of Libre Office (4.0.2.2) on GNU/Linux (Ubuntu 13.04) has a feature that I decidedly don’t want: illustrating the styles in the pull-down style menu in the actual typeface and size (some huge, some tiny). I’ve searched

Re: [libreoffice-users] Pull-down styles menu

2013-07-19 Thread Tom Davies
Hi :) Instead of saying me too it might help more (in most cases) to put what version of LO you are using and what version of which platform.  So for example LO 3.5.4 on Xp.  Moght often help the devs pin down when the problem first appeared in the code.  However, in this case i think it's

[libreoffice-users] LO crashing when adding a FF theme

2013-07-19 Thread Daniel
I'm using LO 4.1.0.3 on LMDE. I'm trying to install a theme from a firefox addon but LO is crashing Open LO. Go to tools - options - personalization Select theme - visit Firefox theme (website and select your favourite one) Mine is

[libreoffice-users] Re: Some content in ODP slide appears only in slide show view of Impress, not in normal view or PDF output

2013-07-19 Thread Tom
Hi :) Ok, i had a quick go at this and got this result ... Slide_with_vanishing_content-rewritten.odp http://nabble.documentfoundation.org/file/n4066261/Slide_with_vanishing_content-rewritten.odp Errr, i don't really know my way around Impress yet so i couldn't get the same sky in as a

Re: [libreoffice-users] LO crashing when adding a FF theme

2013-07-19 Thread Brad Rogers
On Fri, 19 Jul 2013 19:27:54 +0200 Daniel dan...@onvol.net wrote: Hello Daniel, Press okand LO crashesany ideas or is it a bug ? You have to copy the url from the browser window into the text string field before you click OK. It's not clear (to me) that you're doing that. Anyhow, it

Re: [libreoffice-users] Pull-down styles menu

2013-07-19 Thread Séamas Ó Brógáin
Thank you, Mirosław. I suspected it was something that cannot be turned off. It is only a small irritant, and I can live with it. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting

Re: [libreoffice-users] LO crashing when adding a FF theme

2013-07-19 Thread Andrew Brown
Hi Daniel To help you, I as a user tried it, using tiger eyes light blue https://addons.mozilla.org/en-US/firefox/addon/tiger-eyes-light-blue/, and then your theme you wanted https://addons.mozilla.org/en-US/firefox/addon/somewhere-beneath-the-golde/?src=ss and my LO worked fine. It does

Re: [libreoffice-users] Cell references - apply formats too?

2013-07-19 Thread er...@xe4.org
Charles asked Is it possible to have a cell on one worksheet that references a cell on another worksheet to also reflect the FORMAT of the referenced cell? Ie, if the referenced cell has a red background, the cell referencing it should also have a red background? Yes, using conditional

Re: [libreoffice-users] Base PostgreSQL Transactions

2013-07-19 Thread Mark LaPierre
Hey Don, I've not bought one yet, but this is the best reference I've found out about for LO Base. It's based on OOo Base, but that's most likely not a real issue. The one biggest problem with LO Base is the decided lack of documentation.

Re: [libreoffice-users] Re: Some content in ODP slide appears only in slide show view of Impress, not in normal view or PDF output

2013-07-19 Thread Regina Henschel
Hi vi5u0, vi5u0 schrieb: Tom wrote Hi :) Sorry you haven't received many replies to this yet! You could upload the files to Nabble so that people can see them and see the problem. It's not as tough as it sounds! Just use the links in this email or navigate to the right thread through the

[libreoffice-users] Re: Errores de certificado en la web

2013-07-19 Thread Urmas
LibreOffice is NOT just a cheap knock-off of MS Office. It has different ways of doing things. A different ethos. Sometimes it does things that MSO can't. Sometimes it leaves certain things, such as emailing, to other products so that you can choose between alternatives to suit your needs.

Re: [libreoffice-users] Base PostgreSQL Transactions

2013-07-19 Thread Don Parris
Thanks Andrew, So far, none of the links really strike me as helpful. Sorry, but this is fairly new territory to me. I had hoped I would find a tutorial something along the lines of: We're going to create a way for users to enter/update data across a few tables in a single transaction. Here's

Re: [libreoffice-users] Re: Visible currency rounding

2013-07-19 Thread Brian Barker
At 16:26 19/07/2013 -0700, Todor Takov wrote: I needed to implement the so called Bankers' Rounding Function, which would round with respect to the 4/5 rule. And finally I ended doing it myself in a short Function in LO Basic. I tried my best, although math and programming are not my strong

Re: [libreoffice-users] Re: Visible currency rounding

2013-07-19 Thread Tom Davies
Hi :) It's really good to see more people sharing code on this list.  Looks like a useful function to have.  Sometimes it is more useful to have a working bit of code that is a mess rather than something elegant that doesn't work.  It follows the philosophy of Release early and release often. 

Re: [libreoffice-users] Re: Visible currency rounding

2013-07-19 Thread Mark LaPierre
On 07/19/2013 07:26 PM, toodr wrote: I had the same problem. I needed to implement the so called Bankers' Rounding Function, which would round with respect to the 4/5 rule. And finally I ended doing it myself in a short Function in LO Basic. I tried my best, although math and programming are