C#

PozzaVecia wrote:

Basically my UDF can't accept a link to a cell as argument... can this bug be
connected with 64 bit of Windows?

Quote:

Nope. It works fine on Office 2007 (32-bit) running on Windows 7 64-bit.

Member 10036172 wrote:

Is there any need to use Visual Studio 2012, as there are some features that you won't find in VS 2012.

Blubbo wrote:

Any suggesion?

   int status = tag_device0.Write_Tag(0, writeDat, en_statusDat, pb);
 
   worker.ReportProgress(pb.Value);
 
   if (ReadTag)
   {
       worker.ReportProgress(0);
       byte[] tagData = new byte[1024];
       tag5_device0.Read_Tag(0, 0, tagData .Length, ref tagData , pb);
       worker.ReportProgress(pb.Value);
    }

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

private void InitializeProgressBars()
{
  for (int i = 0; i < DevicePath.Count; i++)
  {
    progressBar[i] = new ProgressBar();
    progressBar[i].Location = new Point(3, 16);
    progressBar[i].Size = new Size(605, 31);
    progressBar[i].Maximum = 100;
  }
 
  gbProgressStatus0.Controls.Add(progressBar[0]);
  gbProgressStatus1.Controls.Add(progressBar[1]);
  gbProgressStatus2.Controls.Add(progressBar[2]);
  gbProgressStatus3.Controls.Add(progressBar[3]);
}
 
private void InitializeBackgroundWorkers()
{
  for (var f = 0; f < DevicePath.Count; f++)
  {
    bw[f] = new BackgroundWorker();
    bw[f].WorkerReportsProgress = true;
    bw[f].WorkerSupportsCancellation = true;
 
    switch (f)
    {
      case 0:
      {
        bw[f].DoWork += new DoWorkEventHandler(BackgroundWorkerFilesDoWork0);
        bw[f].RunWorkerCompleted += new RunWorkerCompletedEventHandler(BackgroundWorkerFilesRunWorkerCompleted0);
        break;
      }
      case 1:
      {
        bw[f].DoWork += new DoWorkEventHandler(BackgroundWorkerFilesDoWork1);
        bw[f].RunWorkerCompleted += new RunWorkerCompletedEventHandler(BackgroundWorkerFilesRunWorkerCompleted1);
        break;
      }
      case 2:
      {
        bw[f].DoWork += new DoWorkEventHandler(BackgroundWorkerFilesDoWork2);
        bw[f].RunWorkerCompleted += new RunWorkerCompletedEventHandler(BackgroundWorkerFilesRunWorkerCompleted2);
        break;
      }
      case 3:
      {
        bw[f].DoWork += new DoWorkEventHandler(BackgroundWorkerFilesDoWork3);
        bw[f].RunWorkerCompleted += new RunWorkerCompletedEventHandler(BackgroundWorkerFilesRunWorkerCompleted3);
        break;
      }
    }
    bw[f].ProgressChanged += (sender, e) => { ((ProgressBar)e.Argument).Value = e.ProgressPercentage; };
  }
}
 
private void BackgroundWorkerFilesDoWork0(object sender, DoWorkEventArgs e)
{
  BackgroundWorker worker = sender as BackgroundWorker;
  worker.ReportProgress(0);
  ProgressBar pb = (ProgressBar)e.Argument;

  System.Diagnostics.Stopwatch sw = new System.Diagnostics.Stopwatch();
  sw.Start();
  // counts on pb being updated safely for threading issues.
  int status = tag_device0.Write_Tag(0, writeDat, en_statusDat, pb);
 
  if (ReadTag)
  {
    worker.ReportProgress(0);
    byte[] tagData = new byte[1024];
    tag5_device0.Read_Tag(0, 0, tagData .Length, ref tagData , pb);
  }
 
  sw.Stop();
  string result = string.Format("Status: {0}    Elapsed: {1}", status, sw.Elapsed.ToString());
  e.Result = result;
}

// Then when the BackgroundWorkers are started:
bw[n].RunWorkerAsync(progressBar[n]);

void UpdateProgressBar(ProgressBar pb, int value)
{
   if (pb.InvokeRequired)
   {
      Action<ProgressBar, int> action = new Action<ProgressBar, int>(UpdateProgressBar);
      object[] obj = new object[] { pb, value };
      pb.BeginInvoke(action, obj);
   }
   else
      pb.Value = value;
}

public int tag5_device0.Read_Tag(<parameters>, ProgressBar pb)
{
   //code snippet

   for (int i = 0; i < 44; i++)
   {
      UpdateProgressBar(pb, i);
}

private static Action<ProgressBar, int> UpdateProgressBarAction = UpdateProgressBar;
private static void UpdateProgressBar(ProgressBar pb, int value)
{
  if (pb.InvokeRequired)
  {
    pb.BeginInvoke(UpdateProgressBarAction, pb, value);
  }
  else
    pb.Value = value;
}

private static Action<ProgressBar, int> UpdateProgressBar = (ProgressBar pb, int value) => {
  if (pb.InvokeRequired)
  {
    pb.BeginInvoke(UpdateProgressBar, pb, value);
  }
  else
    pb.Value = value;
};