topic Macros fail on Server in QlikView https://community.qlik.com/t5/QlikView/Macros-fail-on-Server/m-p/158582#M503508 <HTML><HEAD></HEAD><BODY>I make this macro: <PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">sub setInputFieldValores set oTable = ActiveDocument.GetSheetObject( "CH53" ) set gp = oTable.GetProperties gp.TableProperties.PivotAlwaysFullyExpanded = true oTable.SetProperties gp set oCells = oTable.GetCells2(4,0,1,oTable.GetRowCount) 'Copia valores da coluna 4, "Rentabilidade Realizada" set oCellsP = oTable.GetCells2(3,0,1,oTable.GetRowCount) 'Copia valores da coluna 3, "Quantidades" oTable.Deactivate setFormatacaoNumeros("0") ColIter = 6 for RowIter = 1 to oCells.Count-1 if oCellsP.Item(RowIter).Item(0).Text = "-" then oTable.SetInputFieldCell RowIter,6,oCells.Item(RowIter).Item(0).Number end if next setFormatacaoNumeros("1") gp.TableProperties.PivotAlwaysFullyExpanded = false oTable.SetProperties gp oTable.Activateend sub</PRE>This macro copy values of a column to another column (inputfield). This work correctly in stand alone QV, but fail on server("Macro parsing failed, the functionality was lost"). The problem occurs in this line: oTable.SetInputFieldCell RowIter,6,oCells.Item(RowIter).Item(0).Number I tried to apply the value for a variable before to apply on cell, but has no sucess. Does someone has any suggestion? I'm be use Qv 9 Server SR3.</BODY></HTML> Wed, 24 Feb 2010 21:39:56 GMT 2010-02-24T21:39:56Z Macros fail on Server https://community.qlik.com/t5/QlikView/Macros-fail-on-Server/m-p/158582#M503508 <HTML><HEAD></HEAD><BODY>I make this macro: <PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">sub setInputFieldValores set oTable = ActiveDocument.GetSheetObject( "CH53" ) set gp = oTable.GetProperties gp.TableProperties.PivotAlwaysFullyExpanded = true oTable.SetProperties gp set oCells = oTable.GetCells2(4,0,1,oTable.GetRowCount) 'Copia valores da coluna 4, "Rentabilidade Realizada" set oCellsP = oTable.GetCells2(3,0,1,oTable.GetRowCount) 'Copia valores da coluna 3, "Quantidades" oTable.Deactivate setFormatacaoNumeros("0") ColIter = 6 for RowIter = 1 to oCells.Count-1 if oCellsP.Item(RowIter).Item(0).Text = "-" then oTable.SetInputFieldCell RowIter,6,oCells.Item(RowIter).Item(0).Number end if next setFormatacaoNumeros("1") gp.TableProperties.PivotAlwaysFullyExpanded = false oTable.SetProperties gp oTable.Activateend sub</PRE>This macro copy values of a column to another column (inputfield). This work correctly in stand alone QV, but fail on server("Macro parsing failed, the functionality was lost"). The problem occurs in this line: oTable.SetInputFieldCell RowIter,6,oCells.Item(RowIter).Item(0).Number I tried to apply the value for a variable before to apply on cell, but has no sucess. Does someone has any suggestion? I'm be use Qv 9 Server SR3.</BODY></HTML> Wed, 24 Feb 2010 21:39:56 GMT https://community.qlik.com/t5/QlikView/Macros-fail-on-Server/m-p/158582#M503508 2010-02-24T21:39:56Z