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.
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.
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.
Please try the latest fix with the following code:
Java
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
try
{
Workbook book = new Workbook( "book1.xlsx");
book.getSettings().setGlobalizationSettings(new GlobalizationSettingsImp());
}catch(Exception e)
{
e.printStackTrace();
System.out.println(e.getMessage());
}
}