Questions tagged as 'planilhas'

0
answers

Remove duplicates based on the value of a column

I'd like to know how I can perform the following filter: ===> Thatis,howtoremovetheduplicatesinthe"action" column, but leaving the record with the highest priority (in this case, '1' is the person with the highest priority and '8' is the...
asked by 21.05.2018 / 22:21
0
answers

Run Function onedit in two tabs of a worksheet

I have a spreadsheet with three tabs being a "May", "Visit-Upas" and "Alarm Trigger". I want it to automatically set the time from filling in a cell. For the tab described as "MAY." Iusedthisscriptbelow,itlaunchesthetimeintheindicatedfieldas...
asked by 10.05.2018 / 18:33
2
answers

Subtraction with date - Google Apps Script

Expensive, I need to calculate how many days remain to reach the target date. I'm getting the following values var dataPrev = row[4]; //26/01/2018 var dataNaoFormat = new Date(); //22/01/2018 I'm doing the following calculation: var...
asked by 23.01.2018 / 01:16
1
answer

Web Data Query in Excel

I work in a company and need to monitor the printer toner life on a daily basis ... For this I created a monitoring worksheet, but I wanted a practical system, like this: When I insert the web address into a worksheet cell, automatically n...
asked by 09.10.2017 / 02:25
1
answer

Google Sheets - Sending E-Mail

I have the following code that sends emails through a Google spreadsheet. function sendEmails() { var sheet = SpreadsheetApp.getActive(); var startRow = 2; var planMensagens = sheet.getSheetByName("mensagensEmail"); var mensagemRe...
asked by 22.09.2017 / 15:05
1
answer

When I refer to more than one column using FormulaR1C1

Good morning! I'm having trouble referencing more than one column in excel using VBA, for example: Stock! A: G and I create the macro, and it generates for me Stock! C [-6]: C , I did not understand how it when I migrate for FormulaR1C1...
asked by 30.03.2017 / 16:01
2
answers

Standardize worksheets in open office [closed]

I have an open office spreadsheet file with 27 spreadsheets inside. All spreadsheets are the same, 3 columns, title, nothing more. I need a way to format all spreadsheets one at a time. - line width - color of the headers - width of columns...
asked by 16.08.2017 / 17:20
1
answer

Convert Cell type to String in Apache POI

How can I convert a type Cell to String ? String datateste = row.getCell(5);     
asked by 13.09.2018 / 21:09