Excel formula plugin?
Submitted by
stuckfly on
Tuesday, 25 April, 2006 - 14:46
I don't know about Excel 2007, but the current and previous versions do not have an efficient text editor for entering complex formulae into spreadsheet cells.
You can use alt-enter for line breaks and spaces to indent, and Excel color codes cell references and parentheses, but each line break and space counts against the maximum formula length limit of 1024 characters.
Entering nested conditional formulae quickly becomes confusing, and editing someone else's work can be very difficult. A code editor that recognizes Excel formula syntax, handles indenting of nested functions, color codes things better than Excel's formula bar, and allows comments would be very handy, especially to keep formulae concise. It should count characters (but not line breaks and indents) and enable single-click to copy all to Excel sans breaks and indents and comments. One could save the formula code with comments to a text file for later use.
I've heard Excel 2007 eliminates the formula length limit and nested function level limit. Unless Microsoft is already building a text editor into Excel for formula entry, a jEdit plugin for this will become a very popular tool I think.
jEdit cleanup
Submitted by
metric152 on
Thursday, 27 April, 2006 - 01:11
I've been using jEdit for the last two weeks and it's a great program.
It seems a little sloppy about cleaning up the temp files (*.ext~) when the program closes.
Is there any way to have the program delete those on exit, or do I have to remove them by hand?
How can I load a Buffer
Submitted by
zhang_tx on
Thursday, 27 April, 2006 - 13:40
I'm writing a plugin for jEdit. In the plugin, I need to get File content by path, My code like this:
Buffer _buffer = jEdit.getBuffer(path);
String content = _buffer.getText(0, _buffer.getLength());
but this code caught NullPointException.
Then I found that the _buffer is unload:
_buffer.isLoad() = false;
so my question is how can I get a Buffer by path and load it,
or how can I get File content with the file path.
I'm the beginner in JEdit plugin develop, I hope if some kind man can help me with this problem, SOS, whoever you are, thank you very much!
Highlights the current function in CodeBrowser
Submitted by
Manil on
Thursday, 27 April, 2006 - 19:28
Hi all,
I want to know, if we can have a highlight on a current function in CodeBrowser, it will be usefull to know where we are in the code when we are editing a function. I don't think it's a hard thing to implement juste locating the position of the pointer and comparing it to the position of the functions....So if anyone thought about it, can you let me know or may be i can try to implement it, but i'll need to be in the developpement team probably...
Thx for any answer
How can I use a single buffer to load file content from several files(more than one)
Submitted by
zhang_tx on
Friday, 28 April, 2006 - 02:17
I'm trying to write a plug in for file content analyse, and I need to show contents of several files(more than one) in a single buffer, I tried a lot, but I can not do this job successfully, because the file to open is very big, so I want to use jEdit's Buffer object to do job, can some one give me any advice?
I tried to do in this way:
1. open each file I want to use by:
Buffer buffer = jEdit.getBuffer(aPath);
if (buffer == null) {
Hashtable props = new Hashtable();
buffer = jEdit.openFile(null, null, aPath, false, props);
} else {
// close if this buffer is currently
// visible in the view.
//if (buffer != null){
EditPane[] editPanes = panel.getEditPanes();
for (int j = 0; j < editPanes.length; j++) {
if (editPanes[j].getBuffer() == buffer) {
LogPump.textArea.append("Comming close buffer \n");
jEdit.closeBuffer(panel, buffer);
LogPump.textArea.append("Buffer closed for 1 time \n");
break;
}
}
}
2. than use Buffer newBuffer = jEdit.newFile(view) to get a untitled buffer,
3. than use Buffer temp = jEdit.getBuffer(path) to get every file's buffer I need
4. than use String test = temp.getText(0, temp.getLength()) to get the file content
5. than use newBuffer.insert(0, test) to insert the file content to the untitled buffer
But in the 4th step, I found that I can not get the Text because the Buffer temp is not load, so my question is how can I load a buffer for disk mannually, I've tried the buffer.load() method, but it doesn't work, how can I do ?
more sophisticated 'select between quotes'
Submitted by
silverquick on
Saturday, 29 April, 2006 - 05:17
I was playing around with Lee Turner's script (which appears to have started here: http://community.jedit.org/?q=node/view/1128), and because I work with PHP I wanted one to recognise both single and double quotes, and there's also the problem with his that if the caret is between quotations, the space between them gets selected. The latter's not that big of a problem, but trying to allow for both types of quotes is tough.
I thought I had it with this: basically track all openings and closings of quotes in the buffer prior to the caret (in PHP a ' inside "..." doesn't count and vice-versa), and if a quote is open at the caret, search after the caret to find its mate, and select between them. But then if a comment contains apostrophes or irregular double-quotes, this won't work! I could get very complicated and detect comments, but this is language-specific and what I've been thinking from the start is that it would be nice to abstract the searching from the quote syntax.
So my real question is: is there a way for a macro to interact with jEdit's syntax highlighter? It's a waste for my macro to do the work of finding quoted sections when jEdit has obviously already done the work. I'm envisioning methods get the token type of the text under the caret, get the boundaries of a given token section, etc. I've tried looking through the API docs, but (1) I'm don't really understand how the highlighting engine works, and (2) it all feels a little over my head. I am pretty green with Java.
Thanks for reading!
Toolbar Icons
Submitted by
DMA on
Sunday, 30 April, 2006 - 04:22
Is there any way to change the toolbar icons? Are there alternate icons sets?
I was looking at the "Icons and Images" - are the icons there toobar icons?
An Office / Silk icon mix (jedit_windowsofficesilkmix_icons.jar v1.0 by various)
Submitted by
Denyer on
Sunday, 30 April, 2006 - 16:20
For anyone who'd prefer jEdit to look and feel more like a regular Windows application. To use, simply copy the .jar file into your $JAVA_HOME/jre/lib/ext directory and restart jEdit. Some icons from Silk by Mark James. Built for jEdit 4.3pre3 but I think should be fine with earlier versions, and seems okay with later pre-release versions as well.
a good news for game player
Submitted by
nicoleveve on
Monday, 1 May, 2006 - 00:05
hi ,you are the games players ,right? If you are i think you want to focus on this essay . If you want to play the game well ,you must have good arms ,right ? so if you want to buy the gold ,one way you can buy the gold .And i think the place can supply good service also they deliver the gold fast .So if i need gold i always buy it from them .many players says : the website is [url=http://www.moggm.com] you can go into have a try!!!!!!
network games:WOW ,EUWOW,MapleStory, Ragnarok Online, ROSE online , SilkRoad , RS2 , FFXI , EQ2 ,Guild Wars , Eve online , Matrix and so on or Power Leveling.
you also can contact them via:
AIM:gilssales
ICQ:108239029
Yahoo: sellgilstoyou
Msn:gils_sales@hotmail.com
http://www.moggm.com
a good website which can help you
Submitted by
nicoleveve on
Monday, 1 May, 2006 - 00:06
hi ,you are the games players ,right? If you are i think you want to focus on this essay . If you want to play the game well ,you must have good arms ,right ? so if you want to buy the gold ,one way you can buy the gold .And i think the place can supply good service also they deliver the gold fast .So if i need gold i always buy it from them .many players says : the website is [url=http://www.moggm.com] you can go into have a try!!!!!!
network games:WOW ,EUWOW,MapleStory, Ragnarok Online, ROSE online , SilkRoad , RS2 , FFXI , EQ2 ,Guild Wars , Eve online , Matrix and so on or Power Leveling.
you also can contact them via:
AIM:gilssales
ICQ:108239029
Yahoo: sellgilstoyou
Msn:gils_sales@hotmail.com
http://www.moggm.com
nu-B : please advise
Submitted by
ekips on
Monday, 1 May, 2006 - 22:22
Hello,
I am a complete newbie to developing GUIs, and using Swing in general. I am trying to embed a simple text editor into my current project that would allow for basic syntax highlighting and line numbering.
I am wondering if there is anyway to embed jedit with a small subset of its existing features, or if someone might be able to point me in the right direction... I think I may need to look into *EditorKits from swing, but I am still getting my bearings with this project...
any help would be greatly appreciated. thank you!
--fjs--
________________________
francisco j. sanchez
CSS Plugin Help
Submitted by
gkterry on
Tuesday, 2 May, 2006 - 12:03
I am having some difficulty getting the CSS Editor Plugin to work. I am using the latest development version of jEdit on Win XP with Java 1.5 U6. When I attempt to add an element in the CSS editor, everything appears to work as expected (including the preview) until I click the Add button. Then nothing happens. This occurs whether I am creating a new element or attempting to modify a previously created element after parsing.
I have totally wiped out the user settings and the jEdit program several times. Once I installed the program with just the CSS Editor plugin with the same result. I've noticed that this doesn't work on 2 different computers.
Am I missing something? Thanks for the help!
DotComplete cannot parse Java 5.0 source
Submitted by
TTAnimal on
Tuesday, 2 May, 2006 - 12:19
Title says it all really. I get no DotComplete popups when editing code with @nnotations, or generics.
Will this be fixed????
Bug in JARClassLoader when loading directories as Resources
Submitted by
ssaBrec on
Wednesday, 3 May, 2006 - 18:46
Trying to retrieve a directory using:
URL url = class.getResource("org/foo/bar/definitions");
JarURLConnection connection = url.openConnection();
causes an IOException thrown by PluginResURLConnection.connect()
Perhaps the openConnection call shouldn't try to get getResourceAsStream ? Just let the caller validate the Connection's contents. Basically, right now, it seems that retrieving a directory and then iterating through its entries is impossible?
SWI Prolog
Submitted by
vale on
Saturday, 6 May, 2006 - 02:11
Hello,
I am new to JEdit and I was wondering if someone already have thought about integrating SWI prolog into JEdit or can help me with my starting problems:
First I edited modes/catalogs so the syntax highlightning works automatically with the file endings of my project, adjusted the prolog.xml for my needs and filled with additional keywords of swi-prolog. this worked quite well.
Then I tried the simple task to integrate the swi-shell into jedit by using the console plugin. So I started "swipl" in the System-console, which also starts the swi-prompt, but right after I get thrown out again with "ERROR: Stream user_input:8: Syntax error: Unexpected end of file". I guess there is a simple solution to this lying behind some adjustments of the console-plugin...
Further, I want to use the ErrorList-plugin to attach to swi (is this possible/usefull/hard, can it show the line of the error in the buffer) and make shortcuts to common prolog commands like "consult" aso.
Thanks for any help.
vale
Plugin to work with uneditable and editable regions in the code
Submitted by
canelita on
Sunday, 7 May, 2006 - 21:14
Do we have a plugin that allows me to have uneditable and editable regions in the code?
I need to lock some region in the code, so users cannot touch some code I have already generated.
Cheers
uneditable and editable regions in the code
Submitted by
canelita on
Monday, 8 May, 2006 - 12:48
I am not an expert with Jedit, so I dont know how basic this question is.
Do we have a plugin/feature that allows me to have uneditable and editable regions in the code?
I need to lock some region in the code, so users cannot touch some code I have already generated.
LilyTool in jEdit - unable to run lilypond
Submitted by
zrlaszlo on
Tuesday, 9 May, 2006 - 15:46
Hi.
I have just tried out jEdit with the LilyTool plugin. It is working very well.
However, my problem is that when I try to run lilypond from inside jEdit, I get the following error:
java.lang.NoSuchMethodError: console.Console.setShell(Ljava/lang/String;)V
at lilytool.LilyToolPlugin.runCommand(LilyToolPlugin.java:409)
at lilytool.LilyToolPlugin.runCommandOnBuffer(LilyToolPlugin.java:438)
at lilytool.LilyToolPlugin.runCommandOnBuffer(LilyToolPlugin.java:430)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at bsh.Reflect.invokeOnMethod(Reflect.java:149)
at bsh.Reflect.invokeStaticMethod(Reflect.java:100)
at bsh.Name.invokeMethod(Name.java:872)
at bsh.BSHMethodInvocation.eval(BSHMethodInvocation.java:72)
at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:102)
at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:47)
at bsh.BSHAssignment.eval(BSHAssignment.java:77)
at bsh.BSHBlock.evalBlock(BSHBlock.java:130)
at bsh.BSHBlock.eval(BSHBlock.java:80)
at bsh.BSHBlock.eval(BSHBlock.java:46)
at bsh.BSHIfStatement.eval(BSHIfStatement.java:48)
at bsh.BSHBlock.evalBlock(BSHBlock.java:130)
at bsh.BSHBlock.eval(BSHBlock.java:80)
at bsh.BSHBlock.eval(BSHBlock.java:46)
at bsh.BSHIfStatement.eval(BSHIfStatement.java:48)
at bsh.BSHBlock.evalBlock(BSHBlock.java:130)
at bsh.BSHBlock.eval(BSHBlock.java:80)
at bsh.BshMethod.invokeImpl(BshMethod.java:349)
at bsh.BshMethod.invoke(BshMethod.java:246)
at bsh.BshMethod.invoke(BshMethod.java:171)
at org.gjt.sp.jedit.BeanShell.runCachedBlock(BeanShell.java:523)
at org.gjt.sp.jedit.BeanShellAction.invoke(BeanShellAction.java:76)
at org.gjt.sp.jedit.gui.InputHandler.invokeAction(InputHandler.java:229)
at org.gjt.sp.jedit.jEdit$3.invokeAction(jEdit.java:2910)
at org.gjt.sp.jedit.EditAction$Wrapper.actionPerformed(EditAction.java:216)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
I am quite new to jEdit, so I could not figure out, what is wrong. Besides, I apologize for writing - there might have been someone else asking this question. I did a few searches but unfortunately I do not have the time crawl through the entire forum.
Thank you a lot for your help.
Jedit showing . characters
In JEdit,
The editor is showing a "." instead of EOL character and a ":" whenever the word wrapping happens. Although sometimes desirable i want to TURN THIS feature off. Is there anyway i can do this?
I tried playing with the global options, buffer options and the forums but cudnt find something though.
Thanks,
Kannan
kannan.ekanath@gmail.com
Problem configuring jEdit
Submitted by
ionial on
Thursday, 11 May, 2006 - 00:17
Hi!
I've installed jEdit with few plugins and trying to use JExplorer.
I've ProjectViewer working OK , created new project with bunch of java files.
Then I wanted to see its model in JExplorer - but I have a feeling that it just doesn't parse the
files (the icon never changes).
What should I do to get JExplorer working?
Sincerely, Nick