Stack Overflow
Stack Overflow

Questions tagged [spreadsheet]

Use this tag for questions about spreadsheet apps, plug-ins, libraries, etc., where no more specific tag exists. A spreadsheet presents tabular data sets arranged in rows and columns, typically with tools for capturing, analyzing, and collaborating on that data. Each cell may contain alphanumeric text, numeric values, or formulas.

Note: The tag should only be used if a more specific tag does not apply to the question.

A spreadsheet presents tabular data sets arranged in rows and columns, typically with tools for capturing, analyzing, and collaborating on that data. Each cell may contain alphanumeric text, numeric values, or formulas.

Related Tags:

Don't tag your question with if a more specific spreadsheet tag is appropriate. Common spreadsheet software and their more specific tags include:

If there is no more specific tag than for your question, use one or more of the following related tags to enlarge the audience for your question:

References

4421 questions
1
vote
1 answer

How to negate countif

I am using countif quite often. However, I was wondering if I want to look for something not like: =Countif(A:A;"1"), which counts all 1 but I want to count in which cell there is NO 1. I appreciate your answer!
user2051347
  • 1,609
  • 4
  • 23
  • 34
1
vote
0 answers

Change marker icon in geoJSON using sheetsee.js and mapbox

So, this guy created a JavaScript function to change marker icon of geoJSON in mapbox map. I tried to apply his function for my map, which is generating geoJSON from a Google spreadsheet using sheetsee.js and mapbox/leaflet. I want to change default…
michal.hornak
  • 11
  • 2
1
vote
1 answer

Migrating Java UNO code from OpenOffice 2.4 to 3.0

I had a nifty small tool written to convert spreadsheets to plain text. Since it was my private hacker tool, it relied on OpenOffice 2.x to read the files. But when I installed OpenOffice 3 and tried to get it get it to run, I failed miserably,…
Stroboskop
  • 4,327
  • 5
  • 35
  • 52
1
vote
2 answers

Create or Open native Google documents using GoogleDriveApi

I have been closely following the documentation for the Google Drive Android API and, all works great. I can create new text documents and read them back in using the mime type of text/plain. What I cannot do is create a native Google "Document" or…
LimaNightHawk
  • 6,613
  • 3
  • 41
  • 60
1
vote
0 answers

Determining File Path in Nitrous?

I am running Ruby on Rails on Nitrous Rails 4.0.1 Ruby 2.0.0p247 I am trying to use the spreadsheet gem and open a file I added to my file system in Nitrous. But spreadsheet needs a file path to the document and the file paths I've tried always come…
Curtismith04
  • 11
  • 2
1
vote
1 answer

MS Excel Forumlae

I have always used Excel for basic forumlae functions. I havnt needed to use advanced forumlae's before to gather information. However, today I do and I have been looking at Google for a while for the answers. Managed to work out a few things I…
Marshal
  • 1,177
  • 4
  • 18
  • 30
1
vote
1 answer

Count the uniquness of a value

I have this sheet: As you can see I am determining the uniqueness of a value by this formula: =IF(SUMPRODUCT(($A:$A=A2)*($B:$B=B2)*($C:$C=C2))>1;"NOT UNIQUE";"UNIQUE") This formula basically checks if the the identifier the value and the date are…
user2051347
  • 1,609
  • 4
  • 23
  • 34
1
vote
0 answers

Stop postback on user click on grid

I'm trying lot of code on this but still not get any corect answer, My problem is i have a spread .net grid when i click on grid, postback occur i dont need this postback in any case, I also applied ajax control toolkit still my problem not resolved…
user3136255
  • 149
  • 4
  • 12
1
vote
1 answer

Map column to other values

I have the following data: I want to match the Date and Value col to the Mapped Date and Value colume: I am doing this with: =COUNTIFS($A:$A;E2;$B:$B;F2) However that does not give me the Higher/Lower colume which I want to map. Basically it should…
user2051347
  • 1,609
  • 4
  • 23
  • 34
1
vote
1 answer

Count only unique strings

I have a column with strings. I only want to count the strings which are unique. I know that I could just derive all distinct strings(by pasting them) and then count them with =Count(...). However I do not want to destroy my dataset. Therefore, is…
user2051347
  • 1,609
  • 4
  • 23
  • 34
1
vote
1 answer

Median of specific transactions

I have the following sheet: I would like to take the median for all rows with a K. I know how to take the median of all transactions. The hard part for me is "search for K and take only this transactions". Any recommendations how to solve this? I…
user2051347
  • 1,609
  • 4
  • 23
  • 34
1
vote
1 answer

PHPExcel cache error

When I enable the cache options to improve memory usage: $cacheMethod = PHPExcel_CachedObjectStorageFactory::cache_to_phpTemp; $cacheSettings = array( 'memoryCacheSize' => '32MB'); PHPExcel_Settings::setCacheStorageMethod($cacheMethod,…
xmarston
  • 853
  • 3
  • 12
  • 36
1
vote
0 answers

Compare two spreadsheets using python or perl

I like to compare two spreadsheets. Lets say file1.xls and file2.xls. I like to go compare file1 records with file2 column records. If there is a match with any particular cell I like to update a specific column on file2.xls (for example say there…
user2188628
  • 11
  • 2
1
vote
3 answers

Excel trick for this task

I've got a spreadsheet in excel with this rows: COLUMN Value1.Value2.Value3 Value4.Value5.Value6 Value7.Value8.Value9 In another spreadsheet I've got a simple list with names: COLUMN Name1 Name2 Name3 And,of course, this list…
D. Caan
  • 1,907
  • 6
  • 22
  • 36
1
vote
5 answers

Why doesn't Perl's Spreadsheet::ParseExcel never return from $parser->parse('test.xls')?

The spreadsheet is Excel 97-2003 compatible and permissions 777 use strict; use Spreadsheet::ParseExcel; print "Content-type: text/html\n\n"; my $parser = Spreadsheet::ParseExcel->new(); print "
gets here:".__LINE__; my $workbook =…
zzapper
  • 4,743
  • 5
  • 48
  • 45
1 2 3
…
99
100