top | item 37823241

(no title)

c4mpute | 2 years ago

Yes, I have. What Excel is still lacking is an easy solution for the input side. You can bind tons of data sources, but all are weird, hard-to-use, manual. There is no easy "grab this from that website, get the current data of what I just pasted there, mash it together, publish it"

Hell, it cannot even do proper CSV import. You need to reformat your CSV to match the locale Excel is running under!

discuss

order

uxp8u61q|2 years ago

Uh? Are you sure you've actually used Excel? The CSV import is highly configurable and leads you immediately into Power Query where you can massage the data any way you want.

c4mpute|2 years ago

The LibreOffice CSV import is configurable. The Excel one isn't.

You can do things in PowerQuery, but that is far from obvious and still buggy. Not to mention all the woes after import, like date/time auto-interpretation and autocorrections that cannot be switched off.

I stand by what I said. Excel imports are a huge mess.