pygsheets icon indicating copy to clipboard operation
pygsheets copied to clipboard

Published 20 hours ago • verified publisher icon nithinmurali

Bug: Find and replace when there is merged cell rows in sheet

Open ashwarsadh opened this issue 6 years ago • 2 comments

Hello, There is still a bug in find and replace. find replace bug

When there is any merged cells rows in data then it is calculating wrong row number by offset of number of merge rows. A screenshot is attached highlighting it when i replaced $date with value it is not replaced at right position find replace bug

ashwarsadh avatar Apr 20 '18 23:04 ashwarsadh

Are you using replace() for replace ? or is it a bug only with find?

nithinmurali avatar Apr 21 '18 09:04 nithinmurali

Ok , i just checked. Spreadsheet.find(search,replace,False) works well Worksheet.find has this bug.

ashwarsadh avatar Apr 21 '18 20:04 ashwarsadh