cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
%3CLINGO-SUB%20id%3D%22lingo-sub-241861%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERiprodurre%20il%20formato%20durante%20il%20salvataggio%20come%20file%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-241861%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EIn%20realt%C3%A0%2C%20purtroppo%2C%20a%20mio%20parere%2C%20Microsoft%20Excel%20%C3%A8%20ancora%20lo%20standard%20di%20fatto%20per%20lo%20scambio%20di%20dati%20in%20formato%20tabella.%20Anche%20Google%20Spreadsheet%20ora%20consente%20agli%20utenti%20di%20lavorare%20su%20file%20Excel%2C%20piuttosto%20che%20costringere%20gli%20utenti%20a%20convertire%20i%20file%20Excel%20nel%20formato%20di%20Google.%20Personalmente%20esporto%20spesso%20le%20tabelle%20JMP%20come%20file%20Excel%20per%20condividerle%20con%20gli%20%22utenti%22%20della%20mia%20analisi.%3C%2FP%3E%3CP%3EVorrei%20che%20JMP%20rispetti%20le%20principali%20opzioni%20di%20formattazione%20quando%20esporta%20una%20tabella%20dati%20come%20file%20Microsoft%20Excel%2C%20in%20particolare%3A%3C%2FP%3E%3CP%3E%26nbsp%3B-%20Larghezza%20della%20colonna%3C%2FP%3E%3CP%3E%26nbsp%3B-%20Tipo%20di%20dati%2C%20ad%20esempio%2C%20colonna%20numerica%20in%20JMP%20come%20numero%20in%20Excel%3C%2FP%3E%3CP%3E%26nbsp%3B-%20Formato%20delle%20colonne%20numeriche%3C%2FP%3E%3CP%3E%26nbsp%3B-%20Etichette%20di%20valore%3C%2FP%3E%3CP%3E%26nbsp%3B-%20Blocco%20scorrimento%3C%2FP%3E%3CP%3ENon%20deve%20essere%20perfetto.%20Forse%20il%20team%20JMP%20ha%20gi%C3%A0%20un'alternativa%20correlata%20a%20JMP%20Live%20alla%20condivisione%20di%20tabelle%20dati%20con%20utenti%20non%20JMP%20in%20modo%20pi%C3%B9%20intelligente%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-241861%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3EAltro%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Choose Language Hide Translation Bar
0 Kudos

Reproduce format when saving as an Excel file

In reality, unfortunately in my opinion, Microsoft Excel is still the de facto standard for exchanging table-formatted data. Even Google Spreadsheet now lets users work on Excel files, rather than forcing users to convert Excel files to Google's format. I personally often export JMP tables as Excel files for sharing them with "users" of my analysis.

I wish JMP respects major formatting options when it exports a Data Table as a Microsoft Excel file, specifically:

 - Column Width

 - Data Type, e.g., Numeric Column in JMP as Number in Excel

 - Format of Numeric Columns

 - Value Labels

 - Scroll Lock

It does not have to be perfect. Maybe the JMP team already have a JMP Live-related alternative to sharing Data Tables with non-JMP users in a smarter way?

1 Comment
Ryan_Gilmore
Community Manager
Status changed to: Archived
We are archiving this request. If this is still important please comment with additional details and we will reopen. Thank you!