spreadsheet_开发者

Formulas to populate spreadsheet with data

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).[详细]

2023-04-11 07:20 分类：问答

Setting an Excel worksheet's custom page size (not the printable area) from Perl

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[详细]

2023-04-10 23:57 分类：问答

Do you know of a sophisticated spread sheet like component for Swing

I need to write a data exploration tool that displays large amounts of data in a spreadsheet format. Salient problem features:[详细]

2023-04-10 17:02 分类：问答

spooling a clob value with multiple lines using sqlplus to a single cell of a CSV

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[详细]

2023-04-09 03:44 分类：问答

In Apple Numbers, how can I calculate a difference between two dates?

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.[详细]

2023-04-08 18:38 分类：问答

Conditional Formatting in Excel using Alphanumerics

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[详细]

2023-04-08 14:28 分类：问答

Excel spreadsheed populate cell based on value of another cell

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[详细]

2023-04-06 11:45 分类：问答

iphone GData spreadsheet unrecognized selector

I\'ve used the GData spreadsheets code for MAC to write a corresponding iPhone version (the same code), but I get a exception thrown:[详细]

2023-04-04 17:46 分类：问答

Formula One (Tidestone) question

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.[详细]

2023-04-04 10:46 分类：问答

Fox Pro 8 - Export to Spreadsheet

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[详细]

2023-04-03 19:58 分类：问答