Not Able to Write Last Cell in Pivot Table

[GalakFyyar]

I have the following code:

package main

import "github.com/tealeg/xlsx/v3"

func main() {
	f := xlsx.NewFile()
	sh, _ := f.AddSheet("Sheet1")

	// Write Colors (y-axis).
	colors := []string{"Red", "Green", "Blue"}
	for i, clr := range colors {
		cell, _ := sh.Cell(i+1, 0)
		cell.SetString(clr)
	}

	// Write Numbers (x-axis).
	numbers := []string{"1", "2", "3"}
	for i, num := range numbers {
		cell, _ := sh.Cell(0, i+1)
		cell.SetString(num)
	}

	f.Save("Bug.xlsx")
}

As you can see I'm trying to write three colors ("Red", "Green" and "Blue") as the Y axis.

However the resulting file looks like this, with the last color is missing.

Interestingly, I'm able to write the last color if I either write the X axis first, or don't write the X axis at all.

Go version: v1.18
Xlsx version: v3.3.7

Is this expected behaviour? Am I missing some sort of row allocating step?

[tobiashort]

Same here

	for idx, event := range events {
		col := idx+1
		eventColIndexes[event.ID] = col
		cell := Must2(sh.Cell(0, col))
		cell.SetDate(event.Date)
		cell.SetFormat("d.m.")
	}

	for idx, member := range members {
		row := idx+1
		memberRowIndexes[member.ID] = row
		cell := Must2(sh.Cell(row, 0))
		cell.SetString(member.Name)
	}

	for _, attendance := range attendances {
		row := memberRowIndexes[attendance.MemberID]
		col := eventColIndexes[attendance.EventID]
		cell := Must2(sh.Cell(row, col))
		switch attendance.Status {
		case AttendancePresent:
			cell.SetString("A")
			cell.GetStyle().Fill.PatternType = "solid"
			cell.GetStyle().Fill.FgColor = xlsx.RGB_Dark_Green
			cell.GetStyle().Font.Color = xlsx.RGB_Black
		case AttendanceLate:
			cell.SetString("H")
			cell.GetStyle().Fill.PatternType = "solid"
			cell.GetStyle().Fill.FgColor = xlsx.RGB_Light_Green
			cell.GetStyle().Font.Color = xlsx.RGB_Black
		case AttendanceExcused:
			cell.SetString("E")
			cell.GetStyle().Fill.PatternType = "solid"
			cell.GetStyle().Fill.FgColor = xlsx.RGB_Light_Red
			cell.GetStyle().Font.Color = xlsx.RGB_Black
		case AttendanceNotExcused:
			cell.SetString("X")
			cell.GetStyle().Fill.PatternType = "solid"
			cell.GetStyle().Fill.FgColor = xlsx.RGB_Dark_Red
			cell.GetStyle().Font.Color = xlsx.RGB_White
		}
	}

[tealeg]

Sorry for the delayed response. Looking into this now.

[tealeg]

OK, so the first thing to know is that if you reverse the order you write in (go breadth first) then the problem goes away. It appears that the final row doesn't get appended to the cellstore when we step back from it to the first row. Trying to find out why now.

[GalakFyyar]

Thank you @tealeg !