Re: non-techie's comment/question

[Martin Groenescheij]

On 25/02/18 10:34 AM, John Hart wrote:

On 2/24/2018 3:32 PM, Keith N. McKenna wrote:

OpenOffice has always worked the way the Martin described. What you are
seeing with the open dialog is how your operating system works.
OpenOffice does not have control over that.

1. What does 'default path' mean in the statement:
   "OpenOffice doesn't changes the default path"?


The default path is set by your Operating System, which is basically the 
last directory you used to save or open a document.

Blame Bill Gates.


2. Does OO or the OS control the 'default path'?


NO!


3. OO could save files anywhere a person wanted, regardless
   of the OS, without changing the 'default path'.
   I have written many programs that do, and assure you it's trivial.


If you have written many programs that do what you want, you should know 
that you overruled the default of the Operating system.



4. A feature to allow writing a file to an external drive without
   changing the 'default path' would be easy to implement.
   It's what the original poster requested info on, and the reply
   'It works how it works get over it', isn't a good answer.


You're correct the original poster want  something different as it works 
at the moment.
So his question should go into the bug/rfe database, but he asked the 
question on a user mailing list
and users can't change the program so expect answers like "It works how 
it works" because user aren't daydreamers

they tell you how to deal with issues.


5. Rationalizing shortcomings by pretending people who expect
   more are incompetent, isn't good 'customer service'.


Again, you are right this isn't good 'customer service', because in the 
first place you're not a customer but a user
secondly we aren't a customer service department, we are just users like 
you.




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

Re: Open Office Calc Infinite Anchors Issue

[Martin Groenescheij]

On 24/02/18 8:51 PM, Vidu Sebastian wrote:
Hey everyone. I have an XLS file and when i modify it with Open Office 
Calc and save it i can see a lot of blank anchors covering my 
spreadsheet. I attached to this mail the before and after file .



The problem is you don't have a XLS file but rather an XLSX file.
Just save the XSLX file as XLS (Excel 97 - 2003) and your problem is gone.


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

Re: non-techie's comment/question

[John Hart]

On 2/24/2018 3:32 PM, Keith N. McKenna wrote:

OpenOffice has always worked the way the Martin described. What you are
seeing with the open dialog is how your operating system works.
OpenOffice does not have control over that.

1. What does 'default path' mean in the statement:
   "OpenOffice doesn't changes the default path"?
2. Does OO or the OS control the 'default path'?
3. OO could save files anywhere a person wanted, regardless
   of the OS, without changing the 'default path'.
   I have written many programs that do, and assure you it's trivial.
4. A feature to allow writing a file to an external drive without
   changing the 'default path' would be easy to implement.
   It's what the original poster requested info on, and the reply
   'It works how it works get over it', isn't a good answer.
5. Rationalizing shortcomings by pretending people who expect
   more are incompetent, isn't good 'customer service'.

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

Re: non-techie's comment/question

[Keith N. McKenna]

On 2/24/2018 4:34 PM, John Hart wrote:
> On 2/24/2018 3:38 AM, Martin Groenescheij wrote:
>>> I'm using v3.3, and after saving it changed the path, which was
>>> annoying, and explains the need for the method Mkaye asked about,
>>> which wouldn't change the default path.
>>
>> Sorry, but OpenOffice doesn't changes the default path. 
> Are you saying v4.x works different than 3.x when using 'save as' to
> write files to external media,
> and that the next time one saves or opens a file, it points at the
> working directory, not external
> media.  If so, how does one change where the working directory is?
>> It saves only the 10 most recently used documents.
> Recently used documents in 3.3, include pointers to where they reside.
> Open and save uses the path to the
> last directory a file was opened in or saved to. After writing a file to
> external media using 3.3,
> all subsequent opens or saves, use that location, and the link to the
> working directory
> needs to be re-established. Does 4.x work differently? If so, please
> explain. I'm still using 3.3 on my
> old computer, haven't switched to the new one with 4.x yet.
> 
>> this means if you open a file from the recently used menu and you do a
>> save as in another
> directory it has now both files in the recently used menu.
> 
> That's true, the path is included in recently used, but the question is:
> does 'save as' change the path open uses, and if so is there a way
>  to write files to external media without doing so?
> 
> jrh
> 
OpenOffice has always worked the way the Martin described. What you are
seeing with the open dialog is how your operating system works.
OpenOffice does not have control over that.

Regards
Keith




signature.asc
Description: OpenPGP digital signature

Re: non-techie's comment/question

[John Hart]

On 2/24/2018 3:38 AM, Martin Groenescheij wrote:
I'm using v3.3, and after saving it changed the path, which was 
annoying, and explains the need for the method Mkaye asked about, 
which wouldn't change the default path.


Sorry, but OpenOffice doesn't changes the default path. 
Are you saying v4.x works different than 3.x when using 'save as' to 
write files to external media,
and that the next time one saves or opens a file, it points at the 
working directory, not external

media.  If so, how does one change where the working directory is?

It saves only the 10 most recently used documents.
Recently used documents in 3.3, include pointers to where they reside. 
Open and save uses the path to the
last directory a file was opened in or saved to. After writing a file to 
external media using 3.3,
all subsequent opens or saves, use that location, and the link to the 
working directory
needs to be re-established. Does 4.x work differently? If so, please 
explain. I'm still using 3.3 on my

old computer, haven't switched to the new one with 4.x yet.

this means if you open a file from the recently used menu and you do a 
save as in another

directory it has now both files in the recently used menu.

That's true, the path is included in recently used, but the question is:
does 'save as' change the path open uses, and if so is there a way
 to write files to external media without doing so?

jrh

Re: Open Office Calc Infinite Anchors Issue

[Vidu Sebastian]

Hey i tryed the hide options also but it doesnt help. I cant select my text 
from the cells. Please help me .
 

On Saturday, February 24, 2018, 6:43:09 PM GMT+2, Vidu Sebastian 
 wrote:  
 
 Those Custom Shapes are exactly the cells with the text that is in them. If i 
delete them it will delete the whole data ... I will try the other workaround 
also

On Sat, 2/24/18, Brian Barker  wrote:

 Subject: Re: Open Office Calc Infinite Anchors Issue
 To: users@openoffice.apache.org
 Cc: "Vidu Sebastian" 
 Date: Saturday, February 24, 2018, 5:46 PM
 
 At 09:51 24/02/2018 +, Vidu
 Sebastian wrote:
 >I have an XLS file and
 when i modify it with Open Office Calc and 
 >save it i can see a lot of blank anchors
 covering my spreadsheet. I 
 >attached to
 this mail the before and after file.
 
 Open your .xls file in OpenOffice. Go to View |
 Navigator (or press 
 F5) to open the
 Navigator. Click the plus sign against "Drawing 
 objects" to open the list. You will see
 that you have 103 objects 
 called
 "CustomShape 1". I don't know what these do
 for you. Do you? 
 Do you need them? If not,
 go to each sheet in turn, move to the top, 
 and repeatedly click to select the object and
 press Delete to delete 
 it. I don't see
 any way to delete them en masse.
 
 But there may be an easy workaround. Go to
 Tools | Options... | 
 OpenOffice Calc | View
 | Objects, and toggle "Drawing objects" from 
 Show to Hide. This won't remove them, of
 course, but may be enough 
 for your
 needs.
 
 The web site
 zamzar.com converts documents between formats free of 
 charge. It will convert .xlsx files to .xls and
 also to .ods. 
 Interestingly, converting
 your .xlsx file into each format and 
 opening the result in OpenOffice creates
 exactly the same effect as 
 opening the
 .xlsx file directly, so the problem may not be simply a 
 problem with OpenOffice's conversion of the
 original .xlsx file.
 
 I
 trust this helps.
 
 Brian
 Barker
 
 
 -
 To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
 For additional commands, e-mail: users-h...@openoffice.apache.org
 
 
  

Re: Open Office Calc Infinite Anchors Issue

[Brian Barker]

At 16:43 24/02/2018 +, Vidu Sebastian wrote:

Those Custom Shapes are exactly the cells with the text that is in them.


What is your evidence for this, please? There is certainly no text 
displayed in the drawing objects as displayed when the problem 
appears, though you can enter text into them. Why do you think there 
is text in them?



If i delete them it will delete the whole data ...


Certainly not "the whole data": you can see this easily by trying it 
out. Do you think that it would delete some data?


If you believe this, please identify for list readers just one single 
cell which shows text in the original .xlsx file but fails to show it 
(or all of it) when the drawing objects have been deleted. Then 
people will be able to investigate the problem further for you.



I will try the other workaround also


If you mean hiding the drawing objects, that surely will be no better 
- if what you say above is true. If relevant text would be deleted by 
deleting the drawing objects, hiding them (and that text) would 
surely be just (almost?) as unhelpful?


Brian Barker  



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

Re: Open Office Calc Infinite Anchors Issue

[Vidu Sebastian]

Those Custom Shapes are exactly the cells with the text that is in them. If i 
delete them it will delete the whole data ... I will try the other workaround 
also

On Sat, 2/24/18, Brian Barker  wrote:

 Subject: Re: Open Office Calc Infinite Anchors Issue
 To: users@openoffice.apache.org
 Cc: "Vidu Sebastian" 
 Date: Saturday, February 24, 2018, 5:46 PM
 
 At 09:51 24/02/2018 +, Vidu
 Sebastian wrote:
 >I have an XLS file and
 when i modify it with Open Office Calc and 
 >save it i can see a lot of blank anchors
 covering my spreadsheet. I 
 >attached to
 this mail the before and after file.
 
 Open your .xls file in OpenOffice. Go to View |
 Navigator (or press 
 F5) to open the
 Navigator. Click the plus sign against "Drawing 
 objects" to open the list. You will see
 that you have 103 objects 
 called
 "CustomShape 1". I don't know what these do
 for you. Do you? 
 Do you need them? If not,
 go to each sheet in turn, move to the top, 
 and repeatedly click to select the object and
 press Delete to delete 
 it. I don't see
 any way to delete them en masse.
 
 But there may be an easy workaround. Go to
 Tools | Options... | 
 OpenOffice Calc | View
 | Objects, and toggle "Drawing objects" from 
 Show to Hide. This won't remove them, of
 course, but may be enough 
 for your
 needs.
 
 The web site
 zamzar.com converts documents between formats free of 
 charge. It will convert .xlsx files to .xls and
 also to .ods. 
 Interestingly, converting
 your .xlsx file into each format and 
 opening the result in OpenOffice creates
 exactly the same effect as 
 opening the
 .xlsx file directly, so the problem may not be simply a 
 problem with OpenOffice's conversion of the
 original .xlsx file.
 
 I
 trust this helps.
 
 Brian
 Barker
 
 
 -
 To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
 For additional commands, e-mail: users-h...@openoffice.apache.org
 
 

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

Re: Open Office Calc Infinite Anchors Issue

[Brian Barker]

At 09:51 24/02/2018 +, Vidu Sebastian wrote:
I have an XLS file and when i modify it with Open Office Calc and 
save it i can see a lot of blank anchors covering my spreadsheet. I 
attached to this mail the before and after file.


Open your .xls file in OpenOffice. Go to View | Navigator (or press 
F5) to open the Navigator. Click the plus sign against "Drawing 
objects" to open the list. You will see that you have 103 objects 
called "CustomShape 1". I don't know what these do for you. Do you? 
Do you need them? If not, go to each sheet in turn, move to the top, 
and repeatedly click to select the object and press Delete to delete 
it. I don't see any way to delete them en masse.


But there may be an easy workaround. Go to Tools | Options... | 
OpenOffice Calc | View | Objects, and toggle "Drawing objects" from 
Show to Hide. This won't remove them, of course, but may be enough 
for your needs.


The web site zamzar.com converts documents between formats free of 
charge. It will convert .xlsx files to .xls and also to .ods. 
Interestingly, converting your .xlsx file into each format and 
opening the result in OpenOffice creates exactly the same effect as 
opening the .xlsx file directly, so the problem may not be simply a 
problem with OpenOffice's conversion of the original .xlsx file.


I trust this helps.

Brian Barker


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

Re: Open Office Calc Infinite Anchors Issue

[Vidu Sebastian]

Thats exactly what  i did.. Amd when you open it agsin in ods format the issue 
appear. Even the file you atrached is with empty anchors in  it when i open it

On Sat, 2/24/18, DaveB  wrote:

 Subject: Re: Open Office Calc Infinite Anchors Issue
 To: "Apache OpenOffice Users" 
 Cc: "Vidu Sebastian" 
 Date: Saturday, February 24, 2018, 3:17 PM
 
 
 On 24.02.2018 09:51,
 Vidu Sebastian
   wrote:
 
 
 
   
 Hey everyone. I have an XLS file and when i
 modify it with
   Open Office Calc and save it i can see a lot of
 blank anchors
   covering my spreadsheet. I attached to this mail
 the before
   and after file .
   
 
 
 
 Hi Vidu,
 
 
 
 You attached 2 files Before.xlsx and After.ods but you
 have not said
 how you converted Before.xlsx to After.ods I suspect
 that you or
 someone else has used MS Excel to open Before.xlsx and
 then saved
 the opened file as After.ods If this is the case, the
 process is
 doomed to failure, because MS Office does not always
 correctly
 format ODF files. Using this method I can perfectly and
 repeatedly
 replicate your issue of badly anchored empty comment
 boxes when
 saved by MS Excel in ods format.
 
 
 
 Why not simply open Before.xlsx in Calc, then use
 Calc's "File ->
 Save As.." option to save the file in ods format by
 selecting the
 ods "File type" in the "Save As"
 dialog? 
 
 Attached is my conversion using this method.
 
 
 
 Regards
 
 Dave
 
 
 
 
 
   

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

Re: Open Office Calc Infinite Anchors Issue

[DaveB]

OK before everyone starts jumping up and down, the ods file attached to
my previous post shows the same error Vidu is reporting. Strange thing
is that after saving there is no sign of the bad anchors, they only
appear when the file is reopened in AOO Calc. Also puzzling is that the
ods file saved from AOO Calc opens and displays correctly in LO Calc.

Looks like it is a bug in AOO Calc. Apologies for creating useless list
noise.

Dave

 Original Message 
From: DaveB 
To: Apache OpenOffice Users 
Date: Sat, 24 Feb 2018 13:17:23 +

> On 24.02.2018 09:51, Vidu Sebastian wrote:
>> Hey everyone. I have an XLS file and when i modify it with Open
>> Office Calc and save it i can see a lot of blank anchors covering my
>> spreadsheet. I attached to this mail the before and after file .
>
> Hi Vidu,
>
> You attached 2 files Before.xlsx and After.ods but you have not said
> how you converted Before.xlsx to After.ods I suspect that you or
> someone else has used MS Excel to open Before.xlsx and then saved the
> opened file as After.ods If this is the case, the process is doomed to
> failure, because MS Office does not always correctly format ODF files.
> Using this method I can perfectly and repeatedly replicate your issue
> of badly anchored empty comment boxes when saved by MS Excel in ods
> format.
>
> Why not simply open Before.xlsx in Calc, then use Calc's "File -> Save
> As.." option to save the file in ods format by selecting the ods "File
> type" in the "Save As" dialog?
> Attached is my conversion using this method.
>
> Regards
> Dave
>
>
>
>
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Open Office Calc Infinite Anchors Issue

[DaveB]

On 24.02.2018 09:51, Vidu Sebastian wrote:
> Hey everyone. I have an XLS file and when i modify it with Open Office
> Calc and save it i can see a lot of blank anchors covering my
> spreadsheet. I attached to this mail the before and after file .

Hi Vidu,

You attached 2 files Before.xlsx and After.ods but you have not said how
you converted Before.xlsx to After.ods I suspect that you or someone
else has used MS Excel to open Before.xlsx and then saved the opened
file as After.ods If this is the case, the process is doomed to failure,
because MS Office does not always correctly format ODF files. Using this
method I can perfectly and repeatedly replicate your issue of badly
anchored empty comment boxes when saved by MS Excel in ods format.

Why not simply open Before.xlsx in Calc, then use Calc's "File -> Save
As.." option to save the file in ods format by selecting the ods "File
type" in the "Save As" dialog?
Attached is my conversion using this method.

Regards
Dave




After_Calc_Save.ods
Description: application/vnd.oasis.opendocument.spreadsheet

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

Re: non-techie's comment/question

[Martin Groenescheij]

On 24/02/18 1:13 PM, John Hart wrote:

On 2/23/2018 6:16 PM, John Hart wrote:
Save as, allows one the save to another location, as well as change 
the name.
I've never tried it, just did and it works for me. 
I'm using v3.3, and after saving it changed the path, which was 
annoying, and explains the need for the method Mkaye asked about,

which wouldn't change the default path.


Sorry, but OpenOffice doesn't changes the default path. It saves only 
the 10 most recently used documents this means
if you open a file from the recently used menu and you do a save as in 
an other directory it has now both files in the

recently used menu, that's how it is designed.


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