Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Not Able to Write Last Cell in Pivot Table #809

Open
GalakFyyar opened this issue Jul 2, 2024 · 0 comments
Open

Not Able to Write Last Cell in Pivot Table #809

GalakFyyar opened this issue Jul 2, 2024 · 0 comments

Comments

@GalakFyyar
Copy link

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.
Screenshot 2024-07-02 014138

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?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant