Ranting about various SW ( I start with MS )

[gilesgoat]

I could make "a specific thread" but "why not a single aggregating thread where we moan about ( bad ) SW choices" ?

So yesterday and some previous days I was dealing with localisation ( in 5 languages , GEFIS ) this time I told ( luckily is ONE place only doing the stuff ) "use UTF-8 encoding put all in a XLS file".

The idea was "export into CSV, import in the game" .. which must be said this time "went lot better than the previous one" (*) also I've been better in writing parsing code I suppose.

However I have .. a VERY OLD version of Excel ( about 17 years ago ) so ok "some crap was expected" ..

But Jeff has a subscription to THE MOST RECENT ONE 365 ( for the sole purpose to sometime open XLSX and crap they send us ) so YOU WOULD THINK THAT :

1. open an XLS(x) file that has 1 column of integer numbers, 5 columns of TEXT, let's call it "Sheet A"
2. create a new sheet "B"
3. copy "column 1" and paste it into "column 1" of "B"
4. copy "column n" and paste it into "column 2" of "B"
5 save/export "sheet B" as CSV thing

Should be easy peasy "with the new potent Excel 365" ?

So it went like ..

1. "okISH" (*)
2. "ok"
3. WHERE IN THE FUCK IS GONE "Sheet A" ?

Sure there must be the window somewhere/icon/iconfied come on can't be the sheet vanished WHERE IN THE ()$(*"£&*(£$&£ THE SHEET IS GONE I CAN'T FIND IT ??!!

After messing with some windows crap and finding some "organize windows side by side" finally the sheet reappears, where in the heck it was vanished what was the supposed "correct way" to make it reappear NO IDEA !

Ok "cut" .. ok "paste" ..

"What type of paste you want ?" ..

JUST PASTE THE DAMNED THING ! .. ok .. ok .. we are there ..

Now .. "export/save as" ...

(*) WHO IN THE HECK CAME WITH THE IDEA THAT ANY DAMNED TIME YOU GO TO THE "FILE" MENU YOU HAVE TO SCROLL LEFT/RIGHT ALL THE WINDOW/SHEET IS *SO FUCKING ANNOYING* !!

"Save as CSV" ..

Seems ok .. no wait .. WTF happened to the numbers ? ..

Ah "okeish" .. "format column, custom, "0000" " .. ok ..

"Save as CSV" ( DAMNED FILE MENU SCROLL !! )

Humm .. "something does not quite" ...

Check again ..

Ah "Save as CVS - UTF8" ...

Ok seems right but .. HUM ..

Am I wrong or "the rule" says <<strings should be all limited by " " >> and/or << If they contain a " character >> ?

So incredible but true NONE of the strings in the file have any "" in ( yes it's been so hard for me ) ..

Some of the exported strings are enclosed in "" .. SOME not .. and I CANNOT SEE ANY LOGIC about when/why it put "" and when not !

Luckily my "importer" handles that .. but .. WTF ???

All I was expecting was :

0001,"Banana"
0002,"This is a string vaffancul"
0003,"Cheap as chips"

But no .. you get things like

0001,"Banana"
0002,This is a string vaffancul
0003,Cheap as chips"


... I give up to try to understand the logic ...

Anyway I'd also like to know "in WHAT ISO-Latin extension shit" FRENCH managed to find "OE" as in "OEUFS" ( for example ) it's not ISO-Latin1 .. aaargh ... European languages are MESSY !