JDownloader Community - Appwork GmbH
 

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #11  
Old 21.06.2022, 12:47
StefanM's Avatar
StefanM StefanM is offline
JD VIP
 
Join Date: Oct 2020
Posts: 472
Default

Quote:
Originally Posted by Jiaz View Post
Excel informs you that JSON value is a List or Record, the type and you have to query which information of that value you're intersted in...
Thanks for the enlightenment!

I checked settings.json and found the correct strings there. So, another 'problem' created by Excel's 'features'.

There are many examples for unwanted 'conversion' etc.

E.g. I want to open a csv file which contains Corona figures for age groups:

0-4
5-9
10-14
15-19
...


What does Excel do?

0-4
05. Sep
Oct 14
15-19
...


Haven't found a way to turn these automatic 'helpers' off.
If you format all columns to Text, Excel won't remember...

Same with the tsv settings file, created by mgpai's script:
Doubleclicking for opening it in Excel results in corruption of some strings.
So, you have to import it, select UTF-8,...


Also haven't found a way to tell Excel that I want to open all files as UTF-8.


Question 1:
You seem to be pretty familiar with Excel, too.
Any ideas, e.g. how to let Excel treat all *.txt, *.csv, *.tsv, ... as UTF-8?

Question 2:
If you format all columns to Text, Excel won't remember...
Do you know how to tell Excel to use text formatting as default? This would solve some problems such as my age group example.

Then I could open csv files from RKI using doubleclick instead of time consuming import of each and every file...

Last edited by StefanM; 21.06.2022 at 12:50.
Reply With Quote
 

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT +2. The time now is 18:47.
Provided By AppWork GmbH | Privacy | Imprint
Parts of the Design are used from Kirsch designed by Andrew & Austin
Powered by vBulletin® Version 3.8.10 Beta 1
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.