search envelope-o feed check
Home Unanswered Active Tags New Question
user comment-o

[Excel export] Cannot merge already merged cells

Asked by Leo
21 days ago.

Hi Dan,

Thanks for the latest update. Just to keep you up-to-date and because the other ticket was closed automatically:

The bug for Excel exports in DayPilot.Gantt mentioned here still exists in 2025.3.6646.

Cheers
Leo

Answer posted by Dan Letecky [DayPilot]
21 days ago.

Hi Leo,

Thanks for the update. This issue should be fixed now in the latest sandbox build (2025.3.6647).

Please let me know if the problem persists.

Comment posted by Leo
21 days ago.

Hi Dan,

Unfortunately, it does not. However, the documented change is for the Scheduler, not the Gantt?

Cheers
Leo

Comment posted by Dan Letecky [DayPilot]
21 days ago.

The Gantt chart uses Scheduler internally, so the change applies to it as well.

I’m not able to reproduce the problem with the following config anymore:

dp.scale = 'Week';
dp.cellWidth = 100;
dp.useEventBoxes = 'Never';
dp.cellDuration = 1440;
dp.cellGroupBy = "Month";
dp.cellWidth = 100;
dp.cellWidthSpec = "Fixed";
dp.timeHeaders = [
    {groupBy: "Month", format: "MMMM yyyy"},
    {groupBy: "Week", format: "d"}
];
dp.useEventBoxes = "Always";
dp.days = 300;

Sometimes, the old version of the library gets cached so you can verify that.

If the problem still persists, could you please post a full config that reproduces the problem?

Comment posted by Leo
16 days ago.

Hi Dan,

unfortunately, the issue persists for me, even when not having any events - so it must be the config. However, the only change to other configs I have (that do export correctly) are the values already provided.

We also add cssClasses and HTML, but I don’t see how that would impact the error:

if (args.header.level === 0) {
	args.header.cssClass = 'header_month';
}

if (args.header.level === 1) {
	args.header.cssClass = 'header_week';
	args.header.html =
		'Week ' +
		(this.week_number_algorithm === 'ISO8601'
			? args.header.start.weekNumberISO()
			: args.header.start.weekNumber());
}

Do you have an idea what other configs might cause this?

Comment posted by Dan Letecky [DayPilot]
15 days ago.

The header content doesn’t have any effect on this error. The error was caused by overlapping cells produced by headers that don’t match the grid. But that was fixed already.

Could you please take a look at this demo? It uses your config but it doesn’t produce any error (it used to throw an exception with the last release). Could you try to modify it so that it reproduces the problem?

Comment posted by Leo
6 days ago.

Hi Dan,

You were right, today’s release fixes the issue. It must have been a NPM caching issue that it persisted for me.
Apologies for the extra work I caused!

Cheers
Leo

Comment posted by Dan Letecky [DayPilot]
6 days ago.

Hi Leo,

Great, thanks for the update!

New Reply
This reply is
Attachments:
or drop files here
Your name (optional):