Google sheets script writing, how do I prevent an auto update or recacluation of my timestamps in googel sheets? -


i attached copy of spreadsheet run in google. concept when begins picking order, instance type name in i3 , time start. once complete type name in j3 , each causing time stamp below leading total duration time. later factor percentages.

the problem time stamps seem randomly update without prompting so. seems when printed or reopened. cause inaccuracies in times , percentages. assistance appreciated

it appear should write script accommodate need, haven't slightest on how this. directed forum reply in google docs forum

enter link description here

i don't think can choose on cell update or recalculate (tell me if i'm wrong).

a non-optimized workaround (maybe expert have got better solution):

function onedit(e){    var ss = spreadsheetapp.getactivespreadsheet();   var sheet = ss.getactivesheet();   var = 3;    while(i <= sheet.getlastrow())   {         var data = sheet.getrange(i, 9, 3, 2).getvalues();      if(data[1][0].length == 0)     {       if(data[0][0] != "")       {         var d = new date();         sheet.getrange(i+1, 9).setvalue(d);       }     }     if(data[1][1].length == 0)     {       if(data[0][1] != "")       {         var d = new date()         sheet.getrange(i+1, 10).setvalue(d);       }     }     i=i+3;   } }

the onedit(e) function simple trigger implement in google spreadsheet. trigger each time cell edit.

on code above, iterate check on each element if name added or not. if so, code set date , time below name added. since set value on 1 single moment, no auto update modify time.

for workaround, need remove formula put on cell want timestamp (i.e i4 , j4). can keep cells calculate difference between time, should work no problem.


Comments

Post a Comment

Popular posts from this blog

How to understand 2 main() functions after using uftrace to profile the C++ program? -

i trying uftrace profile following simple c++ program: #include <iostream> class { public: a() {std::cout << "a created" << std::endl;} ~a() {std::cout << "a destroyed" << std::endl;} }; int main() { a; return 0; } the profile result this: # uftrace a.out created destroyed # duration tid function 2.026 [ 4828] | __cxa_atexit(); [ 4828] | main() { [ 4828] | __static_initialization_and_destruction_0() { 89.397 [ 4828] | std::ios_base::init::init(); 0.768 [ 4828] | __cxa_atexit(); 93.029 [ 4828] | } /* __static_initialization_and_destruction_0 */ 94.425 [ 4828] | } /* main */ [ 4828] | main() { [ 4828] | a::a() { 11.104 [ 4828] | std::operator <<(); 10.825 [ 4828] | std::basic_ostream::operator <<(); 24.514 [ 4828] | } /* a::a */ [ 4828] | a::~a() { 0.978 [ 4828] | ...
Read more

c# - Update a combobox from a presenter (MVP) -

i using mvp in project, new in mvp. have 2 comboboxes. when select option in combobox, combobox should filled new data. this action in presenter. view 'view1' in presenter, , introduced combobox1 , combobox2 properties in 'view1', because need 'datasource', 'displaymember', 'valuemember' , 'refresh()' in method below. but, when using pattern, enough send property like public string combobox2 { { return combobox1.selectedvalue.tosstring(); } } into presenter not whole combobox. how can solve problem? public void onselectedindexchangedcombobox1() { if (view1.combobox1.selectedindex == -1) { return; } datatable dt = tools.getdatatable("a path"); var query = (from o in dt.asenumerable() o.field<string>("afield") == farmerview.combobox1.selectedvalue.tostring() orderby o.field<string>("anotherfield") select...
Read more

How to put a lock and transaction on table using spring 4 or above using jdbcTemplate and annotations like @Transactional? -

i trying put lock on table while writing on table , if happened in between roll-back . trying convert below code lock table test_g1 read; lock table test_g write; -- begin; start transaction; insert test_g1 values(143); insert test_g values(145); select * test_g1; select * test_g; rollback; select * test_g; unlock tables; how convert above code @transactional spring jdbctemplate code? @transactional(rollbackfor={dataaccessexception.class}) public void test(){ jdbctemplate.execute("insert test1 (id, nam) values (4, 'a')"); throw new dataaccessexception("error") { }; } here trying throw error, insert statement should rollback it's not happening . thanks edit-1 attaching code , doing in jdbcdaoimpl.java , mentioned problem comment above test() . app.java package com.cgiri.javabrains.spring4; import org.springframework.beans.factory.annotation.autowired; import org.springframework.context.applic...
Read more