I want to populate some cells given certain condition. The thing is, I have no idea how to do this with just formulas (can’t use macros or the sort).
Long story short, all I\'m really attempting to do is print my reports on half sheets. I had Kinko\'s chop a pack of printer paper in half and my laser printer is perfectly happy to suck them in and p
I need to write a data exploration tool that displays large amounts of data in a spreadsheet format. Salient problem features:
I tried to spool a CLOB to a CSV file using code that looks like below: set pagesize 0 set heading off set long 30000
I have a spreadsheet with data in Apple Numbers.I have a column of dates, and I would like to create a second column which displays the difference in number of days between the two dates.
I have a conditional format in Excel that is displaying the up/down arrows based on certain values. This works just fine. However, in my spreadsheet (which is largely controlled by VBA)the user has th
I have a excel spre开发者_运维百科adsheet that contains a bunch of columns. My first column contains values of mpg(about 300 entries of miles per gallon). What I want to do is populate another column
I\'ve used the GData spreadsheets code for MAC to write a corresponding iPhone version (the same code), but I get a exception thrown:
At work we\'re stuck with using Formula One Excel components. The problem is that I can\'t find anywhere to post questions so I thought I try here.
I don\'t have much programming knowledge, but I h开发者_如何转开发ave a data set on a CD in the FoxPro format and I need to know if it can be exported to something like Google Docs in the form of a sp