5 ms·
I think if you explicitly type in a leading zero with five digits it seems reasonable that it should infer it’s a zip code.
by thethimble 4y ago
I think if you explicitly type in a leading zero with five digits it seems reasonable that it should infer it’s a zip code.
- boosteri 4y agoMaybe, given the appropriate locale in the system settings.
- watwut 4y agoOh no, Jesus, please no. Nothing better then Excell file what behaves completely differently when moved to another computer, purely because of something like locale in system settings.
- Findecanor 4y agoFirst, you should not conflate the locale of the user or program with the locale of the (span in the) file. Second, how would you handle international addresses? For many businesses, a program that can't do that would be useless.
- replygirl 4y agoprogrammers who don't work with time be like
- pbhjpbhj 4y agoIt needs Clippy-ing: "recognise column as zip codes? always, now, not now, never, turn off format recognition".
- 6510 4y agoIf the column is going to be called something stupid like A, B or C clippy is going to have a hard time....