[users] Reports using parameter queries
How do I get a report to give current results after I've modified the parameters of it's query input? It is giving me results from the previous parameters in effect in the query. FP
Re: [users] Reports using parameter queries
Floyd Noel wrote: How do I get a report to give current results after I've modified the parameters of it's query input? It is giving me results from the previous parameters in effect in the query. FP You have to recreate the report. A dynamic report will only update based upon additional data that has been added. It will not update a change in the query. Note: this is when you are using the Report Wizard to create the report. I have not worked with the Sun Report Builder Extension to know whether you can use that to modify a report when the query structure has been changed. Dan - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: Reports using parameter queries
Floyd Noel wrote: How do I get a report to give current results after I've modified the parameters of it's query input? It is giving me results from the previous parameters in effect in the query. FP Yes, you can also use the old style reports dynamically. Bug and workaround: http://www.openoffice.org/issues/show_bug.cgi?id=98163 You can do parameter substitution by means of forms where a parent form substitutes the parameter values of a subform's underlying param query. Knowing this and how to store and read criteria values from a dedicated record of a filter table you may create something like this: http://user.services.openoffice.org/en/forum/viewtopic.php?f=39t=22936 Hope this helps, Andreas - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Appearance of toolbars and selected text
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Harold Fuchs wrote: On 8 April 2010 22:13, Ken Heard k...@heard.name wrote: snip I discovered that on my laptop OOo *does* use my KDE settings for colours. So the question now is why OOo will not use those settings on my desktop. As far as I can figure out I have the same versions of all the OOo and KDE Debian packages on both computers - -- a real mystery. Has anyone else encountered the same problem? At he risk of teaching my grandmother to suck eggs, perhaps a reboot after asking OOo to use the system's settings. Or at least stopping and re-starting *all* OOo processes - is there a Quickstarter on your system? No, my OS is the Debian Lenny distribution of Linux with the KDE desktop environment. The quickstarter is only available on Microsoft Windows. I have set the KDE colour options to be used on all non-KDE applications, and have set OOo to use the system colours. On my desktop all my non-KDE apps use system colours set in KDE *except* OOo; whereas on my laptop all non-KDE apps *including* OOo use the system colours. I am trying to figure out why. Ken Heard -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAku/PzcACgkQlNlJzOkJmTdKugCffzpnYOSOxTnIX7fDcoRKZBQL 1LMAn1p+IL1Lvo+av4uLOWqbFViSmyco =dMaT -END PGP SIGNATURE- - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Appearance of toolbars and selected text
Dne Pá 9. dubna 2010 16:52:40 Ken Heard napsal(a): No, my OS is the Debian Lenny distribution of Linux with the KDE desktop environment. The quickstarter is only available on Microsoft Windows. No, that's not true. I use Mandriva Linux and I have the QS. It's a compilation parameter so your packager could do it for you. Mandriva Linux and Ubuntu users use a Go-oo variation with QS. I have set the KDE colour options to be used on all non-KDE applications, and have set OOo to use the system colours. On my desktop all my non-KDE apps use system colours set in KDE except OOo; whereas on my laptop all non-KDE apps including OOo use the system colours. I am trying to figure out why. You're probably missing a package named openoffice.org-kde http://packages.debian.org/lenny/openoffice.org-kde -- Vlastimil Ott www.e-ott.info Stahujte časopis o softwaru. Zdarma. http://www.openmagazin.cz - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: Scrolling Presentation
On 08/04/2010 19:20, Daniel Lewis wrote: Gordon Burgess-Parker wrote: How do I set a presentation so that it scrolls round and round until I stop it? I've found the time for each slide in Slideshow-Transition but it stops after the last slide. How do I get it to start at the beginning again automatically? - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org This can be done in the Slide Show menu: Slide Show Slide Show Settings. In the Type section, click the Auto option button and select the time you want to pause between showing the last slide and the first slide. You can also set this when you create the presentation. In Presentation Wizard, window #3, Select a slide transition type: click the Automatic option button. Set Duration of pause to the value you want for time between last slide and first slide. Just make sure that you set the time between slides in the Task section in the Slide Transition section. Dan Thanks very much! - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
RE: [users] Re: converting a .pdf to .odt???
R N D Martin [mailto:rndmar...@cix.co.uk] suggested: In article hp31iv$cj...@dough.gmane.org, b...@oblong.com.au (Bob Long) wrote: *From:* Bob Long b...@oblong.com.au *To:* users@openoffice.org *Date:* Fri, 02 Apr 2010 07:01:17 +1000 Dave Stevens wrote, I have to convert a .pdf for which I no longer have access to the original .odt format. I've installed the sun-pdfimport extension and can open the file in Foxit reader which is faster than the adobe reader also has a save as facility which can be used to extract a text file from most pdfs. The resulting text file can of course be pasted into OO writer and then word processed. With the Foxit Reader installer, I encountered the same problem that I did with OpenOffice.org 3.2 installer - it insisted that I lacked sufficient rights on my own system (I have admin rights). The difference is that the OOo installer eventually relented and I got 3.2 installed despite the protests - and without any change to my system (Windows XP Pro x64). The Foxit installer just keeps crapping out after the splash-screen and the warning. Too bad. I was prepared to try it and upgrade to the pay-for version. Maybe I'll see if I can get it to install on my laptop at home, with Windoze 7 Ultimate. - Kevin bumpf follows... --|The information contained in this electronic mail transmission may be privileged and confidential, and therefore, protected from disclosure. If you have received this communication in error, please notify us immediately by replying to this message and deleting it from your computer without copying or disclosing it. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Squiggly lines under all words
Horace Greely wrote: I am sorry if this has been addressed but I can not find the fix here. Also difficult to use spell check. I have attached a screen grab. Thanks for any assistance here. Horace and I have been looking at this off-list, and it now appears that for some reason the standard dictionary (from an en-us installation) is being applied, but is empty. Almost every word in his documents is identified as misspelled (although spellcheck appears satisfied with all-caps words, in this case ACE and FAX, and with digits), and right-clicking provides no words as suggestions, just the other options about ignoring and so on. When he adds a word to the standard [ALL] dictionary via the Add option of the spellchecker, it is recognized for that session, but closing OOo and opening another document with the same word it is again unrecognized. (At least, this seems to have happened once.) I'm not really familiar with dictionary management, can anybody suggest what might be happening? He's tried reinstalling several times, but so far no luck. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: Export to PDF problem - pinyin
On 04/08/2010 04:25 PM, NoOp wrote: ... James, if you can send me a sample .odt directly I'll be happy to test on OOo (linux windows). It's definitely in the OOo pdf export. I've sent you back two pdf's, one that was printed to a cups-pdf printer, and the second that was exported from OOo. The OOo export pdf is pretty much as you've described, the print to a virtual pdf printer (cups-pdf) displays all of the characters correctly. Gary - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Export to PDF problem - pinyin
On Apr 9, 2010, at 19:18 , NoOp wrote: On 04/08/2010 04:25 PM, NoOp wrote: ... James, if you can send me a sample .odt directly I'll be happy to test on OOo (linux windows). It's definitely in the OOo pdf export. I've sent you back two pdf's, one that was printed to a cups-pdf printer, and the second that was exported from OOo. The OOo export pdf is pretty much as you've described, the print to a virtual pdf printer (cups-pdf) displays all of the characters correctly. Got them, thanks, and looked at them. More news, Gary: If I select my printer and choose the pdf option, it prints okay, too, so I guess I'll try that on my whole document. //James - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Squiggly lines under all words
Barbara Duprey wrote: Horace Greely wrote: I am sorry if this has been addressed but I can not find the fix here. Also difficult to use spell check. I have attached a screen grab. Thanks for any assistance here. Horace and I have been looking at this off-list, and it now appears that for some reason the standard dictionary (from an en-us installation) is being applied, but is empty. Almost every word in his documents is identified as misspelled (although spellcheck appears satisfied with all-caps words, in this case ACE and FAX, and with digits), and right-clicking provides no words as suggestions, just the other options about ignoring and so on. When he adds a word to the standard [ALL] dictionary via the Add option of the spellchecker, it is recognized for that session, but closing OOo and opening another document with the same word it is again unrecognized. (At least, this seems to have happened once.) I'm not really familiar with dictionary management, can anybody suggest what might be happening? He's tried reinstalling several times, but so far no luck. I seem to remember this being a problem with the Standard[ALL] dictionary before, but I am not sure what the final disposition of it was. Perhaps this is a reversion back to that earlier time. I have my own way of getting around this potential problem. With the Spelling dialog open, click the Options button to open the Options dialog. I then create a personal dictionary and click the checkbox in front of the new dictionary. Then I add the words that to the new dictionary. Dan - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: Export to PDF problem - pinyin
On 04/09/2010 10:25 AM, James Wilde wrote: On Apr 9, 2010, at 19:18 , NoOp wrote: On 04/08/2010 04:25 PM, NoOp wrote: ... James, if you can send me a sample .odt directly I'll be happy to test on OOo (linux windows). It's definitely in the OOo pdf export. I've sent you back two pdf's, one that was printed to a cups-pdf printer, and the second that was exported from OOo. The OOo export pdf is pretty much as you've described, the print to a virtual pdf printer (cups-pdf) displays all of the characters correctly. Got them, thanks, and looked at them. More news, Gary: If I select my printer and choose the pdf option, it prints okay, too, so I guess I'll try that on my whole document. //James Works using export to pdf if you change the fonts to TimesNewRoman. Looks like a problem with the Courier font. See the PDF's that I sent back to you (linux Windows). - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Word count
I have a text that has to be reduced considerably in extent while it is being edited; I also have to use the change-tracking feature (Openoffice 3.2, Ubuntu 9.10). I was disheartened to discover that, after cutting unmercifully, the text seemed to be no shorter. The thought then occurred that the word count might be including the deleted words, and this in fact seems to be what is happening. I can establish the correct figure by saving a copy as plain text (.txt), confirming that there is no hidden text, and then I consistently get a lower figure. I later discovered that in the Openoffice document if I select the whole text and do a word count, the count for the selection sometimes––but not always––gives the correct (lower) figure, while the main count does not. Is this a known fault? - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org