dev-resources.site
for different kinds of informations.
Excel | Merged Cells Broken Up? Excel Keeps Crashing? Try to Update!
Published at
12/19/2024
Categories
excel
office
update
Author
01kg
TL;DR:
I have an Excel file,
.xlsx
, contains some spreadsheets, and many merged cells in each spreadsheets. Opens in computer A, works well. A has an Excel of version 2211The data in it is written by
openpyxl
package of Python.I copied the file to computer B, the excel version is 2209, opened it, all merged cells are broken up (unmerged, split up). Not only this, Excel crashed 3 times before opened it up.
Firstly, I though it is
openpyxl
's fault. No, it is wronged.Ended up some bugs related to this issue were fixed in versions above 22.09.
Update B's Excel (of course the whole Office actually), bump up to 24.11, opened the same file, all merged cells are back!
Articles
12 articles in total
moomoo | Open Singapore Account after USA Account Created
read article
Excel | Merged Cells Broken Up? Excel Keeps Crashing? Try to Update!
currently reading
Flutter Web | Build with .env File
read article
Supabase | My Way of Designing & Managing DB
read article
Mac Automator | Convert Any Image Type to JPG and Compress in Normal Quality
read article
.nrg | Pitfalls of Opening It in 2024
read article
Linux | Common Identifiers of Current Machine to Help Building License Mechanism
read article
VMware & Windows 7 | "Install VMware Tools" Greyed Out
read article
Flutter & Riverpod | How to Maintain the state of NavigationBar across tabs
read article
Snaplet & Supabase & Flutter | How to create a known user for testing
read article
Supabase | Seeding data: The Problem (ERROR: SQLSTATE 22021) and Solutions
read article
Supabase | How to add a user in SQL Editor
read article
Featured ones: