Hi,

I think Laurence has already told you. We will try to make it before March 2008.

Thanks for being patient!

---

Amjad Sahi
Support Developer,
Aspose Nanjing Team
Contact Us

Hi,

Yes, I know she told me a month ago - I just wanted to know if there was a more detailed estimation a month later. Thanks for your response.

Keep up the great work!

Hi,

Well, he (Laurence) told you not she..........Never Mind! :)

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Nanjing Team
Contact Us

Hi,

I figured I will let you know some of our ideas of how it could work while you are developing it:

1. There should be an unlimited number of sub-groups and each sub-group could have their own sub-group

2. We should be able to put some kind of code or tag or id of the parent in the excel sheet to link the two -that way we will be able to format everything in excel and place the main table and all subs whereever we would like in excel

Thanks!

Hi,

I see that you released a new version for Aspose.Cells --- does it have this feature we were speaking about? (I cannot find the updates on the documentation)

Thanks!!!

No, this feature is still not supported yet. But we have put it on the top of our work list.

---

Laurence Chen
Chief Architect
Aspose Nanjing Team
About Us
Contact Us

Hi,

Thanks for keeping in touch,

We are in the final phase of the features. Hopefully, we may be able to release the related version soon.

Thanks for being patient!

---

Amjad Sahi
Support Developer,
Aspose Nanjing Team
Contact Us

Hi,

Please try this fix.

---

Warren Zhang
Developer
Aspose Nanjing Team
About Us
Contact Us

H,

Please replace SmartMarkerDesigner.xls with the attached xls file in demo project.

In e_group.doc, we list some supported type and sutotal type.

---

Warren Zhang
Developer
Aspose Nanjing Team
About Us
Contact Us

Hi,

I tried it out - it's great :) You guys are truly amazing - it has exceeded by expectations.

Just to make sure I understand -

a. we can use group:normal or group:repeat or group:merge....with a skip that says how many rows to skip in between each group (great feature)

b. subtotalN --- uses Excel's built-in 11 functions (great feature)

c. subtotalN:table.colA --- does the subtotal based on the column

I have three questions:

1. Just for us to know - can we group the subtotal by more than two columns? (just for us to know)

2. Is there a way to format the subtotals? Maybe bold or something like that....

3. Is there a way to get a grand total on bottom - is that just a SUM under these rows?

Thanks for all your work! Aspose is the best!

Hi，

1，please use subtotalN:table.colA&table.colB to subtotal A and B columns.

2, We will look into this feature. Do you want to set the font be always bold or you want to set it by yourslef?If you want to set it by yourself, we think maybe we have to change our desiger. The subtotal smart maker should be in the next row, then we can simply know which style you want to set for subtotal cells.

3,If you want to add a grand total on bottom, please add it in the template file.Please check Cell C6 of Worksheet "Table Group" in previous attached demo xls file.

By the way ,after each group in Excel, the cell value is "xxxx total" in the subtotal . Do you need it?  I don't know how to process it if the group type merge.

---

Warren Zhang
Developer
Aspose Nanjing Team
About Us
Contact Us

Hi,

1. Is there a way to subtotal more than 2 columns (just asking)?

2.

a) Is it possible for now just to Bold it?

b) If we wanted to do it ourselves, we would need to put it on separate line? Or you would put it on separate line?

3. I see - Subtotal ignores other subtotals - excellent!

4. "By the way ,after each group in Excel, the cell value is "xxxx total" in the subtotal . Do you need it?  I don't know how to process it if the group type merge." --- I don't understand this statement ?

Thanks! Great feature!

Hi,

1, yes.

2. We are looking into put it on separate line.

4, Please see attached xls file. The cell C6 value is "Tom Total". In our current version, the cell C6 will be empty.

---

Warren Zhang
Developer
Aspose Nanjing Team
About Us
Contact Us

Hi,

We have supported 2.Please try this fix.

 

---

Warren Zhang
Developer
Aspose Nanjing Team
About Us
Contact Us