I lost my installation of Dave Gillespie's calc.el by reinstalling Cygwin. It is not included with the default Cygwin install of Emacs. Who is considered the master maintainer these days? Is version 2.02f still most current? ...
Hi! In Calc I set a cell value to "2006/10/03 13:33:55.448" and Calc says it is Standard format. I'm doing this with Java and I want to set the format to "DD.MM.YY HH:MM:SS AM/PM": XNumberFormatTypes xFormatTypes = (XNumberFormatTypes) UnoRuntime.queryInterface(XNumberFormatTypes.class, xNumberFormats); int myDateFormat = xNumberFormat...
I am writing an OpenOffice calc add-in that returns a range of strings: public String[][] myFunc(int v0, com.sun.star.table.XCellRange v1) When I try to use the function in OpenOffice and set a cell's value to =myFunc(0;A1:B1) Only the first value returned by myFunc is shown as the value of the cell. How can I make the value appear...
I'm interested in creating one or more spreadsheet graphs of interval metered data. The raw data is recorded as a continuously increasing value (i.e. total bytes, user logins, website hits) and date. Each sample measurement date will happen at a non-constant interval. For simplicity I would like to record the data in a spreadsheet progra...
In OOo Calc I need to copy a column (only the values, not the format) from one sheet to another (in the same worksheet) using a macro assigned to a button. I browsed a bit around but found nothing significant :-( ...
For document exchange, I would like to generate OpenOffice.org text and spreadsheet documents. So far I have found export components which require OpenOffice to be installed, using OLE. Are there already Delphi components available which can write native files for OpenOffice.org Writer or OpenOffice.org Calc? ...
Hi, I would like to be able to automate data entry to an Open Office spreadsheet using a PowerShell script, in the same way that Excel can be automated using PowerShell (see this Scripting Guy example). Is this possible? Thanks, MagicAndi ...
Hi, I'm trying to calculate F-scores (using the formula 2 * a * b / (a + b)) in OpenOffice.org Calc, and would like a and b to be the previous two cells in the same row. My problem is that while trying to define a function in OpenOffice.org Basic, I get an error that the ADDRESS and INDIRECT methods aren't defined. How would you defin...
How can I convert hexadecimal to decimal numbers in Emacs calc? For example, if I enter FF, I want it to convert it to 255. UPDATE: How do I get the reverse operation, turn base 10 to base 16? ...
How do I read in the following input in my RPN calculator so that it will find the operator no matter what order? 2 2+ 4 As of now my scanf only sees the first char in the string and I can only do this: 2 2 + 4 I'm also trying to add an option for integer vs floating point mode. (ex. when 'i' is entered, operate in floating point a...
i came across this page CSS LINK i could't help but love the idea of that to calculate the outcome of different units... however i tried this : $('selector').css({'width':'calc(100%-20px)'}); but it doesn't work... anyone has any ideas how this works , or why doesn't this work? ...
The generated code when I make macro recording when I change language (to Spanish for example) does not work in OpenOffice Calc. It does work in OpenOffice Write. Which function calls shall be used in a OpenOffice Calc Macro to change the lanuage in the marked cells? ...
This code is works fine when you type 22 and 56 for example, it shows you the correct result import java.util.Scanner; class apples{ public static void main(String args[]){ Scanner villy = new Scanner (System.in); double fnum, snum, answer; System.out.println("Enter first num: "); fnum = villy.nextDouble(); S...
Is there a way to use an org-mode table to do automatic unit conversion? I cannot get it to work. What I wanted to do is using a simple table where i can input some weights in ounces and let emacs convert them into gramms. |---------+---------------| | 100oz | ??g | | 50oz | ??g | |---------+---------------| #+...
Hello could someone please help me with the following, I try to create an OpenOffice calc chart using the OOoTools.pas interface. The code is this: /////////////////////////////// CODE ////////////////////////////////// procedure TForm1.ProcessChart(aFilename : String); Var oTheFile, oAllSheets, oMySheet, oCharts, ...