[libreoffice-users] Re: Calc: suppress header/footer from page 15 onwards

2019-12-25 Thread David S. Crampton
as desired. Next month I will be asked to again update and publish this contact list. I will work with page styles first. David - -- David S. Crampton -- Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html -- To unsubscribe e-mail to: users+uns

[libreoffice-users] Re: Calc: suppress header/footer from page 15 onwards

2019-12-25 Thread David S. Crampton
it but clumsy and error prone. Using v 6.2.8.2 - -- David S. Crampton -- Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing

[libreoffice-users] Re: Update SQL does nothing using Run SQL directly button

2012-10-07 Thread David S. Crampton
return to the GUI table, and then to the SQL, the SQL phrases will be unformatted: just a long line. - -- David S. Crampton -- View this message in context: http://nabble.documentfoundation.org/Update-SQL-does-nothing-using-Run-SQL-directly-button-tp4010902p4011942.html Sent from the Users

[libreoffice-users] Re: Update SQL does nothing using Run SQL directly button

2012-10-05 Thread David S. Crampton
suggestions. This year and month data is very unlikely to change once the transaction record is accurately entered. Thank you, all, David - -- David S. Crampton -- View this message in context: http://nabble.documentfoundation.org/Update-SQL-does-nothing-using-Run-SQL-directly-button

[libreoffice-users] Update SQL does nothing using Run SQL directly button

2012-10-03 Thread David S. Crampton
nothing. The statement won't run with the F5 key (the run button). It gives The given command is not a SELECT statement. I'm trying to apply SQL learned elsewhere, mostly in MicroBloat Access, and I'm getting nowhere. Help will be appreciated. David - -- David S. Crampton -- View

[libreoffice-users] Re: No Java could be found: LO 3.6.1.2: Win7 pro sp1; java 1.7.0_07

2012-09-30 Thread David S. Crampton
- -- David S. Crampton -- View this message in context: http://nabble.documentfoundation.org/No-Java-could-be-found-LO-3-6-1-2-Win7-pro-sp1-java-1-7-0-07-tp4010076p4010109.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h

[libreoffice-users] Re: No Java could be found: LO 3.6.1.2: Win7 pro sp1; java 1.7.0_07

2012-09-30 Thread David S. Crampton
the one registered Java. In Windows Control Panel | Programs is listed only 1 entry: Java 7 update 7 Should I revert to the java 6? Thanks for your patience, - -- David S. Crampton -- View this message in context: http://nabble.documentfoundation.org/No-Java-could-be-found-LO-3-6-1-2

[libreoffice-users] Re: No Java could be found: LO 3.6.1.2: Win7 pro sp1; java 1.7.0_07

2012-09-30 Thread David S. Crampton
Base is now working with jre 1.6.0_30. Left unsolved is why Java 7 update 7 doesn't work. Having 6 work is good enough for me at this time. Thanks to all, - -- David S. Crampton -- View this message in context: http://nabble.documentfoundation.org/No-Java-could-be-found-LO-3-6-1-2-Win7

Re: [libreoffice-users] Re: some text not printing

2012-01-23 Thread David S. Crampton
. -- David S. Crampton On Mon, 23 Jan 2012 11:40:41 -0800, George E Noon ge.n...@verizon.net wrote: Spencer, The document in question is a set of the By-Laws of an Odd Fellow Lodge that I happen to have been Secretary of for 19 years, now. I've had it since January, 2002, when as Lodge

Re: [libreoffice-users] Re: When will be a Web-Version of OOo/LO available?

2011-12-14 Thread David S. Crampton
and avoid the siren call of M$ style big money and big ego. Good luck! No, seriously, good luck to us all. -- David S. Crampton On Wed, 14 Dec 2011 07:35:51 -0800, webmaster for Kracked Press Productions webmas...@krackedpress.com wrote: On 12/14/2011 10:18 AM, Caesar wrote: On Wed, 14

Re: [libreoffice-users] Re: LibreOffice Portable

2011-12-14 Thread David S. Crampton
archive at Nabble.com. -- David S. Crampton -- For unsubscribe instructions e-mail to: users+h...@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

Re: [libreoffice-users] Re: LibreOffice Portable

2011-12-14 Thread David S. Crampton
, and it hasn't thrown any flags while silently killing ONLY LibreOffice Portable downloads. On 12/14/2011 6:14 PM, David S. Crampton wrote: Try to turn off your realtime antivirus scanner. Unload it or stop the process. On Wed, 14 Dec 2011 13:33:40 -0800, Pedro pedl...@gmail.com wrote: M Robinson wrote

Re: [libreoffice-users] import from HTML

2011-12-12 Thread David S. Crampton
Jef, Take a look at the raw HTML. The formatting might be using style sheets (.css) files. It is pretty easy for the linkages between the body of html and the external style sheets to be broken. Just a suggestion, -- David S. Crampton On Mon, 12 Dec 2011 00:34:55 -0800, jef peeraer

Re: [libreoffice-users] Calc: Identifying duplicate cell values with conditional formatting?

2011-12-12 Thread David S. Crampton
to you, -- David S. Crampton On Mon, 12 Dec 2011 06:39:31 -0800, Hylton Conacher (ZR1HPC) hyl...@conacher.co.za wrote: Hi, Using LibreOffice 3.3.1 and am in the process of editing a 68000 row, 10 column file. There are two main columns that contain the data to be cleaned up with multiple

Re: [libreoffice-users] Identifying the correct row in Spreadsheet formulas

2011-12-09 Thread David S. Crampton
of spreadsheets, for the raw data, and databases for the monthly reporting in my budget/expense tracking work. -- David S. Crampton On Fri, 09 Dec 2011 04:12:23 -0800, Ian Whitfield whitfi...@telkomsa.net wrote: Hi All I have a spread sheet in LO 3.4.3 where I record and analyse monthly

Re: [libreoffice-users] Calc: How to refresh advanced filter automatically

2011-12-05 Thread David S. Crampton
. -- David S. Crampton On Mon, 05 Dec 2011 06:08:46 -0800, relgames relga...@gmail.com wrote: Hi, I have Calc file with a long list of rows, what I need is to filter those rows by some criteria entered by user. So, if user enters 15 into some cell, list should immediately update itself and show only

Re: [libreoffice-users] open .odt without updating fields

2011-12-03 Thread David S. Crampton
in collaborative projects where people are supposed to update their own portions and meet a schedule (but often do not). -- David S. Crampton On Sat, 03 Dec 2011 00:11:41 -0800, bjloc...@lockie.ca wrote: I have a Writer file that has a date field. Is it possible to open the file with the date field

[libreoffice-users] Re: Stuck with 3.3 forever?

2011-12-03 Thread David S. Crampton
in my spreadsheet have become messed up. - -- David S. Crampton -- View this message in context: http://nabble.documentfoundation.org/Stuck-with-3-3-forever-tp3557428p3557547.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h

Re: [libreoffice-users] Re: Stuck with 3.3 forever?

2011-12-03 Thread David S. Crampton
and a numeric but gives a numeric when combining a text string which can be interpreted as a numeric with a numeric. Per my mini-sermon (earlier today) on debugging and preferring strict type-based behavior, I would prefer A5 to also display #VALUE. -- David S. Crampton On Sat, 03 Dec

Re: [libreoffice-users] The tone of thiese Lists (from a newbie)

2011-11-26 Thread David S. Crampton
! Good luck, David S. Crampton On Sat, 26 Nov 2011 09:11:52 -0800, Bob Houston bob_hous...@hotmail.com wrote: Tom, Thanks for the quick response. My question was sent directly to (user+help) but right after signing up. Maybe I should have waited for the dust to settle before launching

Re: [libreoffice-users] Installer stalls after C++ process

2011-11-25 Thread David S. Crampton
. -- David S. Crampton On Fri, 25 Nov 2011 10:33:48 -0800, Michael Bauer f...@akerbeltz.org wrote: Hi ppl, My motherboard died on me this morning so I was forced to move on to Win 7 (shudders). Anyway, when I re-downloaded LO (x86), my install process got as far as unpacking, then moved onto the C

[libreoffice-users] How do I enter a numeric into a Calc cell from LO Basic macro?

2011-11-21 Thread David S. Crampton
args1(0).Value = 4 End Select dispatcher.executeDispatch(document, .uno:EnterString, , 0, args1()) Firsta = Firsta + 1 Loop While Firsta = Things ~~~end code fragment~ -- David S. Crampton -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems

Re: [libreoffice-users] How do I enter a numeric into a Calc cell from LO Basic macro?

2011-11-21 Thread David S. Crampton
). Especially the .setValue! That type of syntax I have not found anywhere in the LO Basic documentation. Can you point me to the source for this? Thank you, David On Mon, 21 Nov 2011 09:08:41 -0800, Johnny Rosenberg gurus.knu...@gmail.com wrote: 2011/11/21 David S. Crampton david_cramp

Re: [libreoffice-users] Mail merge doesn't send e-mails

2011-11-20 Thread David S. Crampton
This sounds to me like an e-mail processing issue; not an LO problem. What exactly is the evidence that some of the e-mails are not sent? How large is the document that you are trying to send? What is your e-mail environment? Your client? Your messaging server? What is your antivirus

[libreoffice-users] Backspace key in IDE behaves as Delete Key instead.

2011-11-18 Thread David S. Crampton
to the right of the cursor. Quick search through Bugzilla returned way too many results on Backspace. LO 3.4.4 (also observed in 3.4.3) on Windows XP, US English, Microsoft Natural Keyboard. -- David S. Crampton -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems

[libreoffice-users] How do I enable Create new Python macros?

2011-11-16 Thread David S. Crampton
on Windows XP Pro. -- David S. Crampton -- For unsubscribe instructions e-mail to: users+h...@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

Re: [libreoffice-users] How do I enable Create new Python macros?

2011-11-16 Thread David S. Crampton
language? The fact that the sample Python scripts execute properly implies that a Pyton environment is already within LO. I would regale the forum with the story of the optimist's birthday present but ... I digress. I fully agree with ditching not great editors. -- David S. Crampton On Wed

Re: [libreoffice-users] How do I report an error in Help web pages?

2011-11-14 Thread David S. Crampton
This is now in bugzilla as #42924. Status is unconfirmed at this writing -- David S. Crampton On Mon, 07 Nov 2011 07:44:34 -0800, webmaster for Kracked Press Productions webmas...@krackedpress.com wrote: Thanks for the report of the error. This is a good place to put it if you have

Re: [libreoffice-users] Problem: LibreOffice remembers the last folder I was in (open/save dialog)

2011-11-09 Thread David S. Crampton
. I most frequently use the Recent Documents list within LO. The 10 listed items there are just right historical coverage. Respectfully blustering, -- David S. Crampton On Wed, 09 Nov 2011 07:13:41 -0800, Mike Moratz-Coppins mc_lego...@yahoo.co.uk wrote: Platform: Win7 SP1 64-bit

Re: [libreoffice-users] Problem: LibreOffice remembers the last folder I was in (open/save dialog)

2011-11-09 Thread David S. Crampton
, then an option to configure that behaviour between 'default documents folder' and 'last used folder' would be much appreciated. -- David S. Crampton -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how

[libreoffice-users] How do I report an error in Help web pages?

2011-11-07 Thread David S. Crampton
. The login to 'help.libreoffice.org' is apparently different than 'www.libreoffice.og'. I don't want to create so many different credentials. How, then, to report this error? If not sufficiently done here. -- David S. Crampton -- For unsubscribe instructions e-mail to: users+h

[libreoffice-users] name-define-edit causes crash in LO Calc v3.4.3

2011-11-05 Thread David S. Crampton
from Users forum I will post as new bug. Regards -- David S. Crampton -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org

Re: [libreoffice-users] flip columns in calc

2011-11-03 Thread David S. Crampton
in that ascending order. Transpose converts rows to columns and columns to rows. -- David S. Crampton On Wed, 02 Nov 2011 21:12:08 -0700, Jason Paul Joines ja...@joines.org wrote: I'm using LibreOffice 3.4.3 on Kubuntu 11.04. Is there any way to reverse the order of columns in a Calc spreadsheet

Re: [libreoffice-users] in Calc: Keyboard trouble with Ctrl+Shift+RightArrow

2011-11-02 Thread David S. Crampton
I entered my description into Bugzilla: Assigned Bug # 42535 Bug 42535 - Editing UI: Ctrl+Shift-RightArrow faulty extension result -- David S. Crampton On Tue, 01 Nov 2011 23:30:34 -0700, Stephan Zietsman szi...@gmail.com wrote: David S. Crampton wrote: I don't think the bugs described

Re: [libreoffice-users] in Calc: Keyboard trouble with Ctrl+Shift+RightArrow

2011-11-01 Thread David S. Crampton
...@gmail.com wrote: David S. Crampton wrote: The keystokes: In L154: Ctrl+C Down Arrow: moves to L155 Ctrl+V: paste Esc: terminate the dotted border focus on L154 F2: make the small edit Enter: terminate the edit Ctrl+Shift+RightArrow: SHOULD extend to AB156 where it finds the next filled cell

[libreoffice-users] in Calc: Keyboard trouble with Ctrl+Shift+RightArrow

2011-10-31 Thread David S. Crampton
or the NumberPad (NumLock off). -- David S. Crampton -- For unsubscribe instructions e-mail to: users+h...@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

[libreoffice-users] How may I read the value of a cell into a macro variable?

2011-10-28 Thread David S. Crampton
, -- David S. Crampton -- For unsubscribe instructions e-mail to: users+h...@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

Re: [libreoffice-users] Re: OO Base will not run in LO Base

2011-10-28 Thread David S. Crampton
be populated, fully functioning, and no personal data is interchanged. -- David S. Crampton On Fri, 28 Oct 2011 18:20:59 -0700, Brian Barker b.m.bar...@btinternet.com wrote: At 17:58 28/10/2011 +0200, Alexander Thurgood wrote: Le 28/10/11 14:49, Ian Whitfield a écrit : I would be happy to put my DB up

[libreoffice-users] my LO 3.4.3 has no macro recorder

2011-10-19 Thread David S. Crampton
In Calc, there is no Record macro item on the Tools | Macros menu. As workaround, I recorded my simple macro in OOo, saved it into the ods file; opened in LO; works OK. Kind of a house of cards though. How do I add macro recorder to my LO Calc? on Windows XP Pro -- David S. Crampton

Re: [libreoffice-users] my LO 3.4.3 has no macro recorder

2011-10-19 Thread David S. Crampton
Cor, And so it is. Now it's extra cool to be running experimental stuff too! Thank you, David On Wed, 19 Oct 2011 15:05:31 -0700, Cor Nouws oo...@nouenoff.nl wrote: Hi David, How do I add macro recorder to my LO Calc? Tools Options General ... turn on Experimental features (bottom)