Menu

Decimal being created

Brian
2020-02-01
2020-02-01
  • Brian

    Brian - 2020-02-01

    Hi
    By going to >> Fomat Cells >> set Decimal places to 0 and tick commas
    Then using this formula in a cell with data we get decimals
    =A1(1+Sheet2!A1:A1)
    or
    =A1
    (1+38.90%)
    add any number to A1 cell(our example for attachment below is 17,862)
    In excell we see 24,810 for our formula answer, in webpage we see 24810.318 << plus no commas

    Is it meant to do this, or its a limitation? As the excell page has no decimals. Only seems to do it to formulas
    Test file below

    Plus im just using XLSX to html table example

    <?php
    if ( $xlsx = SimpleXLSX::parse('Book2.xlsx') ) {
        echo '<table border="1" cellpadding="3" style="border-collapse: collapse">';
        foreach( $xlsx->rows() as $r ) {
            echo '<tr><td>'.implode('</td><td>', $r ).'</td></tr>';
        }
        echo '</table>';
        // or $xlsx->toHTML();  
    } else {
        echo SimpleXLSX::parseError();
    }
    ?>
    
     

    Last edit: Brian 2020-02-01
  • Alexandr Belyak

    Alexandr Belyak - 2020-02-01

    Hi,
    Perhaps you made a mistake with the project site? The C++ library SimpleXlsxWriter is discussed here :-)

     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.