Re: [libreoffice-users] Base & PostgreSQL Transactions

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 wrote: > > Hi :) > > If you are looking for a good guide about Macros then Andrew Pitonyak's > > guide is su

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

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 http://h100

Re: [libreoffice-users] Base & PostgreSQL Transactions

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 ti

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

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 dif

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

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 w

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

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 work

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

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

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

On 2013-07-18 8:17 PM, Errol Goetsch wrote: PS In this example, the trigger value is transparent when the cell is unlocked (the user can see the conditional formatting formula), but you can make the trigger refer offsheet to a value the user can't see. Hope this helps Thanks for trying, but no

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

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 change the background of both, you merely need to change

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

On 2013-07-18 4:52 PM, Dave Liesse 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 to raise as a Feature Requ

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

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 So, i thought there was no problem until i hit the F

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

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 t

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

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 remembe

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

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. - Origi

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

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 tu

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

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

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

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: http://wiki.openoffice.org/wiki/Documentation/DevGuide/Database/Using_DBMS_Fe

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

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 formatti

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

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 change

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

On 07/15/2013 02:27 PM, Séamas Ó Brógáin wrote: Hello, Girvin. 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 not a n

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

On 2013-07-19 9:11 AM, Brian Barker 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 formatting of both the targ

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

> 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 > select

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

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 pro

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

I've managed to narrow things down a bit further: the troublesome content is in this SVM file: SVM_file_containing_equations.svm When the SVM file is opened in LibreOffice Draw, the missing content still app

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

On 19/07/2013 at 15:25, Dan Lewis 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 not a new featu

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

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 o

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

Hi :) It might be worth posting a bug report about this issue and mention that https://wiki.documentfoundation.org/BugReport Obviously just reinstall the 3.6.6 or the slightly newer 3.6.7.  Within a branch the updates are just bug-fixes, a little better compatibility with the latest versions of

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

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 Date: Fri, Jul 19, 2013 at 4:49 AM Sub

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

On 15/07/2013 at 12:46, Séamas Ó Brógáin 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 everywhere

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

This might be an important clue... Upgrading to 4.0.4.2 (from 3.6.6.2) has made things worse: in 4.0.4.2, the "missing" content appears to be missing even in the slide show view. - Original Message - From: Tom To: users@global.libreoffice.org Cc: Sent: Thursday, 18 July 2013, 18:58

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

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

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 https://addons.mozilla.org/en-US/firefox/addon/somewhere-ben

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

Hi :) Ok, i had a quick go at this and got this result ... 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 backg

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

On Fri, 19 Jul 2013 19:27:54 +0200 Daniel 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 works here with L

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

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 guidelin

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

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 come

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

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 forma

Re: [libreoffice-users] Base & PostgreSQL Transactions

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. http://www.amazon.com/s/ref=nb_sb_noss?url=search-a

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

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 o

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

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

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 ho

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

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 sid

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

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

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 not