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

2019-12-25 Thread David S. Crampton
ename 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: user

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

2019-12-25 Thread David S. Crampton
und 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-he

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

2012-10-07 Thread David S. Crampton
you 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 U

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

2012-10-05 Thread David S. Crampton
;stylistic" 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-

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

2012-10-03 Thread David S. Crampton
is should be a very simple SQL statement. It does absolutely 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&#x

[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

[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
only 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-f

[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
ant by xmlns? David - -- 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 unsub

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 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 Secretary, I was

Re: [libreoffice-users] Re: LibreOffice Portable

2011-12-14 Thread David S. Crampton
6.0.1367, 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 wrote: M R

Re: [libreoffice-users] Re: LibreOffice Portable

2011-12-14 Thread David S. Crampton
ling list 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/Netiquett

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

2011-12-14 Thread David S. Crampton
businesses 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 wrote: On 12/14/2011 10:18 AM, Caesar wrote: On Wed, 14 Dec 2011 10:0

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

2011-12-12 Thread David S. Crampton
help to you, -- David S. Crampton On Mon, 12 Dec 2011 06:39:31 -0800, Hylton Conacher (ZR1HPC) 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 instanc

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] Identifying the correct row in Spreadsheet formulas

2011-12-09 Thread David S. Crampton
ed combinations 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 wrote: Hi All I have a spread sheet in LO 3.4.3 where I record and analyse monthly num

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

2011-12-05 Thread David S. Crampton
from the beginning. -- David S. Crampton On Mon, 05 Dec 2011 06:08:46 -0800, relgames 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 up

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

2011-12-03 Thread David S. Crampton
ave #VALUE result when combining a null string and a numeric but gives a numeric when combining a 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. Cr

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

2011-12-03 Thread David S. Crampton
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] open .odt without updating fields

2011-12-03 Thread David S. Crampton
es 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, wrote: I have a Writer file that has a date field. Is it possible to open the file with the date field displaying the

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

2011-11-26 Thread David S. Crampton
at's what puts you in business! Good luck, David S. Crampton On Sat, 26 Nov 2011 09:11:52 -0800, Bob Houston 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 b

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 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++ process and

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

2011-11-21 Thread David S. Crampton
yPosition(0,0).setValue(x)". 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 wrote: 2011/11/21 David S. C

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

2011-11-21 Thread David S. Crampton
irsta Case 1 args1(0).Value = "1" Case 2 args1(0).Value = "2" Case 3 args1(0).Value = "3" Case 4 args1(0).Value = "4" End Select dispatcher.executeDispatch(document, ".uno:EnterString", "", 0, args

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 environment?

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

2011-11-18 Thread David S. Crampton
aracter 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...@gl

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

2011-11-16 Thread David S. Crampton
ll Python as a self-standing 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"

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

2011-11-16 Thread David S. Crampton
pane. LO v3.4.4 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/Netiquett

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 wrote: Thanks for the report of the error. This is a good place to put it if you have not signed

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

2011-11-09 Thread David S. Crampton
iour, 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/g

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

2011-11-09 Thread David S. Crampton
ehaviour?" is very worthy. Some will like the "My Documents" paradigm; me, not so much. 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,

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

2011-11-07 Thread David S. Crampton
languages. 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 unsubscr

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

2011-11-05 Thread David S. Crampton
similarly edited. Pain! I did an amateur's search of Bugzilla prior to writing this. Hundreds of "define" results but not on this AFAIK. If no clues come from Users forum I will post as new bug. Regards -- David S. Crampton -- For unsubscribe instructions e-mail

Re: [libreoffice-users] flip columns in calc

2011-11-03 Thread David S. Crampton
s as columns 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 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

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 wrote: David S. Crampton wrote: I don't think the "bugs" descr

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

2011-11-01 Thread David S. Crampton
08 -0700, Stephan Zietsman 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 wher

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

2011-10-31 Thread David S. Crampton
t;: the 4-keypad "compass set" 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.doc

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

2011-10-28 Thread David S. Crampton
b could be populated, fully functioning, and no personal data is interchanged. -- David S. Crampton On Fri, 28 Oct 2011 18:20:59 -0700, Brian Barker 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 for examina

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

2011-10-28 Thread David S. Crampton
quot;starting point". Thank you for an orientation, -- 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.documen

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 wrote: Hi David, How do I add macro recorder to my LO Calc? Tools > Options > General ... turn on Experimental features (bottom) Restart ... There

[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