Re: MWiki home page cleanup

[Andrea Pescetti]

Marcus wrote:

it seems my user account "mla" has no longer the permissions to edit
pages. Can some admin check this please?


Did you try with an ordinary page or with the home page? The home page 
seems to be special.


For example, you should be able to open 
https://wiki.openoffice.org/w/index.php?title=Documentation/Building_Guide_AOO=edit 
to edit a normal page (the Building Guide). Let me know if that does not 
work.


For the home page I would need to find a way to give you proper 
permissions (which I can surely do, but I'd like that you make the check 
above, since all users should be able to edit "ordinary" pages).


Regards,
  Andrea.

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

Re: broken file in the cab?

[Marcus]

Am 12/13/2015 03:26 AM, schrieb plirofor...@yahoo.gr:

Please inform me to who can i send report for this problem.


you can tell us your problem here.

Thanks

Marcus


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

Σχετ: Re: broken file in the cab?

[Yahoo]

Hi Msrcus,As you can see in the attached jpg the installation stop extracting 
at this archive, then continue and give me a message that could be found the 
openoffice cab. The archive exist but it can't continue the installation.
Thanks
Michalis

Στάλθηκε από το Ταχυδρομείο Yahoo σε Android 
 
  Στις Κυρ, 13 Δεκ, 2015 στις 11:20, ο χρήστης Marcus 
έγραψε:   Am 12/13/2015 03:26 AM, schrieb plirofor...@yahoo.gr:
> Please inform me to who can i send report for this problem.

you can tell us your problem here.

Thanks

Marcus

  

Re: MWiki home page cleanup

[Marcus]

Am 12/13/2015 01:19 AM, schrieb Keith N. McKenna:

Andrea Pescetti wrote:

I've made a quick cleanup of the home page of our wiki (MWiki), to
remove the clearly obsolete content.

At
https://wiki.openoffice.org/w/index.php?title=Main_Page=237003=232961
you can see the combined diff showing all four steps of the cleanup, or
you can check individual diffs.

The current version https://wiki.openoffice.org/wiki/Main_Page is not
perfect but at least it's clearer.

Apparently not all users can update the home page, so if there is need
for further changes/updates (or if any of my changes needs to be undone)
just write here and I'll act accordingly.

Regards,
   Andrea.

Andrea;

Checked the combined diff and it looks good. I will try to keep an eye
on the front page and will check if my permissions allow me to edit it
so we can try to keep it clean.


it seems my user account "mla" has no longer the permissions to edit 
pages. Can some admin check this please?


Thanks

Marcus


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

Re: Σχετ: Re: broken file in the cab?

[Marcus]

Am 12/13/2015 10:31 AM, schrieb Yahoo:

Hi Msrcus,As you can see in the attached jpg the installation stop extracting 
at this archive, then continue and give me a message that could be found the 
openoffice cab. The archive exist but it can't continue the installation.


attachments get stripped for this mailing list. So, please can you copy 
& paste the error message? Also some more information would be helpful:


- Make sure that the downloaded file is not corrupted?
  (you can do this with the instructions from here
  "http://www.openoffice.org/download/checksums.html;, the chechsums
  are downloadable here "http://www.openoffice.org/download/;)

- From were have you downloaded the OpenOffice software?

- Which version is it?

- Which Windows version are you using?

Thanks

Marcus




   Στις Κυρ, 13 Δεκ, 2015 στις 11:20, ο χρήστης Marcus  
έγραψε:   Am 12/13/2015 03:26 AM, schrieb plirofor...@yahoo.gr:

Please inform me to who can i send report for this problem.


you can tell us your problem here.

Thanks

Marcus


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

Re: Compiler Error

[Brett Grentell]

Thanks I'll give it a go


Sent from Samsung Mobile

 Original message From: Oliver Brinzing 
 Date:13/12/2015  6:44 PM  (GMT+10:00) 
To: dev@openoffice.apache.org Subject: Re: Compiler Error 

Hi Bret,

i was able to build aoo411 and 412 debug builds with the following 
configuration:

SourceMain=/cygdrive/c/build_tmp/aoo_src/main
cd $SourceMain
autoconf
./configure \
--with-build-version="$(date +"%Y-%m-%d %H:%M:%S %z (%a, %d %b %Y)")" \
--with-vendor="AOO Debug Build" \
--with-dmake-url="http://dmake.apache-extras.org.codespot.com/files/dmake-4.12.tar.bz2;
 \
--with-ant-home="/cygdrive/c/build/ant" \
--with-mozilla-build="/cygdrive/c/build/mozilla-build" \
--with-frame-home="/cygdrive/c/Program Files/Microsoft SDKs/Windows/v7.0" \
--with-psdk-home="/cygdrive/c/Program Files/Microsoft SDKs/Windows/v7.0" \
--with-midl-path="/cygdrive/c/Program Files/Microsoft SDKs/Windows/v7.0/bin" \
--with-cl-home="/cygdrive/c/Program Files (x86)/Microsoft Visual Studio 9.0/VC" 
 \
--with-mspdb-path="/cygdrive/c/Program Files (x86)/Microsoft Visual Studio 
9.0/Common7/IDE" \
--with-asm-home="/cygdrive/c/Program Files (x86)/Microsoft Visual Studio 
9.0/VC/bin" \
--with-csc-path="/cygdrive/c/Windows/Microsoft.NET/Framework/v3.5" \
--with-jdk-home="/cygdrive/c/Program Files (x86)/Java/jdk1.7.0"  \
--with-nsis-path="/cygdrive/c/Program Files (x86)/NSIS/Unicode" \
--with-directx-home="/cygdrive/c/Program Files (x86)/Microsoft DirectX SDK 
(June 2010)" \
--with-atl-include-dir="/cygdrive/c/WinDDK/7600.16385.1/inc/atl71" \
--with-atl-lib-dir="/cygdrive/c/WinDDK/7600.16385.1/lib/ATL/i386" \
--with-mfc-include-dir="/cygdrive/c/WinDDK/7600.16385.1/inc/mfc42" \
--with-mfc-lib-dir="/cygdrive/c/WinDDK/7600.16385.1/lib/Mfc/i386" \
--enable-pch \
--with-package-format="installed msi" \
--enable-win-x64-shellext \
--enable-category-b \
--enable-bundled-dictionaries \
--with-lang="de" \
--without-stlport \
--without-junit \
--enable-verbose \
--disable-odk \
--without-fonts

./bootstrap
source winenv.set.sh
cd instsetoo_native
build --all --html -P2 -- -P2

Regards
Oliver

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

Re: Calc Selections of Entire Rows and Columns

[#PATHANGI JANARDHANAN JATINSHRAVAN#]

Hi Dennis, 
 I have filed one here: 
https://bz.apache.org/ooo/show_bug.cgi?id=126734 with the patch available in 
that issue

Thanks
Jatin


From: Dennis E. Hamilton 
Sent: Monday, December 14, 2015 09:13 AM
To: dev@openoffice.apache.org
Cc: #PATHANGI JANARDHANAN JATINSHRAVAN#
Subject: RE: Calc Selections of Entire Rows and Columns

Is there a Bugzilla issue with Jatin's patch?

> -Original Message-
> From: Damjan Jovanovic [mailto:dam...@apache.org]
> Sent: Sunday, December 13, 2015 08:57
> To: Dennis Hamilton 
> Cc: Apache OO ; #PATHANGI JANARDHANAN
> JATINSHRAVAN# 
> Subject: Re: Calc Selections of Entire Rows and Columns
[ ... ]
> "=A" is also problematic if "A" is a named range.
>
> The patch Jatin sent me to review already allows entering A:A and 1:1,
> and
> writes A:A as [.A$1:.A$1048576], but re-reads it as A$1:A$1048576. It
> can
> read [.A:.A] but also converts it to A$1:A$1048576.
[ ... ]


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

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

Re: MWiki home page cleanup

[Andrea Pescetti]

Marcus wrote:

yes, I can edit all other pages. Didn't know that the first page wants
to be treated special. ;-)


You should now be able to edit it too. And if this worked for you then 
anyone else who wants to be able to edit the home page can simply ask 
here for full rights.



But I've just one thing: Please avoid to link to the "other.html"
webpage as it is no longer maintained - and also because it will be
deleted someday as the normal download webpage is its successor.


OK, removed.


My suggestion for the first 2 bullet points of "Get latest released
software" is to combine them:
- For the most current release and all language packs see the [Download
website]


Done, but still please check that you can edit the homepage now.

Regards,
  Andrea.

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

Re: MWiki home page cleanup

[Marcus]

Am 12/13/2015 12:17 PM, schrieb Andrea Pescetti:

Marcus wrote:

it seems my user account "mla" has no longer the permissions to edit
pages. Can some admin check this please?


Did you try with an ordinary page or with the home page? The home page
seems to be special.


yes, I can edit all other pages. Didn't know that the first page wants 
to be treated special. ;-)


But I've just one thing: Please avoid to link to the "other.html" 
webpage as it is no longer maintained - and also because it will be 
deleted someday as the normal download webpage is its successor.


My suggestion for the first 2 bullet points of "Get latest released 
software" is to combine them:


- For the most current release and all language packs see the [Download 
website]


Thanks

Marcus


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

Re: Introducing my self and my goals.

[Ηρακλής Μουτίδης]

Dear Damjan, Jatin and Wlada,

I am going to start working on the issues Wlada suggested and the missing
functions of Calc suggested by Damjan.
Thanks a lot for your time.

Jatin thank you for letting me know good luck on your project.

Best regards,
Iraklis

2015-12-13 2:15 GMT+02:00 Vladislav Stevanovic <
stevanovicvladis...@gmail.com>:

> Or this:
> https://forum.openoffice.org/en/forum/viewtopic.php?f=9=78684
>
> Regards,
> Wlada
>
> 2015-12-13 1:04 GMT+01:00 Vladislav Stevanovic <
> stevanovicvladis...@gmail.com>:
>
> > Hello Iraklis,
> >
> > If you're looking for something small, you could try to fix this (open
> > attached Calc file).
> >
> > Regards,
> > Wlada
> >
> > 2015-12-12 5:48 GMT+01:00 #PATHANGI JANARDHANAN JATINSHRAVAN# <
> > jatinshr...@e.ntu.edu.sg>:
> >
> >> Hi Iraklis,
> >> I have picked up the task to provide whole row/column references
> >> in Calc so if you don’t mind, could you please pick up an alternative
> task?
> >>
> >> Thanks
> >> Jatin
> >>
> >>
> >>
> >> On 12/11/15, 1:06 AM, "Damjan Jovanovic"  wrote:
> >>
> >> >Hi Iraklis
> >> >
> >> >If you're looking for something small, you could try implementing a few
> >> >missing Calc functions from
> >> >
> >>
> https://wiki.openoffice.org/wiki/Calc/ODFF_Implementation/Examine_functions
> >> >based on the guide at
> >> >
> >>
> https://wiki.openoffice.org/wiki/Calc/Implementation/Spreadsheet_Functions
> >> >and the ODF formula specification at
> >> >
> http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.htm
> >> .
> >> >The IFERROR and ISNA functions would be good to have.
> >> >
> >> >There is no shortage of big things either :-). Here's a few off the top
> >> of
> >> >my head:
> >> >* An OOXML export filter would be a big help to our users, but I think
> >> >that's probably too difficult - the specification a 6000 page document.
> >> It
> >> >might be possible to use the Apache POI project which already provides
> >> >OOXML reading and writing in Java.
> >> >* Calc doesn't provide whole row/column references like C:C or 5:5
> while
> >> >Excel does, which are helpful to use in implicit intersection, among
> >> others
> >> >(eg. in cell E34, you don't need to use D34 to refer to the cell just
> to
> >> >the left, you can just type D:D and it will automatically use the
> current
> >> >row).
> >> >* CSV file support in Base could be reimplemented to use the HSQLDB
> >> >database which already supports CSV, which would allow the full range
> of
> >> >SQL queries with joins, grouping, correlated subqueries, scalar
> >> operators,
> >> >and other advanced features that the current CSV file support doesn't
> >> >provide. This would also involve some work on HSQLDB to get CSV parsing
> >> >working exactly how it does now. Also spreadsheets are equally badly
> >> >supported as a data source in Base, and by extending HSQLDB a bit, the
> >> >spreadsheet support could be reimplemented using HSQLDB to provide the
> >> same
> >> >powerful query capabilities CSV would have.
> >> >
> >> >If you need other ideas, look through Bugzilla. Please let me know if
> you
> >> >decide.
> >> >
> >> >Regards
> >> >Damjan
> >> >
> >> >On Tue, Nov 24, 2015 at 11:49 PM, Ηρακλής Μουτίδης  >
> >> >wrote:
> >> >
> >> >> Hi Damjan,
> >> >>
> >> >> I will have a look to the wikis.
> >> >> I am also interested in your suggestions, so if you think that i can
> >> help
> >> >> in something please let me know.
> >> >>
> >> >> Thank you for your time.
> >> >>
> >> >> Regards,
> >> >> Iraklis
> >> >>
> >> >> 2015-11-22 19:48 GMT+02:00 Damjan Jovanovic :
> >> >>
> >> >> > Hi Iraklis
> >> >> >
> >> >> > Sorry for the late reply.
> >> >> >
> >> >> > Writer and Impress have their wiki pages on:
> >> >> > https://wiki.openoffice.org/wiki/Writer
> >> >> > https://wiki.openoffice.org/wiki/Impress
> >> >> >
> >> >> > Writer is our biggest user-facing application, double the size of
> the
> >> >> next
> >> >> > biggest (Calc). If you want to get started with them, finding
> issues
> >> with
> >> >> > Bugzilla is probably best. I've never developed either, so if you
> are
> >> >> still
> >> >> > looking for development suggestions from me, they will have to be
> on
> >> >> other
> >> >> > things for now.
> >> >> >
> >> >> > Regards
> >> >> > Damjan
> >> >> >
> >> >> > On Tue, Nov 10, 2015 at 10:25 PM, Ηρακλής Μουτίδης <
> >> imout...@gmail.com>
> >> >> > wrote:
> >> >> >
> >> >> > > Hi Damjan,
> >> >> > >
> >> >> > > I often use Writer and Impress and i can say that i am interested
> >> on
> >> >> > these,
> >> >> > > but i really dont know how it actually is to develope on them.
> >> >> > > I think after completing some easy tasks i will able to say what
> i
> >> >> prefer
> >> >> > > to do. I am open to suggestions and i hope with a little of your
> >> help i
> >> >> > > will be ok.
> >> >> > >
> >> >> > > Thanks a ton for your time.
> >> >> > >
> >> >> > > Regards.
> >> >> > >
> >> >> > > 

Re: MWiki home page cleanup

[Marcus]

Am 12/13/2015 04:10 PM, schrieb Andrea Pescetti:

Marcus wrote:

yes, I can edit all other pages. Didn't know that the first page wants
to be treated special. ;-)


You should now be able to edit it too. And if this worked for you then
anyone else who wants to be able to edit the home page can simply ask
here for full rights.


But I've just one thing: Please avoid to link to the "other.html"
webpage as it is no longer maintained - and also because it will be
deleted someday as the normal download webpage is its successor.


OK, removed.


My suggestion for the first 2 bullet points of "Get latest released
software" is to combine them:
- For the most current release and all language packs see the [Download
website]


Done, but still please check that you can edit the homepage now.


thanks, I can do changes now on my own.

Marcus


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

Re: Calc Selections of Entire Rows and Columns

[Damjan Jovanovic]

On Sun, Dec 13, 2015 at 6:12 PM, Dennis E. Hamilton 
wrote:

> The TL;DR: For full row and column selections in formulas, the trick is to
> arrange to accept something like A:A and to recognize the explicit OO.o
> idiom (i.e., A$1:A$1048576) and show it as A:A.  The trick is to always
> write, in the OpenFormula, A$1:A$1048576, regardless of the form it was
> read/input, and always display as A:A in the presented formula.  That is,
> always write the idiom but recognize both it and the general form (and all
> variations of course) as the general form.
>
> This will work with ODF Spreadsheets across AOO, LibreOffice, and
> ODF-1.2-supporting Excel versions.  It also works down-level to older
> versions of AOO, LibO, OpenOffice.org, etc., wherever they are still in use.
>
> PS: I looked for a Bugzilla issue on this enhancement but couldn't find
> it.  I will look again.
>

The issue was duplicated countless times, but the earliest report seems to
be https://bz.apache.org/ooo/show_bug.cgi?id=20495


> PPS: It might work just to say "=A" instead of "A:A" in the case of a
> single column.  For rows it is trickier and might need the [.2] notation.
> (In the UI, there is ambiguity with numerical values and named variables
> otherwise.)  Note that the way =A:A is recorded using OpenFormula in the
> file itself is with  element attribute
> table:formula="of:=[.A$1:.A$1048576]", using the OO.o-specific idiom.  When
> Excel produces ODF spreadsheet documents, it records the user's =A:A using
> the general form table:formula="of:=[.A:.A]", and it accepts the explicit
> form too (a little nod to the OpenOffice.org idiom in the spirit of
> interoperability).
>
>
"=A" is also problematic if "A" is a named range.

The patch Jatin sent me to review already allows entering A:A and 1:1, and
writes A:A as [.A$1:.A$1048576], but re-reads it as A$1:A$1048576. It can
read [.A:.A] but also converts it to A$1:A$1048576.


>  - Dennis
>
>
Damjan


> > -Original Message-
> > From: Dennis E. Hamilton [mailto:orc...@apache.org]
> > Sent: Saturday, December 12, 2015 19:50
> > To: dev@openoffice.apache.org
> > Cc: dam...@apache.org; '#PATHANGI JANARDHANAN JATINSHRAVAN#'
> > 
> > Subject: Calc Selections of Entire Rows and Columns
> >
> > The specification of entire rows and columns in cell range addresses is
> > covered in the ODF 1.2 specification.  Part 1 provides some detail in
> > section 9.2.4 Column and Row Range Addresses.  The OpenFormula
> > specification (ODF 1.2 Part 2) provides syntax for it in section 5.8
> > References.
> >
> > This is what is communicated in the ODF for a Spreadsheet document.
> > This is not necessarily the format shown for a cell formula in the UI,
> > or as entered in the formula-entry field.
> >
> > It would be good to see what happen with these on entry (and where any
> > intersection rules apply) and also when encountered in the document
> > files.
> >
> > EXAMPLE
> >
> > I made an Excel 2016 .xlsx file that computers Fibonacci numbers in
> > column A.  (A1 is 1, A2 is 1, A3 = A1 + A2, further values in Column A
> > by filling down from A3 to row 26 (arbitrary choice).  I set B1 = A:A
> > and then did a fill down to B26.  Each of the cell still had the formula
> > =A:A and the value was that of the adjacent A cell.
> >
> > I was able to save this as a *.ods file.  When I reopened it in Excel,
> > it had preserved the same formulas.
> >
> > When I opened the .xlsx in LibreOffice Calc, it also preserved the =A:A
> > formulas in the opened sheet.  Likewise, the .ods =A:A files were
> > preserved.
> >
> > AOO Calc rewrote each =A:A from Excel as =A$1:A$1048576.  AOO Calc
> > preserved the =A:A formulas in the .ods but evaluated them as #NAME?
> >
> > INTEROPERABILITY ISSUES
> >
> > An interesting problem this creates in interchange is the fact that all
> > previous versions of AOO will fail if the =A:A and other cases of full
> > column/row selections are now produced in the .ods document.  That will
> > also be the case with documents from LibreOffice since =A:A and its
> > cousins have been working.
> >
> > LibreOffice avoids this down-level interoperability problem by accepting
> > =A:A in Excel and .ods, but when the .ods file is saved, the =A:A cell
> > formulas are rewritten as =A$1:A$1048576.  I checked, that is what is
> > written in the OpenFormula values.
> >
> > Microsoft Excel 2016, when it sees these in an .ods file, it presents
> > =A:A in the formula window.  And so does LibreOffice on rereading even
> > the one it appears to writes.  Classy.
> >
> > So, when =A:A and related cell ranges are supported, they should be
> > written out with the max ranges (i.e., A$1:A$1048576) in the spreadsheet
> > file, and those can be presented as =A:A to users and accepted from
> > users, etc.
> >
> > Vey intereting.
> >
> >  - Dennis
> >
> >
> > > -Original Message-
> > > From: Damjan Jovanovic [mailto:dam...@apache.org]
> > > Sent: 

RE: Calc Selections of Entire Rows and Columns

[Dennis E. Hamilton]

The TL;DR: For full row and column selections in formulas, the trick is to 
arrange to accept something like A:A and to recognize the explicit OO.o idiom 
(i.e., A$1:A$1048576) and show it as A:A.  The trick is to always write, in the 
OpenFormula, A$1:A$1048576, regardless of the form it was read/input, and 
always display as A:A in the presented formula.  That is, always write the 
idiom but recognize both it and the general form (and all variations of course) 
as the general form.  

This will work with ODF Spreadsheets across AOO, LibreOffice, and 
ODF-1.2-supporting Excel versions.  It also works down-level to older versions 
of AOO, LibO, OpenOffice.org, etc., wherever they are still in use.

PS: I looked for a Bugzilla issue on this enhancement but couldn't find it.  I 
will look again.

PPS: It might work just to say "=A" instead of "A:A" in the case of a single 
column.  For rows it is trickier and might need the [.2] notation.  (In the UI, 
there is ambiguity with numerical values and named variables otherwise.)  Note 
that the way =A:A is recorded using OpenFormula in the file itself is with 
 element attribute table:formula="of:=[.A$1:.A$1048576]", 
using the OO.o-specific idiom.  When Excel produces ODF spreadsheet documents, 
it records the user's =A:A using the general form table:formula="of:=[.A:.A]", 
and it accepts the explicit form too (a little nod to the OpenOffice.org idiom 
in the spirit of interoperability).

 - Dennis

> -Original Message-
> From: Dennis E. Hamilton [mailto:orc...@apache.org]
> Sent: Saturday, December 12, 2015 19:50
> To: dev@openoffice.apache.org
> Cc: dam...@apache.org; '#PATHANGI JANARDHANAN JATINSHRAVAN#'
> 
> Subject: Calc Selections of Entire Rows and Columns
> 
> The specification of entire rows and columns in cell range addresses is
> covered in the ODF 1.2 specification.  Part 1 provides some detail in
> section 9.2.4 Column and Row Range Addresses.  The OpenFormula
> specification (ODF 1.2 Part 2) provides syntax for it in section 5.8
> References.
> 
> This is what is communicated in the ODF for a Spreadsheet document.
> This is not necessarily the format shown for a cell formula in the UI,
> or as entered in the formula-entry field.
> 
> It would be good to see what happen with these on entry (and where any
> intersection rules apply) and also when encountered in the document
> files.
> 
> EXAMPLE
> 
> I made an Excel 2016 .xlsx file that computers Fibonacci numbers in
> column A.  (A1 is 1, A2 is 1, A3 = A1 + A2, further values in Column A
> by filling down from A3 to row 26 (arbitrary choice).  I set B1 = A:A
> and then did a fill down to B26.  Each of the cell still had the formula
> =A:A and the value was that of the adjacent A cell.
> 
> I was able to save this as a *.ods file.  When I reopened it in Excel,
> it had preserved the same formulas.
> 
> When I opened the .xlsx in LibreOffice Calc, it also preserved the =A:A
> formulas in the opened sheet.  Likewise, the .ods =A:A files were
> preserved.
> 
> AOO Calc rewrote each =A:A from Excel as =A$1:A$1048576.  AOO Calc
> preserved the =A:A formulas in the .ods but evaluated them as #NAME?
> 
> INTEROPERABILITY ISSUES
> 
> An interesting problem this creates in interchange is the fact that all
> previous versions of AOO will fail if the =A:A and other cases of full
> column/row selections are now produced in the .ods document.  That will
> also be the case with documents from LibreOffice since =A:A and its
> cousins have been working.
> 
> LibreOffice avoids this down-level interoperability problem by accepting
> =A:A in Excel and .ods, but when the .ods file is saved, the =A:A cell
> formulas are rewritten as =A$1:A$1048576.  I checked, that is what is
> written in the OpenFormula values.
> 
> Microsoft Excel 2016, when it sees these in an .ods file, it presents
> =A:A in the formula window.  And so does LibreOffice on rereading even
> the one it appears to writes.  Classy.
> 
> So, when =A:A and related cell ranges are supported, they should be
> written out with the max ranges (i.e., A$1:A$1048576) in the spreadsheet
> file, and those can be presented as =A:A to users and accepted from
> users, etc.
> 
> Vey intereting.
> 
>  - Dennis
> 
> 
> > -Original Message-
> > From: Damjan Jovanovic [mailto:dam...@apache.org]
> > Sent: Thursday, December 10, 2015 09:07
> > To: Apache OO 
> > Cc: imout...@gmail.com
> > Subject: Re: Introducing my self and my goals.
> >
> [ ... ]
> > * Calc doesn't provide whole row/column references like C:C or 5:5
> while
> > Excel does, which are helpful to use in implicit intersection, among
> > others
> > (eg. in cell E34, you don't need to use D34 to refer to the cell just
> to
> > the left, you can just type D:D and it will automatically use the
> > current
> > row).
> [ ... ]
> 
> 
> -
> To unsubscribe, e-mail: 

Introducing myself and goal

[Huy Nguyen]

Hi everyone, my name is Huy Nguyen. I'm currently a senior at Univerisy of
California Davis. I have 2 years experience with C++ and slightly farmilar
with Java. I already obtained the source code yesterday. Does anyone know
what I can help with since I'm currently on winter break? (Maybe something
small). Also, does anyone have time to quickly guide me through or
suggestion? Thanks!

RE: Calc Selections of Entire Rows and Columns

[Dennis E. Hamilton]

+1 Good enough.

Display the general form instead of the OO.o idiom would be better, in terms of 
what is probably a more-desirable form recognized as such in a wider community, 
and what would be good to encourage.  

The key thing is to no longer fail on receiving A:A and its counterparts.

 - Dennis

> -Original Message-
> From: Damjan Jovanovic [mailto:dam...@apache.org]
> Sent: Sunday, December 13, 2015 08:57
> To: Dennis Hamilton 
> Cc: Apache OO ; #PATHANGI JANARDHANAN
> JATINSHRAVAN# 
> Subject: Re: Calc Selections of Entire Rows and Columns
> 
> On Sun, Dec 13, 2015 at 6:12 PM, Dennis E. Hamilton 
> wrote:
[ ... ]
> > PS: I looked for a Bugzilla issue on this enhancement but couldn't
> find
> > it.  I will look again.
> >
> 
> The issue was duplicated countless times, but the earliest report seems
> to
> be https://bz.apache.org/ooo/show_bug.cgi?id=20495
> 
[ ... ]
> "=A" is also problematic if "A" is a named range.
> 
> The patch Jatin sent me to review already allows entering A:A and 1:1,
> and
> writes A:A as [.A$1:.A$1048576], but re-reads it as A$1:A$1048576. It
> can
> read [.A:.A] but also converts it to A$1:A$1048576.
> 
[ ... ]


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

RE: Calc Selections of Entire Rows and Columns

[Dennis E. Hamilton]

> -Original Message-
> From: Andreas Säger [mailto:saege...@t-online.de]
> Sent: Sunday, December 13, 2015 13:15
> To: dev@openoffice.apache.org
> Subject: Re: Calc Selections of Entire Rows and Columns
> 
> Am 13.12.2015 um 17:12 schrieb Dennis E. Hamilton:
> > The TL;DR: For full row and column selections in formulas, the trick
> is to arrange to accept something like A:A and to recognize the explicit
> OO.o idiom (i.e., A$1:A$1048576) and show it as A:A.  The trick is to
> always write, in the OpenFormula, A$1:A$1048576, regardless of the form
> it was read/input, and always display as A:A in the presented formula.
> That is, always write the idiom but recognize both it and the general
> form (and all variations of course) as the general form.
> >
> 
> There is a difference between A:A and A$1:A$1048576 in Excel and
> Gnumeric: When you delete rows, A:A remains A:A whereas A$1:A$1048576
> shrinks. Any reference to the last cell A$1048576 moves up but any A:A
> reference remains the same regardless how many and how often you delete
> cells. In the age of spreadsheet databases this may be a problem when
> you count on this behaviour.
[orcmid] 
Thanks Andreas,

Do you recommend the A:A unchanging behavior or the A$1:A$1048576 shrinking 
behavior?  Do folks depend on the shrinking behavior of the idiom?

Won't the unchanging A:A type of behavior be more complicated to achieve?  It 
means having true full column and full row recognized and displayed, including 
input of the idiom form files, but using the idiom on output of ODF 1.2 open 
formulas to preserve interoperability with older implementations.

PS: I notice if I insert rows, the range doesn't change.  Only if I delete rows 
does the range shrink.  So if I add rows and then take them out, the range 
decreases.  Not exactly marvelous.  

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


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

Re: Calc Selections of Entire Rows and Columns

[Andreas Säger]

Am 13.12.2015 um 17:12 schrieb Dennis E. Hamilton:
> The TL;DR: For full row and column selections in formulas, the trick is to 
> arrange to accept something like A:A and to recognize the explicit OO.o idiom 
> (i.e., A$1:A$1048576) and show it as A:A.  The trick is to always write, in 
> the OpenFormula, A$1:A$1048576, regardless of the form it was read/input, and 
> always display as A:A in the presented formula.  That is, always write the 
> idiom but recognize both it and the general form (and all variations of 
> course) as the general form.  
> 

There is a difference between A:A and A$1:A$1048576 in Excel and
Gnumeric: When you delete rows, A:A remains A:A whereas A$1:A$1048576
shrinks. Any reference to the last cell A$1048576 moves up but any A:A
reference remains the same regardless how many and how often you delete
cells. In the age of spreadsheet databases this may be a problem when
you count on this behaviour.

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

RE: Calc Selections of Entire Rows and Columns

[Dennis E. Hamilton]

Is there a Bugzilla issue with Jatin's patch?

> -Original Message-
> From: Damjan Jovanovic [mailto:dam...@apache.org]
> Sent: Sunday, December 13, 2015 08:57
> To: Dennis Hamilton 
> Cc: Apache OO ; #PATHANGI JANARDHANAN
> JATINSHRAVAN# 
> Subject: Re: Calc Selections of Entire Rows and Columns
[ ... ]
> "=A" is also problematic if "A" is a named range.
> 
> The patch Jatin sent me to review already allows entering A:A and 1:1,
> and
> writes A:A as [.A$1:.A$1048576], but re-reads it as A$1:A$1048576. It
> can
> read [.A:.A] but also converts it to A$1:A$1048576.
[ ... ]


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

New Committer: Don Lewis (truckman)

[Dennis E. Hamilton]

[BCC AOO PMC]

The Project Management Committee (PMC) for Apache OpenOffice is pleased to
announced that Don Lewis has accepted and taken the ID truckman.

A warm welcome to Don Lewis.

Regards,

 Dennis Hamilton, on behalf of the Apache OpenOffice PMC




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

Re: New Committer: Don Lewis (truckman)

[Keith N. McKenna]

Dennis E. Hamilton wrote:
> [BCC AOO PMC]
> 
> The Project Management Committee (PMC) for Apache OpenOffice is pleased to
> announced that Don Lewis has accepted and taken the ID truckman.
> 
> A warm welcome to Don Lewis.
> 
> Regards,
> 
>  Dennis Hamilton, on behalf of the Apache OpenOffice PMC
> 
Congratulations Don.

Keith



signature.asc
Description: OpenPGP digital signature

RE: Calc Selections of Entire Rows and Columns

[Dennis E. Hamilton]

I took another look at the A$1:A$1048576 shrinkage by deletion of rows having 
such cells and also having them in surrounding rows.

If an OpenOffice.org descendant, including AOO, saves a result of such 
shrinkage, it stays shrunk.  That is, AOO, LibreOffice, and Excel2016 will 
accept the shrunken range as exact and *not* treat it as A:A.

If enough insertions are made to such a file to get to A$1:A$1048576 in either 
LibreOffice 5.0 or Excel 2016, the range is displayed as A:A again.  AOO simply 
maxes out at the idiom value.

If LibreOffice opens a .ods having A:A produced by Excel, and deletes rows as 
above, the range remains A:A.  Ditto if Excel does that with a .ods produced by 
LibreOffice.

There appears to be a clear pattern on how this works for interoperability 
among those ODF-supporting products that recognize A:A in their UI and in 
spreadsheets that they open where there is either =[.A:.A] or 
=[.A$1:.A$1048576] being taken as A:A on input of the OpenFormula in the .ods.

There are more test cases to nail down the apparent principle.  The pattern 
seems clear enough to see if that is confirmed with other tests.

 - Dennis


> -Original Message-
> From: Dennis E. Hamilton [mailto:orc...@apache.org]
> Sent: Sunday, December 13, 2015 13:54
> To: dev@openoffice.apache.org
> Subject: RE: Calc Selections of Entire Rows and Columns
> 
> > -Original Message-
> > From: Andreas Säger [mailto:saege...@t-online.de]
> > Sent: Sunday, December 13, 2015 13:15
> > To: dev@openoffice.apache.org
> > Subject: Re: Calc Selections of Entire Rows and Columns
> >
> > Am 13.12.2015 um 17:12 schrieb Dennis E. Hamilton:
> > > The TL;DR: For full row and column selections in formulas, the trick
> > is to arrange to accept something like A:A and to recognize the
> explicit
> > OO.o idiom (i.e., A$1:A$1048576) and show it as A:A.  The trick is to
> > always write, in the OpenFormula, A$1:A$1048576, regardless of the
> form
> > it was read/input, and always display as A:A in the presented formula.
> > That is, always write the idiom but recognize both it and the general
> > form (and all variations of course) as the general form.
> > >
> >
> > There is a difference between A:A and A$1:A$1048576 in Excel and
> > Gnumeric: When you delete rows, A:A remains A:A whereas A$1:A$1048576
> > shrinks. Any reference to the last cell A$1048576 moves up but any A:A
> > reference remains the same regardless how many and how often you
> delete
> > cells. In the age of spreadsheet databases this may be a problem when
> > you count on this behaviour.
> [orcmid]
> Thanks Andreas,
> 
> Do you recommend the A:A unchanging behavior or the A$1:A$1048576
> shrinking behavior?  Do folks depend on the shrinking behavior of the
> idiom?
> 
> Won't the unchanging A:A type of behavior be more complicated to
> achieve?  It means having true full column and full row recognized and
> displayed, including input of the idiom form files, but using the idiom
> on output of ODF 1.2 open formulas to preserve interoperability with
> older implementations.
> 
> PS: I notice if I insert rows, the range doesn't change.  Only if I
> delete rows does the range shrink.  So if I add rows and then take them
> out, the range decreases.  Not exactly marvelous.
> 
> >
> > -
> > To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
> > For additional commands, e-mail: dev-h...@openoffice.apache.org
> 
> 
> -
> To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: dev-h...@openoffice.apache.org


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

Re: Localization

[#PATHANGI JANARDHANAN JATINSHRAVAN#]

Hi Shamsheer, 
Have you taken a look at this page: 
https://www.openoffice.org/l10n/? Looks like Urdu translation has not even 
started. 

Thanks
Jatin


From: shamsheersaifi . 
Sent: Sunday, December 13, 2015 11:14 PM
To: dev@openoffice.apache.org
Subject: Localization

Hello, there,

  This is Shamsheer,  I am new to the localization process of Open
Office in Urdu, I know well how to write and read Urdu on Computer and
also aware of OpenOffice, I am interested to localize "Open Office" in
Urdu. Please direct me to the right path.
Thanks in advance.

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

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