Pages

Search

Open Office - [discuss] excel->oocalc incompatibility leads to grading "gotchas"

Open Office - [discuss] excel->oocalc incompatibility leads to grading "gotchas"


[discuss] excel->oocalc incompatibility leads to grading "gotchas"

Posted: 19 May 2006 03:24 PM PDT

Hi Brian

I'm sorry about the problems you've had, and I'm glad (for you and the =

students) that you discovered the lower marks before it was too late.

You seem to be making three main points, that I'd like to comment on.


1. SOME CALC FUNCTIONS DIFFER FROM EXCEL FUNCTIONS
 

While many of the fuctions work the same way in both programs, there are=
=

functions and notation that do differ.

While I wouldn't like OpenOffice.org to be limited to copying Microsoft'=
s =

functions, I think you are making a good point. If you have an Excel =

spreadsheet that works fine in Excel, and you import it into Calc, you =

would normally assume that the formulas would give the same answers. =

Either the import process should convert the formulas to the equivalent =
=

Calc formulas, or a warning should be given that some formulas in the =

spreadsheet may give different answers to Excel.

Sometimes there is only a slight difference between the formulas, and th=
e =

answers would usually (but not always) be the same. It may be difficult =
to =

determine just how to convert each formula into Calc. In this case, =

changing MIN to MINA would have been appropriate, but would it always be=
=

appropriate in every spreadsheet? That is hard to know.

I'm sure this has been discussed before. Does anyone have some further =

insight?


2. THIS INCOMPATIBILITY WILL DISCOURAGE MIGRATION
 

I disagree with this point - as long as the people considering migration=
=

understand the issues. There is always a cost in migration, and usually =
a =

big part of that cost is learning to do things a new way.

I don't know how many different spreadsheet programs I've used since the=
=

DOS days. It's probably somewhere between 10 and 20. All of them deal wi=
th =

many functions in different ways.

Same goes for word processing. I used to know every function key =

combination for WordPerfect 5.1, and it hasn't helped me one bit in any =
=

word processing program. They all have different features, key =

combinations and menu structures.

But that's the great thing about OpenOffice.org. It's cross platform. Ge=
t =

to know it in Windows, and you can use it in Linux. Possibly that's a =

starting point when talking to your friends - get them to consider =

changing to OpenOffice.org and Firefox, and talk about Linux when they'v=
e =

made that change.

In fact, if you'd created your spreadsheet in OpenOffice.org for Windows=
, =

you wouldn't have had a problem using it in Linux.

In case I wasn't clear, my point is that once people migrate to =

OpenOffice.org, they will be making Calc spreadsheets with Calc formulas=
, =

not Excel spreadsheets with Excel formulas. This situation won't happen =
=

(except for possibly temporarily during the migration).


3. EXCEL'S USE OF THE MIN FUNCTION IS SUPERIOR
 

I appreciate the IMHO, and understand everyone's preferences are differe=
nt.

I don't have a strong preference here, as long as I know how the functio=
n =

will work.

But I did do a quick search in Google, and found quite a few faq's and =

tutorials explaining how to get around the way Excel does MIN. It seems =
=

that a lot of people get a minimum value of 0 when they weren't expectin=
g =

it. A blank cell somewhere was mucking up their expectation of the resul=
ts.

But everyone's different.


Thanks for your honest email, Brian. I think you're main point was numbe=
r =

1, and I think it's fairly valid.

Does anyone have suggestions of a helpful way forward?

Adrian




-- =

Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

[discuss] Feature Idea!

Posted: 18 May 2006 01:43 AM PDT

On Thu May 18 2006 01:54, + Rosana Mayer-Conroy wrote: 

What happens if you want to insert a "/" character in your text ?
Anyway it is already there by using Ctrl + F.

Also you can configure all of your keys to functions in "Tools" -> "Configure
-> Keyboard.

Please reply to org only.

Normally org is the best list to ask questions about using
OpenOffice.org

--
CPH : OpenOffice.org contributor

---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

[discuss] Surprised this hasn't been on here already but....

Posted: 17 May 2006 11:38 AM PDT

Chad Smith wrote: 
 

http://en.wikipedia.org/wiki/Vaporware - that is, until a release date
is announced.
and the specific license is important, even if it is an Open Source
license, it is not necessarily compatible with the license used by OOo.
 

I had read the article at least one day before you posted the link

--
nicu
my OpenOffice.org pages: http://ooo.nicubunu.ro
Open Clip Art Library: http://www.openclipart.org
my cool Fedora wallpapers: http://fedora.nicubunu.ro/wallpapers/

---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

[discuss] Surprised this hasn't been on here already but.... SUN HAS OPEN SOURCED JAVA

Posted: 17 May 2006 09:38 AM PDT

------=_Part_42448_10086614.1147976840063
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On 5/18/06, Nicu Buculei <ro> wrote: 

Here's the direct quote from the article that I linked to in my original
email:

Sun Microsystems Inc. will make its Java software available on an 

When a company announces that they will make something open source - they
have, in effect, made it open source. So both terms are correct.

More quotes:

"We want to grow our revenue as much as possible, and that starts with 

ill 
So, if you had simply read the article, (which is why I bothered to link to
it), you would have been able to save your time and mine waiting for an
answer.

--=20
- Chad Smith
http://www.gimpshop.net/
http://www.whatisopenoffice.org/
http://www.chadwsmith.com/
Got an Intel Mac Mini? Want one?
http://minimacs.freepay.com/?r=3D29227644

------=_Part_42448_10086614.1147976840063--

[discuss] Improving Impress

Posted: 16 May 2006 01:08 PM PDT

Here is a question related to this: there are many sites online that offer
templates and clipart for OpenOffice.org. Rather than including clipart and
template and such that bloat the installer file size, why not create a place
at the www.openoffice.org website that contains these, that users can upload
content to?

I hate to use Microcrap as an example again, but they have a similar service
at http://dgl.microsoft.com that contains clipart, templates, borders, sound
clips, pictures, etc. Could such a service be created at www.openoffice.org
for the OpenOffice.org suite, but also include the ability to have users
upload content? Maybe allow downloads to anyone, but uploaders must create
an account to upload, for tracking info and such?

This would provide a central location for such material, instead of having
to search it out from the myriad of sites that offer portions of such a
service.

Thoughts, comments and ideas?


Sincerely,
Andrew Robertson
derma e(r) Natural Bodycare
Export Manager
Ph. 805-582-2710 xt. 244
Fx. 805-582-2730
net
www.dermae.net

-----Original Message-----
From: Alexandro [mailto:com]
Sent: Tuesday, May 16, 2006 3:52 PM
To: org
Subject: Re: [discuss] Improving Impress

Yes this has been brought before, a big difference is that StarOffice is
distribute on a CD so the inclusion of ClipArt don't really hit the file
size or bandwith.

On 5/16/06, Paul William Brown <com> wrote: 


--
Alexandro Colorado


---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

[discuss] RFE

Posted: 16 May 2006 01:17 AM PDT

On Mon May 15 2006 17:25, + Mats Broberg wrote: 

Hi Mats,
Yes we would. You probably also want to subscribe to this mailing list to see
replies. You can subscribe to this list by sending an email to
org and reply to the confirmation request email.

Please reply to org only.

Normally org is the best list to ask questions about using
OpenOffice.org

--
CPH : OpenOffice.org contributor

---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

[discuss] Installing British Language Module

Posted: 16 May 2006 01:14 AM PDT

On Tue May 16 2006 03:39, + Chris Hill wrote: 

It is available thru "File" -> "Wizard" -> "Install Dictionary".

Please reply to org only.

Normally org is the best list to ask questions about using
OpenOffice.org

--
CPH : OpenOffice.org contributor

---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

[discuss] Word Templates in OO

Posted: 14 May 2006 09:28 AM PDT

Alexandro wrote:
 

Fortunately you are wrong. :-)
The wizard has a checkbox on its second page where you can select if you
want to convert documents, templates or both.

Best regards,
Mathias

--
Mathias Bauer - OpenOffice.org Application Framework Project Lead
Please reply to the list only, de is a spam sink.

---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

[discuss] File association

Posted: 13 May 2006 07:59 PM PDT

Am Sonntag, 14. Mai 2006 15:00 schrieb DPH: 

On the www.openoffice.org site > support, then the third link on the left.

Guido
 

---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

[discuss] Question on the Futur of "portable openOffice"

Posted: 13 May 2006 07:59 PM PDT

------=_Part_44231_29990424.1147826982106
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Best way is to ask the developer of portable openoffice.org --- John Haller=
,
also remember that 2.0 version is bigger than the original P-OOo
http://portableapps.com/apps/office/suites/portable_openoffice

you can contribute to the project so you can get ur language developed.

On 5/14/06, KAMI <com> wrote: 

le 
t! 


--=20
Alexandro Colorado

------=_Part_44231_29990424.1147826982106--

[discuss] OpenOffice Writer: Latin text rendered in Asian font

Posted: 12 May 2006 03:26 PM PDT

Thanks. But what you typed as "?? " should actually be two spaces
in a row.

CPHennessy 提到:
 

---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

[discuss] Memory usage and characters

Posted: 11 May 2006 10:55 AM PDT

On Thu May 11 2006 11:17, + Henk Ursinus wrote: 

As you are not subscribed you may not have seen that:
On Sun May 14 2006 20:15, Mathias Bauer wrote: 

Please reply to org only.

Normally org is the best list to ask questions about using
OpenOffice.org

--
CPH : OpenOffice.org contributor

---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

[discuss] Annoying bug: suggestion

Posted: 11 May 2006 10:55 AM PDT

On Thu May 11 2006 14:37, + Nicolas Therrien wrote: 

Hi Nicolas
As you are not subscribed you may not have seen that:
On Fri May 12 2006 01:47, Richard wrote: 

Please reply to org only.

Normally org is the best list to ask questions about using
OpenOffice.org

--
CPH : OpenOffice.org contributor

---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

[discuss] Possible OO component to do Publisher functions

Posted: 10 May 2006 10:34 AM PDT

On Wed, 2006-05-10 at 07:58 -0500, Donald E Cochron wrote: 

Not as far as I know.

However, the "Draw" component of OOo (OpenOffice.org) can be used for
simple desktop publishing. If you need something more advanced than
publisher, then install "Scribus" from http://www.scribus.net

If you only use Outlook for email & calendar, then Mozilla Thunderbird
and Calendar http://www.mozilla.com/thunderbird might meet your needs.

Hope this helps.

Dave

Please reply to org only.


---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

[discuss] MacIntel User

Posted: 05 May 2006 01:38 AM PDT

On Fri May 5 2006 01:29, + William Charlton wrote: 

Read the doc at :
http://eric.bachard.free.fr/mac/HowTo2.0/Howto_OOo_2.0_MacOSX_english.pdf

And download OpenOffice.org from :
ftp://ooopackages.good-day.net/pub/OpenOffice.org/MacOSX/2.0.2rc4

Please reply to org only.

Normally org is the best list to ask questions about using
OpenOffice.org

--
CPH : OpenOffice.org contributor

---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

[discuss] Visual Basic in OpenOffice.Calc

Posted: 04 May 2006 10:41 AM PDT

Thanks!


----- Original Message -----
From: "CPHennessy" <org>
To: <org>; "Vitaliy V. Dubil'"
<com.ua>
Sent: Thursday, May 18, 2006 8:31 PM
Subject: Re: [discuss] Visual Basic in OpenOffice.Calc

 
in 
are 
are 
using 

---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org