vndmtrx

Function busca_ultimo_registro(ByVal plan as String) as Object
  Dim rows as Object
  Dim i as Integer
  
  rows = ThisComponent.getSheets().getByName(plan).getRows()
  
  i = 0
  Do 
    i = i + 1
  Loop while rows.getByIndex(i).getCellByPosition(0,0).String <> ""

vndmtrx

REM  *****  BASIC  *****

'http://wiki.documentfoundation.org/images/d/d8/0312CG3-CalcMacros.odt

option explicit

sub efetua_lancamento

  'Doc = ThisComponent
  

vndmtrx

REM  *****  BASIC  *****

'
' Macro DuploLancamento
'
' Macro para LibreOffice Calc criada com objetivo de fazer duplo lançamento de transferências entre contas, 
' de acordo com a estrutura das tabelas de conta.
'
' Eduardo Rolim - www.tocadoelfo.com.br
' Palmas - 2012

vndmtrx

stack = []
compileStacks = []
words = {}
builtins = {}
lambdaType = type(lambda x: x) #cannot compare against the function type directly for some reason

def prn(o):
	print(o)

def clr(l):

vndmtrx

import os, math, re, urllib
scraping = "http://interfacelift.com/wallpaper/downloads/date/widescreen/1440x900/"
goal = 10
done = 0
tag = re.compile(r"<a href=\"(?P<url>[^\"]+)\"><img src=\"/img_NEW/button_download\.png\"")
if not os.path.exists("scraped") :
	os.makedirs("scraped")
for page in range(1, 1 + int(math.ceil(goal / 10.0))):
	list = tag.finditer(urllib.urlopen(scraping + "index" + str(page) + ".html").read())
	for i in list:

vndmtrx

transacoes = document.getElementsByClassName("transactionRowPrice");
total = 0;
for (i = 0; i < transacoes.length; i++) {
  custo = Number(transacoes[i].innerText.substr(1));
  if (custo) {
    total += custo;
  }
}

vndmtrx

(function() { 
  var transacoes = document.getElementsByClassName("transactionRowPrice");
  total = 0;
  for(var i = 0; i < transacoes.length; i++){
    var custo = parseFloat(transacoes[i].innerHTML.substr(1));
    if(!isNaN(custo)) {
      total += custo;
    }
  }
  console.log(total);

vndmtrx

(function() {
  var script = document.createElement("script");
  script.src = "//ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js";
  script.onload = script.onreadystatechange = function(){ console.log("done;"); };
  document.body.appendChild(script);
})();

vndmtrx

(function() {
  var outralib = false;
  var msg = '';
   
  var criapainel = function() {
    var div = document.createElement("div");
    div.style.zIndex = 1001;
    div.style.backgroundColor='#c90';
    div.style.color='#fff';
    div.style.fontFamily = 'sans-serif';

vndmtrx

(function() {
  var total = 0;
  $jq("#store_transactions .block").each(function(i, v) {
    var sum = 0;
    $jq(v).find(".transactionRowPrice").each(function(ii, vv){
      //console.log(i + ": " + $jq(vv).text());
      custo = parseFloat($jq(vv).text().substr(1));
      if(!isNaN(custo)) {
        sum += custo;
      }