I need to create a macro in oCALC.
This macro - I have in VBSCRIPT allready and works perfectly in Excel. This is what it does:
All of the following files are located at \\aragorn\Phx\W...
I am considering converting two Excel Macro applications to OpenOffice. It seems like the OpenOffice macros generally do what Excel Macros do, but I have read somewhere that they don't do for...
Auto-Input is such an annoying feature in OpenOffice Calc, that I may have to switch back to Microsoft Excel. I know that from Tools > Cell Contents > AutoInput I can disable it, but this isn'...
I am trying to develop a paycheck printing program in OpenOffice. A little snag I have is that I can't figure out how to convert a number ($125.00) into text (One Hundred Dollars and 00/100)....
On one of my clients machine he is not able to open the xl files on double click. but for all other users on that pc can open xl files withou any issue.
Hi experts,
The title says the goal but I think it would be better to explain the needs in wider context:
Our application, written in C++, exports some data into MS Excel .xls format pro...
I have a Stored Procedure in MS SQL Server 2005 that I'm usnig in EXCEL to import data into a spreadsheet.
Not all of our users have EXCEL....most have OPEN OFFICE.
QUESTION: Can OPEN O...
Hello
I need make macro in OpenOffice sheet .ODS file that export (save) this document as pdf (html, txt or cvs) file.
It's important that to save file with name taken from a cell Sheet1.B...
Can someone help me step by step how to trim off the first two characters in a range of cells. It seems like it should be easy to google, but I'm not having any success?
Thanks!
Dear EE members,
I have open an excel file in Star office calc, but the vba not function properly.
How to resolve this issue?
Regards,
Peter
In Open Office Calc:
1. A filter is applied to a set of cells
2. When I try to paste a value in the set of visible cells, the visible as well as the hidden cells are assigned the pasted valu...
I have the following macro for Calc in OpenOffice 3. It converts the open document to csv, and saves the document.
I need to edit this macro so that it saves the file as the original filen...
How can I open a file larger than 65000 rows in StarOffice 8 (Calc), which is equivelant to MS Office Excel. This feature is supported in the new Vista Office. is there any way to open this la...
I have an existing web app written in PHP. I need a way to convert xls files that are uploaded to the server into csv files.
I was thinking I could use OpenOffice calc to do this.
How c...
Can anyone advise as to when the mooted macro converter will be available that will enable VBA to be converted to the Star Calc equivalents?
There was an article (referenced in this area unde...
Hi! I need to copy the clipboard (text content) directly into a variable. I am creating macros on OpenOffice CALC and I dont want to paste to any cell and move from cell to variable. (2 passe...
Hello Gurus,
trying to switch from microsoft Excel to OpenOffice calc.
Version 2.4
I am unable to save a file as excel format and assign a password to it !!
(When I select the Excel Form...
...if i use the same code on a PC without Open Office the macro go in error in:
Set oSM = CreateObject("com.sun.star.ServiceManager")....
To run this code in a pc whitout Open Office is ...
Hi,
I need to create a scheduler to be printed each day, something like this, and I need the date to be that of the day I open the file to print it.
Is it possible, how?
I am using open...
I am suddenly experiencing an issue in which users in a WinXP workgroup are able to simultaneously access & edit .xls spreadsheets stored on a network share. Excel used to lock one user out fr...
I have calendar with 6 rows and 7 columns in a spreadsheet. I want to be able to make the value of any cell in the first row "1" and have all of the following cells increment that number by 1...
I need to search text in a column and rewrite the text to another column in the same row to a certain spec.
for instance...
A3 = 17th Street Market & Deli
I need to rewrite it to A1 (...
