Pages

Search

Open Office - [discuss] Calc/Excel macros being broken

Open Office - [discuss] Calc/Excel macros being broken


[discuss] Calc/Excel macros being broken

Posted: 12 Aug 2010 10:44 AM PDT

On 12/08/10 19:33, Johnny Rosenberg wrote: 
Thanks Johnny. This raises two questions:

1 - How easy would it be for the Calc 'save as XLS process' to convert
OOo Basic to VBA? If Calc can import VBA and interpret it, it seems at
least theoretically possible but I don't know of the practicalities or
knock-on side effects.

2 - What is the technical reason for the ODF specification not including
macros, but leaving them up to the vendor to decide upon?

From the answers to these come the issues of:
- "What do we do about organisations who are in the middle of a
migration between Calc and Excel, but the need for Macros prevents users
who have switched to Calc from sharing data with users still on Excel
(or vice-versa)?"
- "What about organisations who, for mission-specific purposes, have a
mixture of Excel and Calc and whose legacy Excel macros are causing
problems?"

Best wishes,

Clarke

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

[discuss] FORMAT SETTINGS HELP

Posted: 10 Aug 2010 06:52 AM PDT

On 13/08/2010 15:26, Sandy Smith wrote: 
Sunita

To find the version of OpenOffice you are using look at >Help and >about
OpenOffice.org.

The format of the date is controlled by the format.

As an example open a spreadsheet with the date in it and select one cell
containing a date. Select >Format >Cells. A new window will pop up.
Click the tab showing Numbers (if it is not already being shown) and
then look at the Category column on the left hand side - that should
have Date highlighted. Now what are you showing under the language
column. I think you need to set that to English (South Africa) using the
drop-down menu and then see if the required date formats are available
as shown in the format column in the middle. Select the format and then
click OK and the cell should show the correct format. You can then
select as many cells containing dates to be the correct format.

Hope that helps

Rob

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

[discuss] Links in cells in Calc

Posted: 02 Aug 2010 01:17 AM PDT

OK, thanks anyway!



Jean-Jacques VASTIAU

be


An opinion should be the result of thought, not a substitute
for it.

-- Jef Mallett, Frazz, 04-04-07


-----Original Message-----
From: Tony Pursell [mailto:fsnet.co.uk]
Sent: 02 August, 2010 11:38 AM
To: org
Subject: RE: [discuss] Links in cells in Calc

On Mon, 2010-08-02 at 11:09 +0200, J.J. Vastiau wrote: 

Highlight the hyperlink text, navigate to Insert > Hyperlink (or click on
the Hyperlink icon in the tool bar), drag the highlighted text into the
Target box (if it is an Internet address), click Apply.

By the way, org is a general discussion list. For this
sort of question you should subscribe to org and ask
questions there.

Tony


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

[discuss] print dialogue limitations under ubuntu

Posted: 30 Jul 2010 10:50 AM PDT

Mike Scott schrieb: 

There will be an new printer dialog in the upcoming version 3.3, please
try it. http://download.openoffice.org/next/

Kind regards
Regina



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

[discuss] How can I bring in new ideas?

Posted: 25 Jul 2010 09:07 AM PDT

On 07/25/10 18:07, Frank Hummel wrote: 

On Windows? Select both windows in the task bar (using the Ctrl key),
then use "Tile Vertically" from the context menu of the task bar entry.

Niklas

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

[discuss] Webdesign / HTML Editor

Posted: 21 Jul 2010 11:59 PM PDT

On Jul 22, 2:59*am, de ("Lars Zimmer") wrote: 

Altho not from Mozilla, I use Kompozer which is free and open source.

I used it to create
www.Queensbridge.us
there are many YouTube videos about it

[discuss] Some idea !

Posted: 20 Jul 2010 01:35 AM PDT

-------- Original Message --------
From: Adam <com>
To: org
Date: Fri, 23 Jul 2010 19:15:38 +1000 
There is a limit to how much information can be packed into the internal
help function. More detailed information is provided by the "Getting
Started" and "User" guides, available for download and on-line viewing
from the "Documentation Project": http://documentation.openoffice.org/

I would also like to take this opportunity to mention that the "Authors
Project", who produce the guides, are one of the most active and hard
working areas of the OOo project and congratulate Jean Hollis Weber
(Authors Project Lead and Documentation Project Co-Lead) on her tireless
efforts to improve and expand the OOo documentation.

Dave


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

[discuss] Personal invitation from Marius Popa

Posted: 15 Jul 2010 12:56 AM PDT



Hi,

On 7/15/2010 3:51:21 AM, you were invited to join Marius Popa's UNYK address book so he/she would always have access to your contact info and you to his/hers.

To accept his/her request, Click here.
http://www.unyk.com/ml/65/5/?i=199652C122CB48269D49977AB39D03F1&s=19542766&w=1 280029078



UNYK is a smart and simple way to manage your contacts so you never lose anyone's contact information again.

No more worrying about your contacts' info. From now on, let them do it for you. By changing their information in UNYK.com, you address book will be automatically updated. By changing your information in UNYK.com, their address book will be automatically updated.

It's so simple and it's free... Already 30 million users.



Please do not reply to this email. Questions ? Contact us - http://unyk.com/en/Contact
UNYK Inc., 1010 de Serigny, suite 820, Longueuil, QC, J4K 5G7, Canada.

I no longer wish to receive invitations to join UNYK from Marius Popa: Unsubscribe
http://www.unyk.com/ml/604/235/?mid=9E9AA7A87B7B89A3&email=org&s=19542766&w=12800 29078

I never again wish to receive invitation to join UNYK: Unsubscribe
http://www.unyk.com/ml/65/6/?i=199652C122CB48269D49977AB39D03F1&s=19542766&w=1 280029078



UNYK, the first smart address book that updates itself!