Description: Using the find and replace option I can't execute the 'add leading zeros' module. Steps to Reproduce: 1. 2.Using the find and replace function, the addition of leading zeros fails (or at least appears to). Initially all I got returned was the sheet which told me the cells I'd highlighted. I turned this notification off and the problem still exists. 3.Version: 7.5.5.2 (X86_64) / LibreOffice Community Build ID: 50(Build:2) CPU threads: 16; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+wayland) Locale: en-IE (en_IE.UTF-8); UI: en-US Debian package version: 4:7.5.5-4 Calc: threaded Actual Results: failure to execute adding in leading zeros Expected Results: adding in leading zeros Reproducible: Always User Profile Reset: Yes Additional Info: Version: 7.5.5.2 (X86_64) / LibreOffice Community Build ID: 50(Build:2) CPU threads: 16; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+wayland) Locale: en-IE (en_IE.UTF-8); UI: en-US Debian package version: 4:7.5.5-4 Calc: threaded
In what program you are using F&R? Can you attach a screenshot of F&R window? Can you attach a sample file to test?
Created attachment 189267 [details] screenshot for find and replace image The screen dialogue that appears is the only thing functional that I can find happening when I press replace.
Created attachment 189268 [details] test file - almost empty but with the relevant data Can you attach a sample file to test? attached let me know if there is more I can do or demonstrate - as far as I can see I have done as the program and help page have requested and still am nowhere. I saw someone on mastodon asking about this yesterday and it's what prompted my report - they used version 6.3 libreoffce from that which I could see.
I don't understand what you are trying to do. ^[0-9] searches for a number at the beginning of the cell. & replace what is founded for itself. If you want to add zeroes at the beginning, in replace put: 0& but as in the cell are numbers (not text) left zeroes are lost. So replacing with: '0& they became text and the left zero is added.
Thank you. That explains my misreading of the docs. What I thought I was going to get was: 0001 0123 I'll head back to the drawing board. Sorry for the misreport.