问题描述
我正在使用ruby Axlsx gem在xlsx中编写我的客户帐户数据.现在我将"Dr"字符串附加到所有借方金额中，这使得金额成为字符串，例如"1000博士".我想附加"Dr"，但金额仍应为整数，并且在选择列时excel应该在底部给出总和.
I am using ruby Axlsx gem for writing my clients accounts data in xlsx. Now I am appending " Dr" string to all debit amounts which is making amount as a string e.g. "1000 Dr". I want to append " Dr" but the amount should still be an integer and excel should give sum at bottom when column is selected.
我在做什么，请注意，即使选择:-，excel也显示右下角的sum = 0
What I am doing, notice that excel shows sum = 0 in bottom-right even on selecting :-
我在做什么，请注意，单元格在选择时仍然是字符串(880 Dr在选择单元格时应变为880.00):-
What I am doing, notice that cell remains a string on selecting (880 Dr should become 880.00 on selecting the cell):-
我想做的是，excel应该显示所选列的总和，如excel在右下角显示的总和= 1957.00 Dr:-
What I want to do, excel should show sum of selected colums as shown by excel in bottom-right sum=1957.00 Dr:-
我想做的是，双击该单元格应将其转换为数字(1341.00 Dr在选择时已变为1341)，但是在再次取消选择时Dr应该可见:-
What I want to do, the cell should be converted to number when double clicked (1341.00 Dr has become 1341 on selecting)but Dr should be visible on unselecting again:-
推荐答案
我通过使用自定义format_code
I solved this by using custom format_code
custom_format = sheet.styles.add_style(:format_code => "#.00 "Dr"")
这篇关于如何在Axlsx中格式化货币列?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！