Results Log change counts are off
Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators
Results Log change counts are off
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?
-
DataMystic Support
- Site Admin
- Posts: 2227
- Joined: Mon Jun 30, 2003 12:32 pm
- Location: Melbourne, Australia
- Contact:
Re: Results Log change counts are off
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.
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.