Does aspose cells editor support fill colour on graph and images?

Aspose.Cells Product Family
31

@chetanepiq
the latest client and server is match ,and works without images loading issues per our release test.

32

So you mean Does aspose cells editor support fill colour on graph and images? - #27 by chetanepiq

client and server both should be 25.11 only ?

Also please provide the access to Example file you shared

33

@chetanepiq
Please create a new topic for your issue,only the orginal topic owner can access the attached file.

34

Lets continue on this , I can ask the owner to share file
UPDATE
I have kept client side package “gridjs-spreadsheet”: “^25.11”,
And server side also the same but its still showing same error .

35

@chetanepiq
replace the sample file in your project ,and verify the structure of the zip file get in your side.

36

the structure of the zip file shall like this:

37

@chetanepiq
and also can you test the sample project in your side .
watch and compare the network steps for loading images.
I have no idea how to help you without your sample project in my side.

38

Tested the same file you said ,
image.png (2.2 KB)

Examples_GridJs.Simple.zip (197.5 KB)

The blob api’s in network tab are not getting triggered for me in our project.
image.png (3.4 KB)

39

@chetanepiq
so manully download and check the structure of the file : 6-13.s0_batch.zip
what does it contains.

40

Yeah , that is just bringing one excel file that I clicked to view

ZIP.zip (2.2 KB)

41

@chetanepiq
So, this is not working as expected. it shall result zip file that contains image files. Please check this api in your controller

42

But same is happening with the lower version, I don’t think that is the issue.
Even with lower version manually downloading the same api brings the excel file as there are changes made in aspose-cell backend by us, so there are differences.
The blob api’s are getting called internally from client side I believe we haven’t written code for it. That comes fine with lower version but not with 25.x client side.

43

@chetanepiq
The image loading steps and behavior is changed from v24.x to v25.x, so please check this API and follow to the latest demos .
it shall be like:

 private string GetMimeType(string FileName)
 {
     string contentType;
     new FileExtensionContentTypeProvider().TryGetContentType(FileName, out contentType);
     return contentType ?? "application/octet-stream";
 }

 // GET: /GridJs2/GetFile?id
 //only in my side my enviroment ,I have removed filenme parameter to match exactally with action method,it is strange
 public FileResult GetFile(string id)
 {
     string filename = null;


     string fileid = id;
     string mimeType = filename != null ? GetMimeType(filename) :GetMimeType(fileid);
     string name = filename != null ? filename : fileid.Replace('/', '.');
 
     return File(GridJsWorkbook.CacheImp.LoadStream(fileid), mimeType, name);
 }

or if your controller extends GridJsControllerBase, you can check the above sample project I provided.

44

hi @peter.zhou can we connect on the call and get the issue sorted?
Along with @chetanepiq @purushothamj @sarathepiq

Looking forward for your support and response.

Thank you,
Ganesh Kumar.

45

We have been using something like this

    public InputStream getFile(String fileid) {
        return GridJsWorkbook.CacheImp != null ? GridJsWorkbook.CacheImp.loadStream(fileid) : null;
    }

Only difference I can see is mimetype.

46

@chetanepiq
please run my sample project, you can see the response for the file request for the zip shall result the zip file which contains the image files,this is root cause,so try to fix it in your controller api.
in your local cache implementation code which implement GridJs cache,you can debug more info for get file and write file .

47

@Ghani0303
my teams id is
difeijin@qq.com

48

@peter.zhou
In the demo site i am trying to fill the color on the graph but the color gets filled into a cell and not on the chart.

image.png1675×625 53.1 KB
image.png (53.1 KB)

49

@jupudiepiq

The function to set the chart background color has been implemented in GridJs v25.11, and the online editor app will be updated to the latest GridJs version in the coming days.
You can use the latest version of GridJs through the demo project to try this feature, or wait for the new version of the online editor app to be updated before trying.

50

@jupudiepiq,

The online editor app has been upgraded to Aspose.Cells.GridJs 25.11 and you can apply background color of the charts using fill color icon/tool now.

1 Like