Win a copy of Svelte and Sapper in Action this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Bear Bibeault
  • Junilu Lacar
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • salvin francis
  • Frits Walraven
Bartenders:
  • Scott Selikoff
  • Piet Souris
  • Carey Brown

Download Excel with pivot table IE appending [1] to file name

 
Ranch Hand
Posts: 88
Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,




But when I am directly opening from IE with out saving , IE adding [1]/Version to file name

Example:Test.xlsx file in backend but when i am opening the file its renamed to Test[1].xlsx.And this is creating the issue.

Can any one suggest what I am doing wrong here.

Thanks!!
 
Bartender
Posts: 9615
16
Mac OS X Linux Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I've noticed this when downloading a file when a file with the same name already exists in the destination directory. Since you aren't saving the file first, the existing file is probably in a temporary directory (as opposed to a "user" directory you would be familiar with, like %USERNAME%\Downloads)
 
RatiKanta pal
Ranch Hand
Posts: 88
Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello Jos,
Tried that too.Clean up all the file in temp and download again.But IE is maintaining some kind of version which always starts with "[1]".Which leading to crash of excel with pivot table.
 
RatiKanta pal
Ranch Hand
Posts: 88
Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I asked this question on MS Forum This was the reply i got.

Excel is crashing because of the invalid special characters in the name of the file. This is clearly seen in the below snapshot with the description of what all characters are considered invalid. If we try saving a new Excel file in Excel 2013 as Test[1].xlsx (with square brackets) and some content in it, then we get the below message. So after renaming the file without these characters, it fixes the issue.
 
Question: Why does Excel care what the file’s name is on the file system?”
 
Answer: Because it denotes the workbook name in any link paths. Therefore it will mess up parsing links which then gets into messing up calculation.
 

When I try to download a excel file from .net application its not appending [1] version after the file name ..But our application based on java.Its causing the issue .


Can any one help me on this.

 
please buy my thing and then I'll have more money:
the value of filler advertising in 2020
https://coderanch.com/t/730886/filler-advertising
    Bookmark Topic Watch Topic
  • New Topic