I'm trying to make a selectionlist in NeoOffice (mac osx clone of OpenOffice) from a column with strings. I can make selection lists when in the same column, but I want a reference between a list of cells to another column selection list. How can I do that? Maybe some references? ...
I am generating an HTML table full of data. They need it to be an editable spreadsheet though that they can save and edit. I currently have it exactly as they want but as an HTML table, is there anyway I can convert this to an excel spread sheet that they can download? Thanks!! ...
I'm not particularly knowledgeable about spreadsheet wrangling, so I could use some assitance with a seemingly simple problem. I have a column of year values which I am sorting by. I'd like to find the quantity per year ( read: number of repeats of each year value ). I'd like to chart said values. I'm not sure how to make this happen. I...
I am using functionality that creates an Excel spreadsheet in my application. It is achieved using the ExcelPackage DLL or the Microsoft Excel COM DLL. I want something to hold hyperlink collections in a cell. Is there is any way to achieve this? ...
Am I completely off-track to think about using Semantic MediaWiki to store (and organise, report on, etc.) 'tabular' data such as financial transactions or weather readings that would usually live in a spreadsheet or database? It seems that one would need a separate, tiny, page for each tuple; but then, that's by design and perhaps it's...
I am trying to query an .xls spreadsheet with VBScript, but I have run into an issue when trying to cast a field. I connect to the spreadsheet like this. Set objConnection = CreateObject("ADODB.Connection") objConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DataSource & ";Extended Properties=""Excel 8.0;HDR=No;"";" ...
hello, i want to ask a question related to MS Excel. I have an excel sheet containing website addresses. The records counts nearly 3000. Now i want to filter it so that duplicates can be removed but the problem is that many web addresses (almost 2000 or so ) in my excel sheet start with httpfor example "http://www.google.com" and the r...
I have an Excel sheet and am able to convert it into .csv format using Perl. My only problem is that some of my data in the Excel sheet cells contain commas and that has to be retained in the CSV format also, but while converting it takes as a seperator. How can I retreive the data in the cell with commas as it is and print it in the ...
I've been given a task to convert a simple spreadsheet to a HTML form to be used on a website, that is going to do some calculations using JavaScript. This would be no problem at all except I know nothing about financial functions, and I've ran into FV (Future Value). This is the spreadsheet: B3 = 100 B4 = 10 B5 = B4*12 B6 = 12 B7 = 3 ...
I am using Open Office's spreadsheet program and am trying to concatenate several text cells together with delimeters. For example, suppose I have the cells below: +--------+ | cell 1 | +--------+ | cell 2 | +--------+ | cell 3 | +--------+ | cell 4 | +--------+ | cell 5 | +--------+ I would like to concatenate them with delimiters s...
has anybody found a library that works well with large spreadsheets? I've tried apache's POI but it fails miserably working with large files - both reading and writing. It uses massive amounts of memory leaving you needing a supercomputer to parse or create a 20+mb spreadsheet. Surely there is a more memory efficient way and someone ha...
Hi All, Can any one guide me how to search a particular cell data in column of 100 records (in Google spreadsheet) using the code of Google app engine. It very urgent please let me know how can I solve this issue. Ref: http://code.google.com/apis/spreadsheets/data/1.0/developers%5Fguide%5Fpython.html#addRow Regards SKSK ...
I have a worksheet with a large number of cells containing large amounts of text. Within any particular cell there may be some text that is coloured red. I want to remove that text and copy it to a different column. I have a VBA function that does this by checking the cell contents character by character but the spreadsheet is quite lar...
i want a user to have file picker and then choose a spreadsheet which will then be parsed by a controller action. are there any examples of how to do this? ...
Two columns: Column A contains a complete list of available journal titles; Column B contains the ones to which my library already subscribes. Is it possible to delete entries from Column A if they also appear in Column B? In other words, I want to 'dovetail' two columns so that no entry is represented in both columns. Any help will ...
I'd like to know if there exists a spreadsheet application which uses an existing functional-programming language to define functions. I've already heard about Resolver One which uses python, but I'm more interested in anything which uses a purely functional language like Haskell. Thanks ...
Is Google Spreadsheets / Docs a viable database option for real-world applications? ...
Why are programs like Microsoft Excel, Gnumeric and OpenOffice.org Calc designed with hard-coded limits on the number of rows and columns? This seems like an archaic programming technique from when spreadsheets were considered a demanding application and dynamic memory allocation was considered "high-end". I would guess that it indicat...
What tools are available to convert an OpenOffice or Excel spreadsheet (with all its formulas) into a Java object that can be called at run-time? Obviously this would only make a calculation engine and just be about numbers and text, not timing or API calls. Even with named cell ranges being used to (effectively) name variables the out...
Hello, I'm searching for a free, open-source if possible, Java swing library that improves the existent JTable (which is very simple). I want to do an application with a spreadsheet similar to Excel one. Without the formula but with copy/paste functionalities (multiple paste if multiple selection), column reorganizing, etc... I've fou...