java - How to change font on XSSFTextBox -


xssftextbox , xssfrichtextfield's

edit see comment; apache poi seems racist, black not supported? red is?

edit 2 : instead of using xssfcolor use constants in font, have red , black; looking default fonts (just clear code correctly displays color , size now, font name/ actual font still wrong. font.color_normal works dat black)

for reason can't xssftextboxs' texts' fonts , font colors change (i assume) default calibri white (why white default?!?). sizes changed, font , font color stay defaults. have found previous bug should fixed here.

i've been looking @ this reference base how change font, , seems how it's done, doesn't seem working; i'd love set of eyes on this, there other minor problems i'm still fiddling with, font implementation biggest thing right now; criticisms welcome , wanted!

what irks me i've used xssffont xssfcellstlyes before, quite extensively, , have never had problems changing fonts or colors, let alone else, don't know if it's strange behavior i'm not seeing or if i've done incorrectly here.

code

package excelhandling;  import java.awt.desktop; import java.io.*; import javax.swing.joptionpane; import org.apache.poi.ss.usermodel.*; import org.apache.poi.xssf.usermodel.*;  /**unit tests<br>to test random things figure them out can implement them  * in real code later; ideal test kinks here whole application  * doesn't have loaded on , on figure small issues out (living dream)  *   * @author sean newell  */ public class unittests {      static string filename = "testworkbook.xlsx";      public static void main(string[] args)     {         xssfworkbook wb = new xssfworkbook();         xssfsheet sht = wb.createsheet();         file file = new file(filename);         int colstart = 5;          xssfdrawing draw = sht.createdrawingpatriarch();          xssfshapegroup group = draw.creategroup(draw.createanchor(0, 0, 0, 0, colstart, 11, colstart + 6, 11+7));         group.setcoordinates(colstart, 11, colstart + 6, 11+7);          xssftextbox tb1 = group.createtextbox(new xssfchildanchor(0, 0, 6, 7));         tb1.setshapetype(shapetypes.rect);         tb1.setnofill(false);         tb1.setfillcolor(255, 255, 255); //this causes excel repair xml - don't know why;         //following message excel:         //repaired records: drawing /xl/drawings/drawing1.xml part (drawing shape)         //log:  //      <?xml version="1.0" encoding="utf-8" standalone="true"?> //      -<recoverylog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"> //          <logfilename>error094800_07.xml</logfilename> //          <summary>errors detected in file 'h:\my documents\netbeansprojects\templatebuilder\testworkbook.xlsx'</summary> //              -<repairedrecords summary="following list of repairs:"> //      <repairedrecord>repaired records: drawing /xl/drawings/drawing1.xml part (drawing shape)</repairedrecord> //          </repairedrecords> //      </recoverylog>          xssfrichtextstring address = new xssfrichtextstring("textbox string 1\nhas three\nlines it");          xssffont arial10 = wb.createfont();         arial10.setfontname("arial"); // doesn't seem work         arial10.setfontheight(10);         arial10.setcolor(new xssfcolor(java.awt.color.black)); // doesn't seem work         address.applyfont(arial10); // possible problem?          tb1.settext(address);         tb1.setlinestylecolor(0, 0, 0);         tb1.setlinewidth(2);           xssftextbox tb2 = group.createtextbox(new xssfchildanchor(0, 7, 10, 13));         tb2.setshapetype(shapetypes.rect);         tb2.setnofill(false);         tb2.setfillcolor(254, 254, 254); //this causes excel repair xml - don't know why         xssfrichtextstring secret = new xssfrichtextstring("a single-line thing has like, lot of text, can wrap , smaller, like, totally.");          xssffont arial8 = wb.createfont();         arial8.setfontname("arial"); // doesn't seem work         arial8.setfontheight(8);         arial8.setcolor(new xssfcolor(java.awt.color.black)); // doesn't seem work         secret.applyfont(arial8); // possible problem?          tb2.settext(secret);         tb2.setlinestylecolor(0, 0, 0);         tb2.setlinewidth(2);          try {             fileoutputstream fout;             fout = new fileoutputstream(file);              wb.write(fout);             fout.close();              joptionpane.showconfirmdialog(null, "excel sheet written");             desktop.getdesktop().open(file);          } catch (ioexception exc) {             joptionpane.showinputdialog("please close other instances of excel have " + filename + " open");         }     } }

this quite crude, in poi 3.9 seems font family not font name copied xssffont object in xssfsimpleshape.applyattributes. furthermore set indexed colors via xssfcolor.setcolor(hssfcolor.<color>.index) - maybe there xssf-pendant hssf custom color palette, think below approach more straight-forward ...

(tested libre office 4.0, ms excel viewer, ms excel 2003 compatibility pack ...)

import java.awt.color; import java.io.*; import org.apache.poi.xssf.usermodel.*; import org.openxmlformats.schemas.drawingml.x2006.main.cttextcharacterproperties;  public class xlscolors {      static string filename = "testworkbook.xlsx";      public static void main(string[] args) throws exception {         xssfworkbook wb = new xssfworkbook();         xssfsheet sht = wb.createsheet();         file file = new file(filename);         int colstart = 5;          xssfdrawing draw = sht.createdrawingpatriarch();          xssfshapegroup group = draw.creategroup(draw.createanchor(0, 0, 0, 0, colstart, 11, colstart + 6, 11+7));         group.setcoordinates(colstart, 11, colstart + 6, 11+7);          xssftextbox tb1 = group.createtextbox(new xssfchildanchor(0, 0, 6, 7));         tb1.setlinestylecolor(0, 0, 0);         tb1.setlinewidth(2);         color col = color.orange;         tb1.setfillcolor(col.getred(), col.getgreen(), col.getblue());          xssfrichtextstring address = new xssfrichtextstring("textbox string 1\nhas three\nlines it");         tb1.settext(address);                 cttextcharacterproperties rpr = tb1.getctshape().gettxbody().getparray(0).getrarray(0).getrpr();         rpr.addnewlatin().settypeface("trebuchet ms");         rpr.setsz(900); // 9 pt         col = color.pink;         rpr.addnewsolidfill().addnewsrgbclr().setval(new byte[]{(byte)col.getred(),(byte)col.getgreen(),(byte)col.getblue()});          fileoutputstream fout = new fileoutputstream(file);         wb.write(fout);         fout.close();     } }

Comments

Post a Comment

Popular posts from this blog

php - cannot display multiple markers in google maps v3 from traceroute result -

i'm newbie in php mysql , google maps v3. have problems in google maps v3. made traceroute web based , map traceroute's result in google maps v3 final project of college education. have try many tutorials didn't work. have tried tutorials in forum nothing worked. problem cannot display multiple markers got location data database. maybe because i'm newbie , not know how do. confuse looping show markers. here code <?php error_reporting(e_all ^ (e_notice)); ini_set('max_execution_time', 360); $enable_log_user = false; global $ip, $host_name, $host_ip; $host = @$_post['host']; $trace = @$_post['trace']; $self = $_server['php_self']; include("phpsqlajax_dbinfo.php"); $connection = mysql_connect ('127.0.0.1', $username, $password); if (!$connection) { die('not connected : ' . mysql_error());} $db_selected = mysql_select_db($database, $connection); if (!$db_selected) { die ('can\'t use db : ...
Read more

c# - DetailsView in ASP.Net - How to add another column on the side/add a control in each row? -

i have detailsview control on page used edit various fields of record, works in respect. i looking way add 1 column (and if works, why not more) right, absolutely read-only, show same fields of record comparison purposes. i aware there no obvious way such thing out of box detailsview . have looked other controls (transposed gridview , recommended formview , listview ), nothing satisfies. have special data binding setup using detailsview , can't out of without losing features. anyone on how "hack in" additional columns (for display only) on detailsview ? the solution have now, use second detailsview , visible set false in aspx. in code, make sure databind hidden detailsview hosts data third column first, initial detailsview named itemdetails . and in item created event, pass third column html rendering of hidden controls (in last code block) : protected void itemdetails_itemcreated(object sender, eventargs e) { if (dataite...
Read more

javascript - firefox memory leak -

i have following script (i use raphaeljs also) draws circle, waits 1 second, draws circle again, etc (you can copy paste - functional, need include raphael raphaeljs.com): <div id="holder"> </div> <script src="raphael.js" type="text/javascript"></script> <script> var paper = raphael(10, 50, 320, 200); var rad = math.pi / 180; var finangle = 0; function sector(cx, cy, r, startangle, endangle, params) { var x1 = cx + r * math.cos(-startangle * rad), x2 = cx + r * math.cos(-endangle * rad), y1 = cy + r * math.sin(-startangle * rad), y2 = cy + r * math.sin(-endangle * rad); return ["m", cx, cy, "l", x1, y1, "a", r, r, 0, +(endangle - startangle > 180), 0, x2, y2]; } var path = sector(100,100,50,0,180); var arc = paper.path(path); function draw() { path = sector(100,100,50,0,finangle); ...
Read more