Free Support Forum -

Subtotal method support other language?

code like this:

activeSheet.getCells().subtotal(area, 0, ConsolidationFunction.SUM, new int[]{2,3,4}, false, false, true);

一、户数统计 1 20 2222222 3333 2
一、户数统计 Total 0 20
Grand Total -1000.000 -980

how can I change the output “Total” and “Grand Total” from english to chinese?


Thanks for providing us screenshot and some details.

How could you do this in MS Excel manually? I do not think you can do this in MS Excel. If you think it is possible in MS Excel, kindly provide a sample file (in which you have performed SubTotal feature and you have converted “Total” and “Grand Total” strings from english to chinese via some MS Excel option(s)) with details, we will check on how to do it via Aspose.Cells APIs. For your information, Aspose.Cells follows MS Excel standards and specifications for different features, so if something is not possible in MS Excel, Aspose.Cells APIs also might not perform the same thing.

Thank you.

Hi Wu,

This is to update you that we have logged a feature request under the ticket CELLSJAVA-42042 to review your requirement for feasibility. As soon as we have the analysis results, we will post here for your kind reference.

Thanks for using Aspose.Cells.

This is to inform you that we have fixed your issue CELLSJAVA-42042 now. We will soon provide the fix after performing QA and including other enhancements and fixes.


Thanks for using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells for Java v16.10.6 and let us know your feedback.

Please try the latest fix with the following code:

class GlobalizationSettingsImp extends GlobalizationSettings { public String GetTotalName(ConsolidationFunction functionType) { return "统计"; } /// /// Gets the grand total name of the function. /// /// The function type. /// The grand total name of the function. public String GetGrandTotalName(ConsolidationFunction functionType) { return "总计"; } }

public class Test {

 * @param args
public static void main(String[] args) {
	// TODO Auto-generated method stub


		Workbook book = new Workbook( "book1.xlsx");
		book.getSettings().setGlobalizationSettings(new GlobalizationSettingsImp()); 
	}catch(Exception e)


The issues you have found earlier (filed as CELLSJAVA-42042) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.