ActionScript 3.0 :: AIR Formatting Text To Write To A Spreadsheet?
Jan 15, 2010
I am creating a simple program which writes a string to a spreadsheet when it is copied to the system clipboard. Everything works great, except that if the text copied has multiple paragraphs and therefore has returns in it, when written to the file, they get interpretted as going to the next row of the spreadsheet. The, instead of writing all the text to one cell, the paragraphs get split up into multiple cells on multiple rows. How does one format the string so that paragraphs are still sepearated by a space, but it will write all of the text in one cell?
edit: Here's my code if it matters
Code:
stop()
Clipboard.generalClipboard.clear()
var file:File=File.desktopDirectory.resolvePath("communication of uncertainty data.ods");
var stream:FileStream = new FileStream();
Is it possible to create a contact form and have it saved onto an existing spreadsheet or xml file or text file on the hard drive without having to be connect to the internet?
I make RSS reader in flash. I have a text field and when I place RSS text and images in that text field I need to have a text in the new line after picture. But now I have image from the left and text from the right.
I'm building this flash site for a friend and he wants to be able to edit the contents and maintain the site by himself later on. So naturally, I used a dynamic text field that uses URLloader to link to an external html, dandy. Problem is, my friend wants to use dreamweaver to edit the contents of html (or even just a word document exported as html) and it's just driving him nuts because the text look nothing like that way it did in DW when it's loaded into the dynamic text field (extra spacing and line break popping up randomly everywhere). Is there an alternative solution other then telling him to just edit it in notepad? What if I switch over to XML?
make one word in a dynamic text field bold WITHOUT using the htmlText property? Everything I have read seems to indicate that you can only make the whole field bold.
I make RSS reader in flash. I have a text field and when I place RSS text and images in that text field I need to have a text in the new line after picture. But now I have image from the left and text from the right.
I'm trying to pull a variable from an ASP page that's pulling it's info from a database. The ASP page has a response.write that outputs &ScrollText = text that comes from the database. The ASP page works fine, but when I try to pull in the variable in Flash, it takes in all the html URL escapes, i.e.: %20 for a space %22 for a ", etc. I've tried using Server.URLEncode in my ASP page, but that didn't help any. I'm displaying this text in a dynamic text box with a scroll bar.
I'm looking for recommendations for a spreadsheet-like input facility to sit in an ASP MVC environment.
The client currently has a large number of very complex interlinked shared spreadsheets (which they are effectively running 90% of their core business from) for collecting and processing information. They wish to move this to a web application and require ASP MVC. They realise that they will not be able to display as much information on screen as they do currently with their spreadsheets, so a 40 x 60 grid should suffice in most cases. Of this they'll be a limited number of cells for data entry that will immediately update other cells in the grid using various spreadsheet-like formula. The grid must be AJAX enabled.
The quality of the user-interface is of primary concern here. As inevitably there will be a certain amount of resistance to move to database/web (and this project is a pilot anyway) the system must be as slick as possible. Almost as important is ease of implementation - the final system will be quite large so the quicker it is possible to configure the grid the better.
Either Open Source or commercial would be fine. HTML/Javascript, Silverlight and Flex implementations can all be considered.I initially asked a similar question a year ago (it's taken that long for the client to agree the project) but I'm sure options have changed since then and our environment is now better defined.
I'm playing around with a messaging type of application. Does anyone know how, or of any tutorials on to "appending" html text to text areas in flex and flex mobile projects? And specifically how I could take that and basically "append" a sprite inline to the text when i need to? Something simple like:Username: some text right here!So, Anyone have any experience "appending" sprites or simple text formatting?how to solve these issues!EDIT:Based on an answer below it was sugguested that it's as simple as...textAreaInstance.htmlText += "<b>Username:</b> some text right here!";But its not. you can't do .htmltext with a text area. you can on a text field, so i tried
var TF:TextField = new TextField(); TF.width = 200; TF.height = 200;
I am building a userinterface for some industrial instruments which output some data to a XML spreadsheet. This is the only way I can retreave these data's from the instruments.
Now, I need to make a flash that can pull out these data's from ex. "A1" and "A2" in this spreadsheet...
Here's a screenshot of the XML as it appears in EXCEL:
...and the XML as it appear if opened in Dreamweaver: Code: Select all<?xml version="1.0"?> <?mso-application progid="Excel.Sheet"?> <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
I am working on a project where I have made a Text Formatter by which I can format the text of three input text field.My formatter works fine, but the problem is that when I format the first text field it works good, but in the second or third textfield I have to press the formatting button twice for each format option (such as bold , italic or alignment).Another problem is that when I reopen the formatter it format the text field with last option I have used.
I'm trying to format an XML file so I can have HTML tags on it for bold, italic, underline, etc... but its not working. When I'm not using any HTML tags my subtitle works great but when I put the tags the player reads the time tag not the sutitle!!
i have set a textfield's text from an XML and now I am trying to format it with css. the xml text loads all fine and the css loads but they are not working together.
[Code]....
i am not too familiar with css or html but studied up on css and based on all of the searching i did i am not able to find out what i am doing wrong here. do i need to set the xml with standard html language/nodes?
I have a file where I am importing info from an XML file using atttributes. It works fine, except I no longer want the font to be embedded. I want to either call if in from a stylesheet or set it in the actionscript, so it uses same arial or san serif used on the rest of the web site it is a part of.
my code.......
var myImages:Array = new Array(); var myXml:XML = new XML(); //
I need now is, to load it and format certain parts of it automatically.For example, I have a blog with lots of posts, and the posts are:
---------begin------- TITLE DATE Content ----------end--------
And so, I need the title and the date to be one font, with different colors between them, and the content is another font, on a third color.I have to do this because I've been putting the posts directly inside flash, and they got so long after a while, that I can't have all of them on my screen at any one time, they exceeded flash's height limit...so, to edit the older ones, I need to keep scrolling everything up, which is a pain.
I'm running into issues with using HTML formatting for a dymanic text field. I know these are quirky and I cannot figure out how to get the formatting proper.I have on my stage a dynamic text box called "content_txt" inside of a movie clip instance "content_mc". When it enters the frame, I fade the "content_mc" from alpha 0 to 100 using a timeline animation. In order for this to work, I have to embed the font in my "content_txt" text field. However, the only way I get get the HTML formatting to work is if I do not embed the font.
The dymanic text field is set to render as HTML. In my actions layer, I set the text:
this.content_mc.content_txt.htmlText = "<b>Hello world,</b> it is me again."
In summary: 1. If I do not embed the font, the alpha fade does not work but the HTML formatting does.
2. If I embed the font, the alpha fade works but the HTML formatting does not.
I have a dynamic TextField with very wide letter spacing in my .fla. However, whenever I change the text in the TextField using actionscript, the letter spacing resets. Is there a way to keep that from happening? And why does it happen in the first place
basically I have an admin flex page that allows the user to enter text into database. Then the frontend app will take the database entries and display them to the user. However there is no formatting. Do I need to insert html into the database then read that html again?For the user using the admin, they probably wont know html, so is there a simpler way to format?
I have two text boxes on the same window. They are both set to Arial 14 Regular but they both appear very differently. To see what I am referring to: [URL] and go to the Conversion Tools at the bottom of the page. Click on Surface Finish and type in a value in the two different fields and click calculate. I really don't see anything that could be causing this difference in appearance.
If I create an html textfield and give the text the bold tags, when I run a getTextFormat() the bold returns null. Here is the scenario I made up to replicate this.
1. I created a textfield where I set the html text to
Code: <b>Some bold text</b>
2. I take the html formated text from the first textfield which is
is there a way to add formatting to dynamic text, e.g. make stuff bold, add a new paragraph, what should i search Google, are there any good websites? notes.text = "Baetica and Lusitania: Roman possession of Spanish territory began with the Second Punic War."i need to know how to make "Baetica and Lusitania" bold, and add a new line after the colon.
I am struggling with TLF text, I searched and searched and can't find a GOOD tutorial or complete method on how to format TLF text with AS3, I need to:
- Load dynamic text into dynamic TLF text field - Set custom fonts - Set formatting including letter spacing, margins, leading, sharpness - Set links, link hoover color, link decoration - Get a method that supports HTML tags (those supported by Flash CS5)
tutorial, book, e-book that explains all the steps needed to set, format and control TLF text?
I need something that explains how to do this, logically, step by step, I'm a designer not a programmer
I'm importing text via an XML file that will then be displayed in a dynamic text field. The text is about 1 sentence long but one of the words in the sentence must be bold and a different color. So I've added some HTML tags in the XML node to change the color and format but when I test the file the html tags show in the dynamic text field and the text is NOT formatted.[code]Am I not using the CDATA tag properly? Or do I need to change something in the way I call up the data in the xml node?
I have a dynamic text box that holds text and shows images using the <img> tag.all works fine - however <br> or <p> will not put the next lines of text under the image... you have to keep adding them until there are enough this isnt good for dynamic text boxs if I dont know how many lines to add.
