Export: Cut and Paste from Table View to Excel
-
Our users are trying to export, using cut-and-paste, a multi-level Table View (shown in picture 1 of the attached file) to Excel xlsx.
The result obtained is in picture 2: as you can see, when copied to Excel, the detail rows mantain the correct numeric and percentage format while Total rows are not interpreted correctly: they are text and no more numeric values.
Our users need to use cut-and-paste because they would like to export also the total rows and these rows are not exported in Excel when the export function in admin menu is used.
Is there a solution to this problem? Why are the total rows are handled in a different way then detail rows?Attachments
Export.docx 145K -
4 Comments
-
Enrico - This issue is discussed here:
http://forums.visokio.com/discussion/2752/export-grouped-table-view-data-to-excels -
Thomas,
I made some tests:
1) I exported datas to excel using cut and paste with my Omniscope Local Data Settings set to Italian.
Elementary datas were exported with character ',' as (italian) decimal point and calculated totals were exported using character '.' as (english) decimal point.
2) I changed the Omniscope Local Data Settings to English and repeated the previous export. This time elementary rows were extracted using '.' as (english) decimal point while total rows were still extracted using '.' as (english) decimal point.
Then, it seems to me that total rows are unaffected by changing Local Data Settings and are pasted alway using English format.
This causes that my italian Excel installation is not able to recognize English style total rows.
Welcome!
It looks like you're new here. If you want to get involved, click one of these buttons!
Categories
- All Discussions2,595
- General680
- Blog126
- Support1,177
- Ideas527
- Demos11
- Power tips72
- 3.0 preview2
Tagged
To send files privately to Visokio email support@visokio.com the files together with a brief description of the problem.