For example i am able to get the feed from the spreadsheet and worksheet id. I want to capture the data from each cell. How do i do that? I.E i am able to get the feed from the worksheet. Now i need to get data(string type?) from each of the cell to make comparison and for input. How exactly can i do that? ...
So the problem is, i get some information from first column of the row (for example A2 ) from the spreadsheet, then i will do some checking with that information, after that i want to write back to the next column in the row the result, how do i do that? Is there a certain function to allow me to indicate the column behind, in front, abo...
Most of what I need to accomplish is doable with Google docs spreadsheets, except locking only certain fields to allow updates by the public so they can do their own calculations based on the data. I would like the lowest method entry cost of writing simple table data with some functions that allow user update/selection. Free form portab...
I need to build a spreadsheet-like control in WPF with the following features: Frozen columns Frozen rows Cell merge Ability to have arbitrary user controls hosted in a cell with their own data binding targets I do not need any calculation or formatting functionality, so the amazing ClearOffice Excel control is overkill for my needs ...
I'm creating Excel files in a PHP project. Those files aren't just CSV data... They are multiple tabs spreadsheets with functions and formatting. So far I'm using the Spreadsheet_Excel_Writer class that is provided with Pear. Everything is fine but our users don't like 2 things: When they open those files generated by PHP, modify the...
I've volunteered with a Non-Governmental Organization to help with their record-keeping at their community centre. At present, there is only one community centre where all their data is stored. However, this is expected to change by the end of the year. Presently their data is maintained using a workbook with two sheets. Each record in ...
This is linked to my other question when to move from a spreadsheet to RDBMS Having decided to move to an RDBMS from an excel book, here is what I propose to do. The existing data is loosely structured across two sheets in a work-book. The first sheet contains main record. The second sheet allows additional data. My target DBMS is my...
I'm just wondering if this is possible, and if not, the best way to set up event handlers to make this happen... If I have a spreadsheet-like HTML table like so: <table> <tr id="row1"> <td><input type="text" class="number" value="1"/></td> <td><input type="text" class="number" value="2"/></td> <td><input type="text...
On a spreadsheet, based upon the content in column A, the correct range must be selected from the content in B. A = 1 h, 2 h, 3 h, 4 h ... 23h, 1d ... 1 w, ... 1m, ...1 y, 2 y ... 15 y B = 0-2yr, 2-5yrs,5-10yrs,10-15yrs,>15yrs At present, the data in both columns is entered manually. I'm in the middle of defining both as a list to mak...
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? ...
I want to know if PHPExcel can: Create Excel spreadsheets with embeded image. The image must be compressed (jpeg, png, gif...). Create Excel spreadsheets for different Excel versions (2000, 2003, 2007...). I'm pretty sure it can do this but I can't find it in the official docs. Anyone familiar with this class can help? Thanks! ...
Is it possible to nest simple programs within a Google doc spreadsheet, similar to how you would w/Basic in Excel? Or alternatively a simple = syntax using regex, if there is a way to do that in google docs? I want to take a list of multiple names(name1, name2, name3) in a single cell from across multiple identical sheets and transpose ...
Guys & gals, What's a best-in-class Rails option for importing/exporting spreadsheet data? Preferably w/o requiring an intermediate conversion to/from .CSV? I see several options, but no clear preference (thus far). Ideas? Thanks & regards, Brian Piercy ...
If I create a Google apps script, can I hook it up to Google spreadsheet to run based on an event, or must I manually invoke it? I don't know if Google spreadsheet supports any events. For example: a Google app script that strikes out rows in the spreadsheet that have been marked completed by way of a column having the digit 1 beside c...
I want to make a table that displays on a webpage, but one requirement is to make it easy to copy and paste into a spreadsheet. Normal HTML tables selection behavior is obviously different from how a spreadsheet like Excel selects -- when you select multiple rows it wraps around instead of selecting a rectangular area. Is there any way...
In FarPoint SpreadSheet ver 7 - How to apply .Formula property at SpreadHeader+1 ? .That is second Header of the Spread. We can apply .Formula property at SpreadHeader + 0.That is Top Header. I use the following code, With fpSpread1 .Row = SpreadHeader + 0 .col = 1 .CellType = CellTypeNumber .Formula = "SUM(A1:A10)" End Wi...
I am trying to build a Google spreadsheet synchronization feature on a blackberry application that I am building. Not being a pro I was hunting for some sample code to get a grasp of the flow but I could not. When I am using the API from Google to access spreadsheets, it suggests to use the SpreadsheetService class. try{ Spreadsheet...
Hey any body know how to hide cell contains using spreadsheet gear. ...
I have a Google Docs spreadsheet for tracking my weight. I have two columns: Date and Weight. While the goal is to have the weight column sorted in descending order, that doesn't always happen in reality... ;-) The data essentially looks like this (weights changed to far lower values, of course): Date |Weight 04/01/10|195 04/02/1...
Hi, When importing an excel spreadsheet in Sharepoint, the following error pops up in a web dialog with the following message-"Automation server can't create object". What is wrong? does office needs to be installed to import spreadsheets or will installing the primary interop assemblies for Office fix this issue. Thanks ...