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

After SpliceRows, shifted rows lost cell names #305

Open
supermyz opened this issue Apr 20, 2017 · 5 comments
Open

After SpliceRows, shifted rows lost cell names #305

supermyz opened this issue Apr 20, 2017 · 5 comments

Comments

@supermyz
Copy link

supermyz commented Apr 20, 2017

Hi
Thanks for this great lib, helps a lot, here is the issue: the shifted rows lost information, not just the names but also their styles

var workbook = new Excel.Workbook();
workbook.xlsx.readFile(filename).then(function() {
    let worksheet = workbook.getWorksheet(1);
    worksheet.spliceRows(5, 1);
    workbook.xlsx.writeFile(filename).then(function() {
        console.log('file saved');
    });
}).catch(function(err) {
    console.log(err);
});
@sngsweekeat
Copy link

I'm seeing the same problem - I basically want to insert new rows, but all rows from the insertion point down lose all their styles.

@FluffyNevyn
Copy link

I am also seeing this issue - glad I checked the open issues before submitting a new one. After a call to worksheet.spliceRows(...) any rows that get Moved lose all style information (font, fill, border, etc...)

@iva2k
Copy link
Contributor

iva2k commented Jan 29, 2021

Should this issue be closed? (PR with a fix was merged)

@nhd2106
Copy link

nhd2106 commented Jul 6, 2022

I am also seeing this issue - glad I checked the open issues before submitting a new one. After a call to worksheet.spliceRows(...) any rows that get Moved lose all style information (font, fill, border, etc...)

i still got this issue, i'm using lastest version

@baelene
Copy link

baelene commented Jun 28, 2023

I have also the issue with merged cells: after spliceRows, the merged cells below the deleted rows are not (merged) anymore.

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

6 participants