java - How to retrieve cell value with same result as displayed in Excel? -

-

i have following code:

workbook workbook = workbookfactory.create( file ); sheet sheet = workbook.getsheet( "sheet1" ); formulaevaluator evaluator = workbook.getcreationhelper().createformulaevaluator(); dataformatter formatter = new dataformatter( true );  int rownum = 0; int colnum = 0; row row = sheet.getrow( rownum ); cell cell = row.getcell( colnum );  double rawcellvalue = cell.getnumericcellvalue(); system.out.println( "raw value: " + rawcellvalue );  string cellvalue = formatter.formatcellvalue( cell, evaluator ); system.out.println( "formatted: " + cellvalue );

this produces output:

raw value: 1713.6 formatted: $1,713

when open file in excel professional 2010, value displays $1,714

excel screenshot

any ideas why poi produces different value excel? there way configure poi returns same value (i.e. obeys same rounding algorithm excel)?

i'm using poi 3.12 xls (excel 97-2013) file.

edit: java format cell $#,##0 (internal poi). here's excel shows:

excel's cell format dialog

edit 2: perhaps problem java, not poi. following code:

double number = 1713.6; system.out.println( "double   : " + number );  decimalformat format = new decimalformat("#0");  format.setroundingmode( roundingmode.half_down ); system.out.println( "half_down: " + format.format( number ) );  format.setroundingmode( roundingmode.half_up ); system.out.println( "half_up  : " + format.format( number ) );

produces result:

double   : 1713.6 half_down: 1714 half_up  : 1713

why half_down round up half_up round down?

see this answer. looks problem related rounding bug in version of java 8. fixed 8u40 (release notes).


Comments

Post a Comment

Popular posts from this blog

python - TypeError: start must be a integer -

-
i trying draw 5 turtles, getting typeerror on line 25. here code: import turtle wn = turtle.screen() redrose = turtle.turtle() color = input("what background color be?") fillcolor_f = input("what color of rose be?") redrose.hideturtle() redrose.speed(30) redrose.penup() redrose.left(180) redrose.forward(175) redrose.right(90) redrose.forward(30) redrose.right(90) redrose.pendown() def drawrose(red): redrose.color("pink") redrose.fillcolor(fillcolor_f) redrose.fill(true) in range(red): redrose.forward(i) redrose.right(49) in range(5): drawrose(redrose) redrose.penup() redrose.forward(350) redrose.right(144) redrose.pendown() redrose.fill(false) drawrose(50) wn.bgcolor(color) i trying draw 5 roses, produces errors. doing in interactivepython.org. you recursively calling drawrose wrong parameter. on line 23 ( for in range(red): ) expect red integer...
Read more

c# - DevExpress RepositoryItemComboBox BackColor property ignored -

-
i have following code almost works properly; private void cbstatus_drawitem(object sender, listboxdrawitemeventargs e) { string item = e.item string; if (item != null) { switch (item) { case "1": e.appearance.forecolor = color.green; e.appearance.backcolor = color.green; break; case "2": e.appearance.forecolor = color.orange; e.appearance.backcolor = color.orange; break; case "3": e.appearance.forecolor = color.red; e.appearance.backcolor = color.red; break; } } } when dropdown shown, items forecolor correct, backcolor remains whatever backcolor of theme is; i.e. if i've got set dark theme, backcolor dark, cells in gridview, rather being green/orange/red. i've tried setting e.appearance.options.usebackcolor trying set e....
Read more

django - Creating multiple model instances in DRF3 -

-
1) create multiple model instances 1 api call, asked here: how create multiple model instances django rest framework? tried solution named in link, no success. i trying upload multiple files in 1 api call. result: files uploaded (only once overwrote perform_create) 1 instance created (if send 2 files, latter created instance). my code: class fileuploadserializer(serializers.modelserializer): def __init__(self, *args, **kwargs): many = kwargs.pop('many', true) super(fileuploadserializer, self).__init__(many=many, *args, **kwargs) class meta: model = fileupload read_only_fields = ('created', 'datafile', 'owner') class fileuploadviewset(viewsets.modelviewset): queryset = fileupload.objects.all() serializer_class = fileuploadserializer parser_classes = (multipartparser, formparser, ) def perform_create(self, serializer): file_list = self.request.data.getlist('file') ...
Read more