Categories > OpenTBS with XLSX >

BUG found in sheet with merged cells in multiple rows

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs
By: JimH
Date: 2014-09-26
Time: 13:52

BUG found in sheet with merged cells in multiple rows

I 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 rows

Hi,

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 rows

Thanks Skrol29, i'm looking forward to all future releases. For now i will use OSD file type since that one is working fine.