Results 1 to 3 of 3

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Aug:2007
    Location:
    Posts: 743

    Google Sheets

    ,

    , , Google, , . , Ariel 10, . , - , , :
    Code:
    function onEdit(e) {
      var ss = SpreadsheetApp.getActiveSpreadsheet();
      var sheet = ss.getSheets()[0];
      var cell = sheet.getRange("B1:B9999");
      cell.setFontSize("12");
    }
    getRange("B1:B9999") getMaxRows(), ?
    , - ?

    - - - - - -



    oo . !

    Code:
    function onEdit(e) {
       var ss=SpreadsheetApp.getActiveSpreadsheet();
       var sheets=ss.getSheets();
       for (var i in sheets) {
           sheets[i].getRange(1,2,sheets[i].getMaxRows()).setFontSize("12");
       }
    }
    Last edited by dkgray; 2nd February 2017 at 16:15.

  2. #2
    Registered User hateras's Avatar
    Join Date: Jan:2011
    Location: Kronos III
    Posts: 1,028
    . , onEdit ? , ...
    ASRock B550M Pro 4; Ryzen R5 3600; 2x16 GiB G.SKILL Aegis 3200; 1TB Samsung QVO 960 + 3TB Seagate IronWolf; Zalman Z1

  3. #3
    Registered User
    Join Date: Aug:2007
    Location:
    Posts: 743
    Quote Originally Posted by hateras View Post
    . , onEdit ? , ...
    - . onOpen ? , , . , , .
    .

    P.S. , , onEdit . - , .
    P.P.S. Utilities.sleep(), .
    P.P.S. Utilities.sleep()
    Last edited by dkgray; 3rd February 2017 at 18:41.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |