Prime vs Excel, IDE...

[EugeneNine]

(04-08-2021 01:30 PM)Dave Britten Wrote:  

(04-07-2021 09:25 PM)EugeneNine Wrote:  Excel is crap. Half my reporting at work involves workarounds for its limitations and bugs^D^D^D^Dfeatures

If you're using Excel for reporting and not using Power Query and/or Power Pivot, then it's going to be pretty unpleasant.

I'm not doing reporting in excel, its people want to be able to export data from reports so they can look at it in excel themselves. A few updates ago it started splitting tabs, carriage returns and line feeds into separate columns even if you have those options unchecked. Its now limiting cell length so I have to check my data length first, etc. And thats not counting the existing bugs like failing to completely save a workbook and leaving a .tmp file in its place.