By: JimH
Date: 2014-09-26
Time: 13:52
|
BUG found in sheet with merged cells in multiple rowsI made a template where in one sheet it has 3 sections (3 headers of 2 rows and within some cells are merged)
When merging the first header is OK but the other 2 are screwed-up because the merged cells are kept in position of the original template instead of moving down like it should. If I do the same template (save as .osd) than all is working. But because I need the xlsx template I'm a little stuck for the moment. You easily duplicate this by making 1 header with merged cells + the row for the data [xxxx;block=tbs:row] and then copy this section again in the same sheet. See screenshot at https://drive.google.com/file/d/0B--6mfhr6ZuVbmU4WkVJVHRNLVU/edit?usp=sharing |
By: Skrol29
Date: 2014-09-28
Time: 23:27
|
Re: BUG found in sheet with merged cells in multiple rowsHi,
This is not really a bug, it is a know limitation. XLSX documents store merging informations into a separated XML entity. Thus with rows and cells are merged, the merging informations stay unchanged, they are fixed to absolute cells coordinates. I will try to manage this in a future version. For now the only solution is to use merged cells only above cells that will be merged. |
By: JimH
Date: 2014-09-29
Time: 07:50
|
Re: BUG found in sheet with merged cells in multiple rowsThanks Skrol29, i'm looking forward to all future releases. For now i will use OSD file type since that one is working fine.
|