Fw: Issue with Open office

2013-09-16 Thread Vikas Singh
Dear Team,
I have been working on Open Office for last 2 months.

The below list contains some of the problems which I have been facing 
continuously. Some other issues which I haven’t mentioned here are very minor 
but still effects the entire work.



We hope that we will get positive response.





  SL. No ISSUES 
  1 Iferror with Vlookup doesn't work 
  2 Find & Replace doesn't work for selected area, it replaces for all 
sheet 
  3 Can not select blanks in Filter 
  4 Can not apply standard filter at two places  
  5 Linking of files don't work properly 
  6 Shortcut for Format paste 
  7 Graphs are not advanced 
  8 Vlookup doesn't work properly from one file to another 
  9 For using formulas you have to click on the function key, can't use it 
with keyboard  
  10 If condition don't work 
  11 Any two formula don't work together , e.g below 

 Index+Match 

 Vlookup+Choose 

 Vlookup+Max 
  12 Ctrl+D doesn't work 
  13 Pivot cant be in classical format 
  14 Don't fix the array by itself 
  15 Paste special & delete command is very time consuming 
  16 Shortcut keys for Home options 


Warm Regards,
Vikas Singh
-
Safexpress Private Limited
Road No. 4 | N.H. 8 | Mahipalpur Extn. | New Delhi – 37
M: +91.9313456553 |Ph: +91.11.2678.3281..90- I Ext: 403 I Fax: 
+91.11.2678.1481-82

Email: vikas.si...@safexpress.com | www.safexpress.com


This e-mail is confidential. It may also be legally privileged. If you are not 
the addressee you may not copy, forward, disclose or use any part of it. If you 
have received this message in error, please delete it and all copies from your 
system and notify the sender immediately by return e-mail. Internet 
communications cannot be guaranteed to be timely, secure, error or virus-free. 
The sender does not accept liability for any errors or omissions.


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Wiki editing plug-in?

2013-09-16 Thread Fernando Cassia
If you ever tried editing complex tables like this
http://en.wikipedia.org/wiki/Comparison_of_tablet_computers
on a wiki using wiki syntax you will soon see that it's a hair-pulling
exercise.

Even with the wikipedia's new Ajax "online" wysiwyg editor, table editing
is stil not even there.

So, is there a plugin allowing to use AOO to edit wiki articles (including
tables), and pushing changes back on-line effortlessly?

If not, there's an idea: there should be.

FC

-- 
During times of Universal Deceit, telling the truth becomes a revolutionary
act
Durante épocas de Engaño Universal, decir la verdad se convierte en un Acto
Revolucionario
- George Orwell


Re: Issue with Open office

2013-09-16 Thread Martin Groenescheij
Could you inform us what OS and version you have installed AOO on and which 
version of AOO you have installed.
Further it is better if you send a separate email for each question together 
with examples.
Please describe exactly what you are doing when an error occurred and include 
the error message.
This way you can expect better response.


On 16/09/2013, at 11:06 AM, "Vikas Singh"  wrote:

> Dear Team,
> I have been working on Open Office for last 2 months.
>  
> The below list contains some of the problems which I have been facing 
> continuously. Some other issues which I haven’t mentioned here are very minor 
> but still effects the entire work.
>  
> We hope that we will get positive response.
>  
>  
> SL. NoISSUES
> 1 Iferror with Vlookup doesn't work
> 2 Find & Replace doesn't work for selected area, it replaces for all sheet
> 3 Can not select blanks in Filter
> 4 Can not apply standard filter at two places
> 5 Linking of files don't work properly
> 6 Shortcut for Format paste
> 7 Graphs are not advanced
> 8 Vlookup doesn't work properly from one file to another
> 9 For using formulas you have to click on the function key, can't use it 
> with keyboard
> 10If condition don't work
> 11Any two formula don't work together , e.g below
> 
> Index+Match
> 
> Vlookup+Choose
> 
> Vlookup+Max
> 12Ctrl+D doesn't work
> 13Pivot cant be in classical format
> 14Don't fix the array by itself
> 15Paste special & delete command is very time consuming
> 16Shortcut keys for Home options
>  
> Warm Regards,
> Vikas Singh
> -
> Safexpress Private Limited
> Road No. 4 | N.H. 8 | Mahipalpur Extn. | New Delhi – 37
> M: +91.9313456553 |Ph: +91.11.2678.3281..90- I Ext: 403 I Fax: 
> +91.11.2678.1481-82
> 
> Email: vikas.si...@safexpress.com | www.safexpress.com
> 
> 
> This e-mail is confidential. It may also be legally privileged. If you are 
> not the addressee you may not copy, forward, disclose or use any part of it. 
> If you have received this message in error, please delete it and all copies 
> from your system and notify the sender immediately by return e-mail. Internet 
> communications cannot be guaranteed to be timely, secure, error or 
> virus-free. The sender does not accept liability for any errors or omissions.
> 
> 
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org


Novel writing need to Link/update various documents

2013-09-16 Thread Chris Harris
Hi there.

Tried sending a blank email, but do not think it has worked as I never received 
a reply. So I am trying the direct approach.

I am trying to write a novel using openoffice, 4.0.0, on a Windows7 x64 laptop, 
saving each chapter as a discrete file.

I would like to be able to have an updatable chapter summary at the top of the 
chapters. I have an individual file with this data, which I would like to be 
able to update from the chapter summary. ie if I have a briliant idea, I can 
add it to that chapters summary, which in turn will update the summary file, 
this amended summary then needs to update all the chapter heading summaries.

Next I have a file with character notes/bio's. Again I need to be able to amend 
this whilst writing. ie, I am writing something about a character, and want to 
save a particular word or character detail, so click on characters name which 
then opens up the character file and I can update the file. 

I suspect that I need to use the hyperlink function in some way, maybe you can 
give me some advice as to the best way to do this?

I could of course use an index card system, but that would inhibit the flow, as 
it were, especially as copy and paste would be so much more efficient.

I have given each chapter a title and number, but in going over what I have 
already written, I am thinking I want to change chapter1 to chapter 5 and move 
chapter 4 to chapter1...or at least move things around. Any ideas as to how 
this could be best done. I am thinking I should simply have used the chapter 
title as the file name, deciding on the actual chapter order/number when 
satisfied with the whole book. 

Has anyone got any experience of using openoffice for novel writing?

Appreciate any help you can give me.

Thanks C Harris.