[discuss] Accounting format for OO calc.

[Aphyr]

It would be useful for accounting and finance to provide a
format where the currency symbol is aligned to the left, and the
amount is shown on the right, with the decimal point lined up. Negative
figures should be shown in red, as with the existing accounting format.
Excel provides the implementation I am thinking of.

For example, the closest I can come is:

| $1,234.00|

But I would like to represent this as:

|$ 1,234.00|

Thanks,
--aphyr

---------------------------------------------------------------------
To unsubscribe, e-mail: discuss-u...@openoffice.org
For additional commands, e-mail: discus...@openoffice.org

[Kohei Yoshida]

On Tue, 2004-06-22 at 20:39, Aphyr wrote:
> It would be useful for accounting and finance to provide a
> format where the currency symbol is aligned to the left, and the
> amount is shown on the right, with the decimal point lined up. Negative
> figures should be shown in red, as with the existing accounting format.
> Excel provides the implementation I am thinking of.
>
> For example, the closest I can come is:
>
> | $1,234.00|
>
> But I would like to represent this as:
>
> |$ 1,234.00|
>
> Thanks,
> --aphyr

Hi there,

This is, in fact, a frequently-asked enhancement request. The request
has been entered into IssueZilla - our database for tracking bugs and
features, but unfortunately it will not make it into 2.0 that is planned
sometime toward the end of this year (knock on wood), simply because of
the lack of developer resources.

If you're interested, here is the link to this request for enhancement
in IssueZilla.

http://www.openoffice.org/issues/show_bug.cgi?id=15773

You could also vote for this request, but that would require an account
for login.

Have a good day,

Kohei

[Martin Lewicki]

Is there a way to create a new database in OO. So far when I go File|Auto
pilot|Report it only allows me to work on the existing default report called
"Bibloigraphy".

Martin

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.707 / Virus Database: 463 - Release Date: 16/06/2004

[Kohei Yoshida]

On Wed, 2004-06-23 at 10:35, Martin Lewicki wrote:
> Is there a way to create a new database in OO. So far when I go File|Auto
> pilot|Report it only allows me to work on the existing default report called
> "Bibloigraphy".

Yes, it's Tools -> Data Sources.

Kohei

PS Please create a new thread for a new question, instead of replying to
an existing, but unrelated thread. That will help us keep all our
discussions well organized. Thanks.

[CPH]

Hi Martin,
Please do *not* start a new question by replying to an old one as this causes
several problems:
1) most email software will correctly think that your email is a response to
the email you are "replying" to, and will indicate this by displaying your
email as a child of the original email
2) because of this, people not interested in the original email may ignore
your question
3) people may think that the original email has a reply(yours) so that they do
not have to give it a reply
So in conclusion, more people will read your email if it looks like the start
of a new thread rather than the reply to an old one.

On Wednesday 23 June 2004 15:35, Martin Lewicki wrote:
> Is there a way to create a new database in OO. So far when I go File|Auto
> pilot|Report it only allows me to work on the existing default report
> called "Bibloigraphy".

As well as the other answer, please have a look at
http://user-faq.openoffice.org/#FAQ or http://dba.openoffice.org

--
CPH : openoffice.org volunteer

Maybe your question has been answered already?
http://user-faq.openoffice.org/#FAQ

Also please reply *only* to us...@openoffice.org, as your responses will
be answered more quickly, more correctly, and shared to help more people.