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

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

Results Log change counts are off

Postby 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: 2164
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: Results Log change counts are off

Postby 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.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “WordPipe, ExcelPipe and PowerPointPipe Support”

Who is online

Users browsing this forum: No registered users and 3 guests