Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Resetting chart style from premade template when modifying in program #27

Open
Adriantega12 opened this issue Jun 21, 2018 · 2 comments

Comments

@Adriantega12
Copy link

Hello everyone! Really happy about something like QXlsx existing but it seems to have an issue when modifying an existing file.

I have this template I made so I can modify it when needed and save it as a new file, but it seems that when loading it, QXlsx resets the style on my premade charts. (The template exists in first place so I can just insert data using code and the user can visualize the info dump later in the xlsx)

Is there a way around this or a fix coming?
Is there a way I can contribute to help fixing this? (As it is in my best interest)

Template:
imagen
Modified:
imagen

Thanks in advance!

@VSRonin
Copy link
Owner

VSRonin commented Jun 21, 2018

This happens because this library will actually re-create the file from scratch and anything that is not supported will be lost.

As a workaround you could open your previous file as a zip archive, save the contents of xl\charts\, edit the file using qxlsx, reopen the file as a zip and overwrite those files.
Having said that, this workaround only works for very simple charts, anything a bit involved might fail

@Adriantega12
Copy link
Author

@VSRonin Great! I'll try that and get back to you.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants