Results Log change counts are off

Discuss WordPipe, ExcelPipe and PowerPointPipe. Get help with installation and running, notify us of bugs, request new features and enhancements.

Moderators: DataMystic Support, Moderators

Post Reply
Posts: 1
Joined: Fri Jul 11, 2008 5:18 am

Results Log change counts are off

Post by jjensen22 » Fri Jul 11, 2008 5:34 am

I am using Excel Pipe 3.9.4 Lite and Excel 2003. I am using this to update/replace part numbers where each part number only appears once in a file. In some instances, the results log is showing 2 changes being made when only one replacement is performed. In other cases, it accurately shows 1 change made. Do you have any idea why this is happening?

User avatar
DataMystic Support
Site Admin
Posts: 2237
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia

Re: Results Log change counts are off

Post by DataMystic Support » Tue Jul 15, 2008 8:52 am

The reason is complex but stems from a design failure in Microsoft Excel.

Excel treats Formulae and Cells differently for search/replace.

However, if you search just for Formulae, it will also change normal Cells, and if you search just for normal Cells, it will also replace in Formulae (just to be helpful).

Unfortunately, this often means that a search/replace can occur more than once in the same cell, which is why all our counts are 'At least xx changes made' because we cannot be more precise than that.

Simon Carter, - Insulin dose calculator for Type 1 diabetes - 250,000 free software downloads

Post Reply