Skip to main content

Thread: OpenOffice string formatting

-

ok, i've been beating head against wall trying 1 sorted out. have spreadsheet in open office, have bunch of fields 12 character alphanumeric strings. want these fields display mac address formatting like: 12:34:46:78:ab:cd.

if go format -> cells, if field full of numbers (with format string ##:##:##:##:##:##) doesn't work on text fields.

looking around i've found these formatting strings can separated sections semicolons different formatting depending on field content. officially oo's documentation says these fields are:

positive;negative;zero

investigating further suggests excel allows 1 step further of:

positive;negative;zero;text

tried giving format string of:

;;;##:##:##:##:##:##

format cell, instead of giving me field formatted mac address, quite literally string:

##:##:##:##:##:##

, can't seem find open office might take wild card can cell formatted. ideas? i'm hoping i'm missing obvious , indeed possible.

http://www.winko-erades.nl/index.php...id=10&itemid=5


Forum The Ubuntu Forum Community Other Discussion and Support Education & Science OpenOffice string formatting


Ubuntu

Comments

Post a Comment

Popular posts from this blog

CAN'T INSTALL MAMBELFISH 1.5 FROM DIRECTORY - Joomla! Forum - community, help and support

-
hi, i want install mambelfish 1.5 component in joomla! 1.0.4 stable [ sundial ] site, reason following error: failed create directory "/home/virtual/site13/fst/var/www/html/components/com_mambelfish/" i new joomla! , still not familiar it. great if build multilingual sites using joomla!. just clarify... media/ writeable administrator/components/ writeable components/ writeable images/stories/ writeable how install component? use  upload package file or use  install directory ? Board index Joomla! Older Version Support Joomla! 1.0 Extensions - 1.0.x Components
Read more

error: expected initializer before 'void'

-
whenever try compile code following error : 'error: expected initializer before 'void'' code: [select] #include <afmotor.h> af_dcmotor motor1(1, motor12_64khz); // create motor #1, 64khz pwm af_dcmotor motor2(2, motor12_64khz); // motor #2 void setup() {  serial.begin(9600);           // set serial library @ 9600 bps  serial.println("motor test!"); } void loop() { go(); backup(); halt(); }   void go() {  serial.println("all motors ahead - fast");    motor1.run(forward);  motor2.run(forward);  motor1.setspeed(255);  motor2.setspeed(255);  return; } void backup() {  serial.println("all motors backward - fast");  motor1.run(backward);  motor2.run(backward);  motor1.setspeed(255);  motor2.setspeed(255);  return; } void halt() {  uint8_t i;  for (i=255; i!=0; i--) ...
Read more

CPU load monitoring using GPIO and leds - Raspberry Pi Forums

-
Image
hello ! wrote today article on blog cpu load monitoring (using gpio , leds) on raspberry's. simple (written in little shell script), think can useful (for people want learn leds stuff on r. pi) there 5 leds turning on , off regarding cpu load: - cpu < 20%: 1 led - cpu < 40%: 2 leds - cpu < 60%: 3 leds - cpu < 80%: 4 leds - cpu < 90%: 5/5 leds - cpu >= 90%: 5 leds flashing here article: written in french, can watch youtube video , download code @ bottom of article. http://www.chteuchteu.com/2012/10/26/ra ... e-au-gpio/ if find errors in code, can post comment on article. ! up code enhancements ? raspberrypi
Read more