Can anybody help me please (in very simple terms) to insert a TOTAL at the end
of a £ column in a report, I have a very simple database consisting of details
of items of stock including a VALUE AT COST field and I simply want to place a
Grand Total at the end of the report.
At one time I used
I was disappointed not to get any responses to my earlier cry for help (3rd
October)as I thought it was a fairly simple problem (except to me!) Perhaps I
posted it at a bad time. Anyway, in the hope that somebody may come to my
rescue I have copied the text of my first e-mail below.
"Can
10/11 13:25, Dan escribió:
On 10/20/2011 10:27 AM, John Barman wrote:
I was disappointed not to get any responses to my earlier cry for help (3rd
October)as I thought it was a fairly simple problem (except to me!) Perhaps I
posted it at a bad time. Anyway, in the hope that somebody may co
Since up-dating to OO 3.1 I seem to have lost the icon that normally opens
automatically in the system tray and cant remember how to restore this. I know
theres a reference somewhere in the Tools/Options section. Can anyone help
please.
John Barman
I have made three attempts this morning to install OO 3.3 resulting in failure
- the attached error message preventing the program opening. I have now
uninstalled it and re-installed OO 3.2 which (thankfully) seems OK.
In my many years of downloading/installing numerous versions of OO, this i
e to thank all those involved.
Is it my imagination, but the program seems to open very much faster than
hitherto!
John B
-Original Message-----
From: John Barman
To: users@openoffice.org
Sent: Sun, 27 Feb 2011 11:49
Subject: OO3.3 Failure to install correctly
I have made three att
to a blank
spreadsheet which gives you Columns and Rows as normal.
I dont know if this is any help to others?
John Barman
Message-ID: <[EMAIL PROTECTED]>
Date: Thu, 1 Feb 2007 11:34:00 +1300
From: Paul <[EMAIL PROTECTED]>
To: "Frank Kratz" <[EMAIL PROTECTED]>, u
confusing, but I
expect there is a good reason. Perhaps someone will kindly explain for me!
John Barman
Hello Jim/
I remember I had the same problem of opening ezm files when I first subscribed
- the simple answer was, in file types, to change the ezm files to open with
WordPad instead of Word
John B
Message-ID: [EMAIL PROTECTED]
From: "Jim" <[EMAIL PROTECTED]>
To:
Date: Sat, 27 May 2006 22:
e data. It normally saves and closes OK the second time.
Any ideas please?
John Barman
hasn't had a chance.
I have now carried out a check disk and repair on my drives, so hope for the
best - though from what you explained it sounds promising! Thanks again.
John B
- Original Message -
From: "G. Roderick Singleton"
On Mon, 2006-06-05 at 15:37 +0100, John Ba
I have just downloaded above and have encountered a small problem.
On opening some files I get an error message:
X Error Loading BASIC of document file
///C:/Documents%20and%20Settings/John%20Barman/Application%20Data/OpenOffice.org2/user/basic/standard/script.xlb/:
General Error
General
it with a couple of
clicks, but it seems very odd - and it only seems to have started when I
introduced OO 2.0 to my machine!
John B
From: "John Barman" <[EMAIL PROTECTED]>
To:
Subject: OO 2.0 - Error Message
Date: 23 October 2005 15:48
I have just downloaded above and have encou
Hello All/
Is there any way I can make the default setting for spreadsheet Header/Footer
settings with no entries ? For a single printed sheet I dont normally want
Sheet/Page numbers to print, and I would rather not have to remember to turn
them off every time I print!
Like many others I'm sure,
c.jar' persists in downloading as 'scalc.zip'
(with 300 files in it!) .I have made 3 attempts now but always with the same
result! What is going on here?
John Barman
e: Wed, 04 Jan 2006 18:33:21 +
From: Wangshanpo <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
MIME-Version: 1.0
To: users@openoffice.org
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit
Subject: Re: [users] Calc - missing Help files
John
Hello Uwe & WSP,
Many thanks for this suggestion gentlemen, and I can now report my Help file
seems to be OK
Thanks again
John B.
Hi John
jar files are zipped files and I see that Uwe has since advised you to
rename the scalc.zip as scalc.jar - This should solve the problem.
WSP
x27;t a clue what it signifies!! and cant find anything on this in Help,
FAQ's,etc
John Barman
Message-ID: <[EMAIL PROTECTED]>
Date: Sun, 22 Jan 2006 16:39:38 +
From: Wangshanpo <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
MIME-Version: 1.0
To: users@openoffice.org
Co
up. I have sent a report in.
Is there anything I can do, or is it a bug that is waiting to be fixed?
John Barman
- Original Message -
From: "G. Roderick Singleton" <[EMAIL PROTECTED]>
To:
Cc: "John Barman" <[EMAIL PROTECTED]>
Sent: Thursday, February 02, 2006 12:22 PM
Subject: Re: [users] OO2 not responding
On Thu, 2006-02-02 at 10:47 +, John Barman
OTECTED]>
Sent: Thursday, February 02, 2006 7:28 PM
Subject: Re: [users] OO2 not responding
On Thu, 2006-02-02 at 18:55 +, John Barman wrote:
- Original Message -
From: "G. Roderick Singleton" <[EMAIL PROTECTED]>
To:
Cc: "John Barman" <[EMAIL PROTEC
. Any tips will be very welcome
John Barman
;
To: users@openoffice.org
Message-ID: <[EMAIL PROTECTED]>
Mime-Version: 1.0
Subject: Re: [users] Envelope printing
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
On Thu, 28 Sep 2006 11:08:09 +0100
"John Barman" <[EMAIL PROTECTED]> wrote:
> I have
How do I get the illustrations to show in OO in a scanned document? After
scanning and recognising it was saved in .doc format.
It will open perfectly accurately in MS Word, but in OO Write all the graphics
are missing.
John Barman
; charset=iso-8859-6
Content-Transfer-Encoding: 7bit
On Friday 10 November 2006 01:07 pm, John Barman wrote:
> How do I get the illustrations to show in OO in a scanned document?
> After scanning and recognising it was saved in .doc format. It will
> open perfectly accurately in MS
pared to believe I am doing something wrong, as I dont think
OO development would have reached as far as it has without a problem with this
being spotted before, but at this stage I am completely baffled!
John Barman
t first time as it deals only in numerals,
but it put me on the right track.Thanks again.
John B.
John Barman wrote:
> I have been struggling to make use of the Conditional Formatting facility,
> but as yet haven't achieved an accurate result.
> I have worked, step by step, throug
generate an
error message: "Windows cannot find https:// etc. Make sure you typed the
name correctly and then try again. To search for a file, check the Start button
and then check Search."
John Barman
ent-Transfer-Encoding: 7bit
John Barman wrote:
> I have recently updated my OO programme to the latest stable version
> (2.2.9161)
> I find that none of my existing web hyperlinks now work. Typing the URL
> directly in the Windows Explorer browser works OK, as does the same hyperlink
&
My thanks to all you friends who took interest in my problem. I think I have
accidentally stumbled on the cure myself. I noticed that (probably since
upgrading to IE7) IE had not been checked as my default browser. All seems to
be well now!
John Barman
Message-ID: <[EMAIL PROTECTED]>
Dat
Just as a post-script to this string - Has anyone else noticed that using the
Title case option in the Font effects will only work with text in Lower Case.
If the text is created in Upper Case it wont convert to Title Case. A bit more
flexibility would be useful.
John B
Date: Tue, 9 Oct 2007 0
I have successfully downloaded and installed the above on my WinXP Desktop
machine, but cant seem to install it on my Notebook Vista machine. At a certain
point in the installation process, a message comes up as follows:
"Some files that need to be up-dated are currently in use. The following
ap
4.1 on Vista
John Barman wrote:
> I have successfully downloaded and installed the above on my WinXP Desktop
> machine, but cant seem to install it on my Notebook Vista machine. At a
> certain point in the installation process, a message comes up as follows:
> "Some files that need
Since installing OO 2.3 the normal OO icon in the taskbar refuses to appear at
any time. I think I might have seen threads on this in the past, but I have
never had the problem before, so any remedy hasn't registered with me. I will
be grateful for advice
John B
much more frequent of late.
John Barman
Hello Friends/
While I can successfully insert hyperlinks in a spreadsheet cell, I have a
problem when it comes to removing them. The Help instruction for deleting, says
select the cell and then choose Format - Default, and that's my problem. I find
I cannot select a single cell occupied by
.
- Original Message -
From: "Peter Kupfer" <[EMAIL PROTECTED]>
To:
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, March 06, 2005 8:33 AM
Subject: Re: [users] Open Office Spreadsheets - Inserting/Deleting
Hyperlinks
John Barman wrote:
Hello Friends/
While I can successfull
just brings up a Filter Selection screen which is quite inappropriate
as it has been operating OK in .ods format until yesterday. I can only assume
something has got corrupted somehow.
Has anyone else had this experience?
John Barman
As a new subscriber to Open Office, I have opted for digest lists. I am sure
somebody among you experienced users will tell this new boy (80 year old) how
to read these numbered .ezm files, as I cant get them to open.
Dont seem to be able to get a reply from Open Office admin.
John B.
dpad' and, much to my
surprise it worked!
Thanks again.
John B.
- Original Message -
From: "G. Roderick Singleton" <[EMAIL PROTECTED]>
To: "OOUsers List"
Cc: "John Barman" <[EMAIL PROTECTED]>
Sent: Wednesday, March 30, 2005 6:53 PM
Subject: R
As a comparative novice with OO , I am hoping that someone will tell me how to
create a query criteria in a field that will achieve a filter result like Lotus
Approach "contains the character(s)"
For example, in my Address Books I have a field entitled 'Categories'. A
contact may be given sever
Hello friends/
A most peculiar thing has happened in one of my spreadsheets (that was
originally converted from Lotus 1-2-3). Anything that I enter in a cell that is
number formatted , changes colour from the normal black setting to, in most
cases, a blue font. I say "in most cases" as number e
Further to my last posting on this subject - I have now done a lot more
checking, and it would seem I have completely lost control in Open Office of
formatting the entry colours in all spreadsheets (including new ones). I have
been right through all the various menus, and where possible have ens
Joe Conner has solved my problem for me - so thanks Joe. How and when the Value
Highlighting box came to be checked, I'll never know, (though I know I must
have done it myself!) but I have certainly learned something.
John B
I do seem to be getting odd things happening (probably due to my own fault!)
I hadn't explored the Calc - Options feature very much until recently. I find
that when going down the items, I will get to about "Sort Lists" where it
throws up an error "Invalid Increment" This happens in all the othe
59-1; format=flowed
Content-Transfer-Encoding: 7bit
Subject: Re: [users] Calc - Options
John Barman wrote:
I do seem to be getting odd things happening (probably due to my own
fault!)
I hadn't explored the Calc - Options feature very much until recently. I
find that when going down the ite
ormat=flowed
Content-Transfer-Encoding: 7bit
Subject: Re: [users] Calc - Options
John Barman wrote:
> I omitted to say in my last posting, that I now have OO2 Beta and use
> WinXP SP2
> John B
There are many "beta" of 2.0. You should download the latest once,
1.9.93 and see if the
Thanks to all for guidance on how to download the above version.
This I have now done and installed it on my system. I regret to say however,
that the problem is still there.
I will try to explain it again.
If I have a spreadsheet open, and from the menu I go to
Tools-Options-OpenOffice.org Calc
ontent-type: text/plain; charset=us-ascii; format=flowed
Content-transfer-encoding: 7BIT
Subject: Re: [users] OO 1.9.93 Options - Calc
John Barman wrote:
> If I have a spreadsheet open, and from the menu I go to
> Tools-Options-OpenOffice.org Calc - then select
> "General"-"
?
John Barman
tter very much, of course, but I am sure there
must be an explanation. I am using OO 1.9.100, and am very pleased with it in
most respects.
John Barman
t
Subject: Re: [users] Calc-Autocorrect
John Barman wrote:
> I have just noticed. what seems a peculiar thing, in the Autocorrect facility
> i.e. With a spreadsheet open and Autocorrect selected, the 'Replace' box at
> the top is blank, and the 'with' box shows the
at I meant by the user having more control over this feature- i.e. at
least having the option to turn the feature on or off.. (I could not see
anything in the Tools-Autocorrect window that could apply to these
circumstances)
John Barman
From: "G. Roderick Singleton" <[EMAIL
PROTECTED]>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Subject: Re: [users] Calc - Autocorrect
Hi John,
On Sat, Jun 04, 2005 at 12:23:13 +0100, John Barman wrote:
> An example of what I mean in more detail, is if I have a cell
> in a spreadsheet formatted 'text'
times each number
occurred (Useful in Lottery forecasting - but alas with not much success for
me!!)
I was wondering if any macro covers this, but not being very familiar with
macros I have not ventured to explore this in OO!
John Barman
I seem to have encountered a problem with creating an OO database from existing
spreadsheets. As far as I can remember with earlier builds of OO it worked OK,
but with 1.9.100, and now with 1.9.113 the table refuses to open. Connecting to
my .dbf files works OK, but not to Excel or OO .ods sprea
disk space! So many thanks to you
and your colleagues, and keep up the good work!
John B
- Original Message -
From: "G. Roderick Singleton" <[EMAIL PROTECTED]>
To: "John Barman" <[EMAIL PROTECTED]>
Cc: "OOUsers List"
Sent: Monday, July 11, 2005
eader
formatting wont remain for all pages when printing - the first one is lost!
Also, after a while, if going into design mode to edit it, instead of going
back to the normal edit view of Header and first line data, it will show all
the data
John Barman
it it.
Good wishes
John B.
- Original Message -
From: "CPHennessy" <[EMAIL PROTECTED]>
To:
Cc: "John Barman" <[EMAIL PROTECTED]>
Sent: Friday, September 02, 2005 11:03 PM
Subject: Re: [users] OO2 BETA - Base
On Friday 02 September 2005 11:25, John Bar
Having gone to the knowledgbase to find out how to enable the Thesaurus, as a
non-expert in computing, I find myself baffled by the instruction "Edit the
file - dictionary.lst." How, does one open this file for editing please?
John B
Sorry folks - please disregard my last question! I've just figured out how to
do it!
John B
I know this is not exactly an Open Office question, but I am sure somebody can
answer this one for me. On a lot of Web Sites I visit, I cannot access a lot of
links that appear to be Java script - and I get an 'Error on Page' message. Not
knowing the first thing about Java and what it does, and
g properly. I have JavaScript enabled in both IE and
Firefox but still occasionally encounter pages that report JavaScript
errors.
Sometimes it's the scripts themselves that are to blame.
--
Walt Campbell
atypicaluser (at) gmail (dot) com
On 10/14/05, Dan Lewis <[EMAIL PROTECTED]> wrote:
63 matches
Mail list logo