spreadsheet Questions
5
Solved
In Excel, let's I have data in B2 to B7 and C2 to C7 . In VBA I can write a macro to select it:
Sub Macro1()
Range("B2:C7").Select
End Sub
How do I rewrite the code so that it chooses automatic...
Decima asked 10/10, 2016 at 21:36
3
Solved
I'm currently using something like this to insert inline string in a cell :
new Cell()
{
CellReference = "E2",
StyleIndex = (UInt32Value)4U,
DataType = CellValues.InlineString,
InlineStri...
Mcclurg asked 8/4, 2009 at 22:3
3
Solved
How do you return different values in a cell based on which range the value entered in another cell comes under? Specifically, I am trying to make a step function.
For example:
IF G2 is ABOVE &quo...
Cullan asked 10/9, 2013 at 19:59
5
I'm using akeneo-labs spreadsheet-parser library to extract data from xlsx file.
use Akeneo\Component\SpreadsheetParser\SpreadsheetParser;
$workbook = SpreadsheetParser::open('myfile.xlsx');
$my...
Phylogeny asked 15/2, 2017 at 12:31
3
Solved
I'm trying to get multiple filters on the same row that filter different tables.
So users can sort data from table 1, 2 or 3 individually as they wish.
Is it possible to do that in Google sheets?
Q...
Deuteragonist asked 18/5, 2022 at 5:49
3
Solved
I tried to execute this code (copied from the documentation https://theoephraim.github.io/node-google-spreadsheet/#/):
async function accessSpreadsheet(){
const doc = new GoogleSpreadsheet(process...
Bumkin asked 21/5, 2022 at 19:2
3
Solved
I want to read, write and create Spreadsheets in the Open Document Format with Java. And I want the resulting Java-program running on a computer without OpenOffice.org or other ODS-capable programs...
Correy asked 19/1, 2009 at 7:20
3
Solved
I have an Open Office Calc Sheet with a column full of data that has hyperlinks. I wish to trasnfer the hyperlinks to another column. How do I extract them?
Thanks.,.
Anagrammatize asked 12/7, 2010 at 19:54
4
Solved
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....
Stephan asked 13/1, 2010 at 16:16
2
Is there a way to make pandas Dataframes observable?
Lets say I have some Dataframes A, B, C that have the same index and C is calculated by
C = A + B
If I change a cell value in A (e.g. 2 => 4...
Censurable asked 1/7, 2020 at 6:52
5
I have created a Google Spreadsheet with five columns;
Once the user filled the values in the first three columns, It has to call a 3rd party API and fill the value(response) in the forth and fift...
Hodgkins asked 9/10, 2014 at 11:36
2
Solved
is there an easy way (workaround) how to disable automatic re-calculations of volatile functions like =RAND() =RANDARRAY() =RANDBETWEEN() in google spreadsheet (?)
without scripts
without addons
w...
Seda asked 15/2, 2021 at 0:7
1
Solved
I want to have the randbetween function only return a random number until a specific day, then stop changing. Is there a way to accomplish this in googlesheets?
=IF(today()<F1,randbetween(1,10),...
Gamez asked 19/8, 2022 at 17:3
5
Solved
I'm looking for the equivalent VBA-GAS of:
Application.ScreenUpdating = False
I'm running a very long macro in one of my Google Spreadsheets and it takes at least 30 seconds to finish it every ...
Profant asked 19/7, 2013 at 15:27
1
Solved
I need to sort multiple columns using the QUERY function together with checkboxes which indicate which columns to sort. This should work with multiple columns.
This is the formula:
=IFERROR(ARRAYF...
Sumner asked 7/7, 2022 at 21:44
8
Solved
I'm trying to parse an Excel spreadsheet (.xlsx) into JSON.
I'm using the SheetJS node package for it.
However I can't realize such a simple thing as - how do I get a column name in the same form...
Epididymis asked 15/1, 2016 at 15:3
4
Solved
This is what I have thus far:
=if(ISBLANK(A:A), (A:A+TIME(2, 0, 0)), "")
I'd like the script to add 2 hours to A:A or just remain blank if there is no data inside A:A
Any ideas would be greatly...
Cheri asked 26/2, 2016 at 7:47
5
Solved
I'm just beginning to dive into VBA and I've hit a bit of a roadblock.
I have a sheet with 50+ columns, 900+ rows of data. I need to reformat about 10 of those columns and stick them in a new work...
Impendent asked 4/5, 2009 at 18:47
3
I have a function in a controller that takes in some specifications and generates a report on them. This function user_report is called in a view:
< %= submit_to_remote 'submit-button', "Export...
Busywork asked 18/10, 2010 at 20:1
2
Solved
I am trying to convert a string into date format in Google Sheet. I've tried different formulas but failed. I guess REGEXMATCH may solve this or even Google Apps Script can also solve this. But I p...
Exceed asked 1/4, 2022 at 1:43
3
Solved
is there any way to update existing sheet name of MS Excel file knowing that I am using apache poi in my android app
I can create a sheet with my custom name
HSSFSheet sheet = workbook.createShe...
Trainband asked 21/2, 2014 at 18:12
4
Solved
I would like to use spreadsheets to get all unique names from Column A in a table but in the same time I would like blank cells to be ignored. So far I've got this formula that returns all of the u...
Fulgent asked 17/10, 2017 at 12:53
4
Solved
With a column range of A1:A20 I have found the largest number with =MAX(A1:A20). How can I find the reference (e.g. A5) of the MAX() result?
I'm specifically using Google Spreadsheets but hope thi...
Ubangishari asked 16/12, 2013 at 8:2
3
Solved
Hi I am trying to extract the rootdomain from URL string in Google Sheets. I know how to get the domain and I have the formula to remove www. but now I realize it does not strip subdomain prefixes ...
Heiser asked 23/8, 2015 at 7:6
3
Solved
I have a *.xlsm file which has 20 sheets in it.
I want to save few sheets as *.csv (formatting loss is fine) individually.
Already tried xlrd-xlwt and win32com libraries but could not get through....
Cotsen asked 9/5, 2014 at 0:21
1 Next >
© 2022 - 2024 — McMap. All rights reserved.