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

Open the file and save it directly without making any changes. The line breaks of all cells are modified. #1473

Open
H0LIXI opened this issue Jun 5, 2024 · 1 comment
Assignees
Labels
bug Something isn't working

Comments

@H0LIXI
Copy link

H0LIXI commented Jun 5, 2024

EPPlus usage

Noncommercial use

Environment

Windows10

Epplus version

7.1.x

Spreadsheet application

Excel

Description

I used EPPlus to open Excel, modified some cells, and then saved.
After saving, I found that other cells that I did not modify were also changed.
And I found that all the changes were line breaks.

I have provided a test project, which contains a TestFile.xlsx.
After running in the project, TestFile-1.xlsx will be copied and saved using the Epp plug-in.
After running, you can use BeyondCompare to compare and view
TestEPPlusLineSymbol.zip

My BeyondCompare result like this.
image

@H0LIXI H0LIXI added the bug Something isn't working label Jun 5, 2024
@JanKallman
Copy link
Contributor

When you have \r\n as line break, it seems to be replaced by two \n\n. I will investigate some more and provide a fix.

@JanKallman JanKallman self-assigned this Jun 5, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants