If you mean a comment (note) attached to a cell,
see section "Editing comments" at the following link:
https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/Adding_notes
Regards,
Czesław
-
To unsubscri
I'm working in Apache Openoffice Spreadsheet, have a (comment) with a
web-site address . . . unable to copy and paste from the (comment) ?
-
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional com
Hello,
> -Original Message-
> From: James Jenkins [mailto:ljenki...@centurylink.net]
> Sent: Tuesday, January 26, 2021 5:09 PM
> To: Apache Openoffice
> Subject: simple "clipboard" needed for write and spreadsheet
>
> I've been using "OO"
The clipboard is part of your operating system, not of OpenOffice
- Mail original -
> De: "James Jenkins"
> À: "Apache Openoffice"
> Envoyé: Mardi 26 Janvier 2021 17:09:17
> Objet: simple "clipboard" needed for write and spreadsheet
>
>
I've been using "OO" for many years, now need a clipboard, don't really
want to go to "Libre"
I need a simple "Clipboard" for "OO" for both spreadsheet and write
Win10 (64 bit)
Am 07.12.19 um 23:35 schrieb T.phd:
When I click on a cell, the page will *jump* to the right hiding the
cell I clicked on.
When clicking on the vertical scroll bar, the page will very quickly
scroll to the right.
do you mix up vertical with horizontal? When I click on the vertical
scrollba
Greetings,
I've hunted the forum for an answer without success.
When I click on a cell, the page will *jump* to the right hiding the
cell I clicked on.
When clicking on the vertical scroll bar, the page will very quickly
scroll to the right.
I have uninstalled and reinstalled 4.1.7.
I don
consumption and using the result in a formula for
> next cell.. But this mail is not about that. I was trying to find how to
> make my spreadsheet to fill cells according to previous cell, and finally
> I've found, that there is no option for that, so I created a long formula
> based o
I have made
one bug report about calculating time consumption and using the result
in a formula for next cell.. But this mail is not about that. I was
trying to find how to make my spreadsheet to fill cells according to
previous cell, and finally I've found, that there is no option for
that, so
Original Message
From: ed tinervin
To: dev@openoffice.apache.org
Date: Fri, 2 Feb 2018 11:48:23 + (utc)
> I have not found anything to tell me how to print the cell lines in the
> spreadsheet. Can you help Thanks
Hi Ed,
How-to questions like this are best addres
I have not found anything to tell me how to print the cell lines in the
spreadsheet. Can you help Thanks
Currentproblem: When I put the <=> sign in a spreadsheet cell and thengo to the
'Location Cell' which is situated just
abovethe column headings on the left side of the screen and click on
thelocation cell, there appears a partial list of
functionsbe
Issue reported:
https://bz.apache.org/ooo/show_bug.cgi?id=92357
- Mail original -
De: "FR web forum"
À: dev@openoffice.apache.org
Envoyé: Vendredi 16 Décembre 2016 09:01:51
Objet: Re: Chart SubTitles Do Not Get Saved In Spreadsheet
Hello,
This happens if your document is sa
Décembre 2016 19:40:07
Objet: Chart SubTitles Do Not Get Saved In Spreadsheet
Hello,
I configured several charts in a spreadsheet. When I double click on a chart
and then right click on it, a dialog box opens and allows me to click on
“Insert Titles”. The next dialog box that opens allows
Hello,
I configured several charts in a spreadsheet. When I double click on a chart
and then right click on it, a dialog box opens and allows me to click on
“Insert Titles”. The next dialog box that opens allows me to enter a Title and
Subtitle among other things. When I enter the Title and
readsheets for more than a year
and installed 4.1.2 a long time ago. Yesterday I went t open a spreadsheet that
I have been adding to for about two months. All of a sudden I can't open any
spreadsheet with Open Office. I reinstalled 4.1.2 but that has made no
difference. What do I do
preciated.
> I've been using Open Office for Word Pad and Spreadsheets for more than a
> year and installed 4.1.2 a long time ago. Yesterday I went t open a
> spreadsheet that I have been adding to for about two months. All of a sudden
> I can't open any spreadsheet with Open
open a spreadsheet that
I have been adding to for about two months. All of a sudden I can't open any
spreadsheet with Open Office. I reinstalled 4.1.2 but that has made no
difference. What do I do next to open my spreadsheets?
Just wanted to add that I thought about uninstalling Open Off
Letting everyone know the status
Howard
___
From: Mike Rivera
Sent: Tuesday, January 26, 2016 7:12 PM
To: Howard Morris (aka Col Boogie)
Subject: Re: First Problem is Spreadsheet
I tried again & it wo
ed it again and still didn't
work...
On Monday, January 25, 2016 10:01 PM, Howard Morris (aka Col Boogie)
wrote:
Thank you,
I am a bit confused. Your example shows “trf to chking”. I did not find that
in the spreadsheet you sent me. However, I did a little testing. I did som
Thank you,
I am a bit confused. Your example shows “trf to chking”. I did not find that
in the spreadsheet you sent me. However, I did a little testing. I did some
testing anyway, and some curious things happened. Sometimes when I changes
things, the value was not recalculated. However, when
value as part of another
sum.
Howard Morris
PS. It would be easier for us if you sent a copy of the spreadsheet and tell us
which cell you are getting erroneous results.
Hi, I love your software but, I have encountered a problem with it. I use it as
a budget spreadsheet and suddenly one of the boxes that keeps my balance
correctly does not do so... I've had to write in the amount cause no matter
what I do, it does not calculate correctly... Please rep
On Mon, Oct 5, 2015 at 11:02 AM, Oliver Brinzing
wrote:
> Hi,
>
> > There seems to be an issue of how some1900 dates are being stored in the
> OpenOffice spreadsheet.
>
>> It is my understanding that dates are stored with spreadsheet as a serial
>> number starting w
Hi,
> There seems to be an issue of how some1900 dates are being stored in the
OpenOffice spreadsheet.
It is my understanding that dates are stored with spreadsheet as a serial
number starting with 01/01/1900
being stored as a '1'.
When 01/01/1900 is looked at as a general num
There seems to be an issue of how some1900 dates are being stored in the
OpenOffice spreadsheet.
It is my understanding that dates are stored with spreadsheet as a serial
number starting with 01/01/1900
being stored as a '1'.
When 01/01/1900 is looked at as a general number
On 09.09.2013 22:03, Andrea Pescetti wrote:
On 03/09/2013 Herbert Duerr wrote:
That's a good idea. Here is a first very rough draft:
https://blogs.apache.org/roller-ui/authoring/preview/OOo/?previewEntry=writing_spreadsheet_test_cases_now
That link is behind an editor password. Here's the publ
I need help on steps to make the build on fedora 19.
Please give me steps in simple language with terminal code.
It is urgent. I'm a student of University of Moratuwa,doing a project to
give predictive text for Open Office.
Reply me ASAP,im stuck on the build.
On Mon, Sep 9, 2013 at 4:03 PM, Andr
On 03/09/2013 Herbert Duerr wrote:
That's a good idea. Here is a first very rough draft:
https://blogs.apache.org/roller-ui/authoring/preview/OOo/?previewEntry=writing_spreadsheet_test_cases_now
That link is behind an editor password. Here's the public preview link:
https://blogs.apache.org/pr
On 02.09.2013 21:25, Andrea Pescetti wrote:
On 27/08/2013 Herbert Duerr wrote:
A good idea. I just wrote a task [1] and a script [2] that takes a
slightly modified version of Regina's sample document and checks whether
all of its tests pass. This script is now part of the Functional
Verification
On 27/08/2013 Herbert Duerr wrote:
A good idea. I just wrote a task [1] and a script [2] that takes a
slightly modified version of Regina's sample document and checks whether
all of its tests pass. This script is now part of the Functional
Verification Test (a.k.a. FVT).
[1] https://issues.apache
j...@apache.org has granted Armin Le Grand 's request for
4.0.1_release_blocker:
Bug 122982: Copying spreadsheet into another document in bit map format has
disappeared in Version 4. Worked on Version 3.
https://issues.apache.org/ooo/show_bug.cgi?id=122982
--- Additional Comments f
Armin Le Grand has asked for 4.0.1_release_blocker:
Bug 122982: Copying spreadsheet into another document in bit map format has
disappeared in Version 4. Worked on Version 3.
https://issues.apache.org/ooo/show_bug.cgi?id=122982
--- Additional Comments from Armin Le Grand
ALG: Okay, looks
On 28.08.2013 16:04, Rob Weir wrote:
On Wed, Aug 28, 2013 at 10:00 AM, Herbert Duerr wrote:
[...]
Yes, just keep the test-ids of the rows with intermediate results empty.
They will be ignored.
Marking lines to ignore with content in a specific column -- this is
so FORTRAN. I love it.
I thi
" so it doesn't matter
> in which columns they are. For performance reason it doesn't check every one
> of the 32 million possible cell positions for these markers but only the
> first 8x8 cells for now. These limits can be increased, but as the test
> documents are also intend
t; and "TestOK" (and not the column index) this
would be best.
Yes. The other columns are completely ignored. They are just for making
the calculation clean and obvious for the reader of the spreadsheet.
2) Some functions operate on ranges and require additional data, stuff
that cann
rn values into a
range. Maybe in those cases we would do the calculation in an special
"test data" area of the sheet, and then have test cases, one per row,
to test each value of the returned matrix. So a 2x2 matrix would have
4 test rows.
Regards,
-Rob
>> For example, one
&g
cases for IF(), TRUE(), FALSE() and a
handful of other core functions written in Java, not requiring a test
spreadsheet.
Core functionionality must be checked in one of the pure automatic test
suites like BVT ("Build Verification Tests") or FVT ("Functional
Verification Tests"
-programmers, and then
automated testing of these sheets, then we'll have the best of both
worlds.
I assume we'd want to agree on a test template. For example, one
approach is to bootstrap the tests like this:
1) Have the fundamental test cases for IF(), TRUE(), FALSE() and a
handful of
On 25.08.2013 16:12, Andrea Pescetti wrote:
On 19/08/2013 Herbert Duerr wrote:
An example of a test case where a formula ("addition") is checked is in
[1]. This file is clean and easy enough that it could be used as a
template for more formula checks.
[1]
http://svn.apache.org/repos/asf/openoffi
Hi Andrea,
Andrea Pescetti schrieb:
On 19/08/2013 Herbert Duerr wrote:
An example of a test case where a formula ("addition") is checked is in
[1]. This file is clean and easy enough that it could be used as a
template for more formula checks.
[1]
http://svn.apache.org/repos/asf/openoffice/trun
On 19/08/2013 Herbert Duerr wrote:
An example of a test case where a formula ("addition") is checked is in
[1]. This file is clean and easy enough that it could be used as a
template for more formula checks.
[1]
http://svn.apache.org/repos/asf/openoffice/trunk/test/testuno/source/fvt/uno/sc/formu
On Friday, August 16, 2013 13:32:30 Rob Weir wrote:
> Moving this topic to its own thread.
>
> It should be possible to code a very thorough set of test cases in a
> spreadsheet, without using macros or anything fancy. Just careful
> reading of the ODF 1.2 specification and sim
On 19 August 2013 11:41, Regina Henschel wrote:
> Hi Jan,
>
> janI schrieb:
>
>> On 19 August 2013 12:24, Regina Henschel wrote:
>>
> [..]
>
>>> But for both kind of testing there exists a problem with "expected
>>> values". For example, calculation of PMT needs expm1 and log1p, or
>>> calculatio
Hi Jan,
janI schrieb:
On 19 August 2013 12:24, Regina Henschel wrote:
[..]
But for both kind of testing there exists a problem with "expected
values". For example, calculation of PMT needs expm1 and log1p, or
calculation of LINEST needs lot of matrix calculation. It is not impossible
to calc
t;> It should be possible to code a very thorough set of test cases in a
>>>> spreadsheet, without using macros or anything fancy. Just careful
>>>> reading of the ODF 1.2 specification and simple spreadsheet logic.
>>>>
>>>>
>>> Foll
Hi Herbert,
Herbert Duerr schrieb:
On 16.08.2013 21:37, Regina Henschel wrote:
Rob Weir schrieb:
Moving this topic to its own thread.
It should be possible to code a very thorough set of test cases in a
spreadsheet, without using macros or anything fancy. Just careful
reading of the ODF 1.2
On 19.08.2013 11:18, janI wrote:
On 19 August 2013 10:43, Herbert Duerr wrote:
[...]
There is no need to develop a new framework. Please check Zhe Liu's
wonderful work on test automation that I referenced above [2] that is
already available in our "test/" directory. It is very powerful, clean a
On 19 August 2013 10:43, Herbert Duerr wrote:
> On 16.08.2013 21:37, Regina Henschel wrote:
>
>> Rob Weir schrieb:
>>
>>> Moving this topic to its own thread.
>>>
>>> It should be possible to code a very thorough set of test cases in a
>>&g
On 16.08.2013 21:37, Regina Henschel wrote:
Rob Weir schrieb:
Moving this topic to its own thread.
It should be possible to code a very thorough set of test cases in a
spreadsheet, without using macros or anything fancy. Just careful
reading of the ODF 1.2 specification and simple spreadsheet
;> Rob Weir schrieb:
>> >>
>> >>> Moving this topic to its own thread.
>> >>>
>> >>> It should be possible to code a very thorough set of test cases in a
>> >>> spreadsheet, without using macros or anything fancy. Just careful
thread.
> >>>
> >>> It should be possible to code a very thorough set of test cases in a
> >>> spreadsheet, without using macros or anything fancy. Just careful
> >>> reading of the ODF 1.2 specification and simple spreadsheet logic.
> >>>
On Fri, Aug 16, 2013 at 3:51 PM, janI wrote:
> On 16 August 2013 21:37, Regina Henschel wrote:
>
>> Hi Rob,
>>
>> Rob Weir schrieb:
>>
>>> Moving this topic to its own thread.
>>>
>>> It should be possible to code a very thorough set of
On Fri, Aug 16, 2013 at 3:37 PM, Regina Henschel
wrote:
> Hi Rob,
>
> Rob Weir schrieb:
>
>> Moving this topic to its own thread.
>>
>> It should be possible to code a very thorough set of test cases in a
>> spreadsheet, without using macros or anything fancy.
On 16 August 2013 21:37, Regina Henschel wrote:
> Hi Rob,
>
> Rob Weir schrieb:
>
>> Moving this topic to its own thread.
>>
>> It should be possible to code a very thorough set of test cases in a
>> spreadsheet, without using macros or anything fancy. Ju
Hi Rob,
Rob Weir schrieb:
Moving this topic to its own thread.
It should be possible to code a very thorough set of test cases in a
spreadsheet, without using macros or anything fancy. Just careful
reading of the ODF 1.2 specification and simple spreadsheet logic.
Following the spec is not
Moving this topic to its own thread.
It should be possible to code a very thorough set of test cases in a
spreadsheet, without using macros or anything fancy. Just careful
reading of the ODF 1.2 specification and simple spreadsheet logic.
I'd like to share an example of this that I create
that actually has the
>>>> IF() statement in it. AOO 4.0 and Excel show FALSE. Earlier versions
>>>> of AOO showed 0. In this sense we can have one default behavior or
>>>> the other, but not both.
>>>
>>> Could you not add a setting that cont
f the change.
>>>
>>> What is different is what appears in the cell that actually has the
>>> IF() statement in it. AOO 4.0 and Excel show FALSE. Earlier versions
>>> of AOO showed 0. In this sense we can have one default behavior or
>>> the other, bu
AOO showed 0. In this sense we can have one default behavior or
>> the other, but not both.
>
> Could you not add a setting that controls the behaviour?
>
> For a fresh install AOO 4.x will show FALSE.
> But if the user sets the appropriate backwards compatibilty option, it
&g
On 15 August 2013 14:47, Rob Weir wrote:
> On Thu, Aug 15, 2013 at 9:41 AM, janI wrote:
>> On Aug 15, 2013 3:06 PM, "Rob Weir" wrote:
>>>
>>> https://issues.apache.org/ooo/show_bug.cgi?id=122927
>>>
>>> It boils down to how an IF() statements are evaluated.
>>>
>>> Remember, the typical form is
d string. Things like currency,
date and boolean are just formats. You can type in a number like
123456 and format it as a number, a date, a boolean, etc.
The tricky part is that some formulas automatically set a format,
without requiring user intervention. So if I type =TODAY() into a a
cell I se
On Thu, Aug 15, 2013 at 9:41 AM, janI wrote:
> On Aug 15, 2013 3:06 PM, "Rob Weir" wrote:
>>
>> https://issues.apache.org/ooo/show_bug.cgi?id=122927
>>
>> It boils down to how an IF() statements are evaluated.
>>
>> Remember, the typical form is IF(Condition;X;Y) where you give a
>> return value
On Aug 15, 2013 3:06 PM, "Rob Weir" wrote:
>
> https://issues.apache.org/ooo/show_bug.cgi?id=122927
>
> It boils down to how an IF() statements are evaluated.
>
> Remember, the typical form is IF(Condition;X;Y) where you give a
> return value for the case where Condition is TRUE and another value
On 8/15/13 3:06 PM, Rob Weir wrote:
> https://issues.apache.org/ooo/show_bug.cgi?id=122927
>
> It boils down to how an IF() statements are evaluated.
>
> Remember, the typical form is IF(Condition;X;Y) where you give a
> return value for the case where Condition is TRUE and another value
> when C
https://issues.apache.org/ooo/show_bug.cgi?id=122927
It boils down to how an IF() statements are evaluated.
Remember, the typical form is IF(Condition;X;Y) where you give a
return value for the case where Condition is TRUE and another value
when Condition is FALSE.
But it is also possible to lea
j...@apache.org has granted liupingtan 's request for
4.0.0_release_blocker:
Bug 118986: [RTF export] crashes when copy an empty line from Writer below a
tif picture then paste into spreadsheet
https://issues.apache.org/ooo/show_bug.cgi?id=118986
--- Additional Comments from j...@apach
OPEN OFFICE
I WISH TO OPEN AND USE YOUR SPREADSHEET
HANK ZUBER
j...@apache.org has granted liupingtan 's request for
4.0.0_release_blocker:
Bug 120023: [Regression]Copy and Paste from OO Text doc to Spreadsheet on OO
V3.4
https://issues.apache.org/ooo/show_bug.cgi?id=120023
--- Additional Comments from j...@apache.org
grant showstopper flag, al
j...@apache.org has denied fanyuz...@gmail.com's request for
4.0.0_release_blocker:
Bug 121062: [From Symphony]It will lead AOO freeze when select all cells in
spreadsheet and paste the copied cells
https://issues.apache.org/ooo/show_bug.cgi?id=121062
--- Additional Comments f
ve not seen collected
> in one place before on localized names of Excel spreadsheet functions:
>
> http://wwwhome.ewi.utwente.nl/~trieschn/excel/excel.html
>
> Regards,
>
> -Rob
>
> -
> T
I came across this reference on the web and thought it might be
useful. Not sure what, but it has info that I have not seen collected
in one place before on localized names of Excel spreadsheet functions:
http://wwwhome.ewi.utwente.nl/~trieschn/excel/excel.html
Regards,
-Rob
> Create Componenet loader object using desktop object:
>
> XComponentLoader xComponentLoader = (XComponentLoader)
> UnoRuntime.queryInterface(XComponentLoader.class, desktop);
>
> Now U can use the function loadComponentFromURL to open a new
> spreadsheet/spr
entLoader.class, desktop);
Now U can use the function loadComponentFromURL to open a new
spreadsheet/spreadsheet from hardDisk.
Infact document files can also be loaded in the same way.
Read the dev-guide page step by step for more detailed explanation.
http://wiki.openoffice.org/wiki/Documen
9.04.2013 14:09, schrieb Winman Software:
while working with calc spreadsheet how should I start with.
how can I compile and run the spreadsheet program.
if I wish to work with front end development how can I continue.
Kind
have a simpler macro language modeled on older ones which
makes macros easy for the savvy, but non-programmer user.
Sincerely,
Fred
On Fri, Feb 8, 2013 at 12:29 PM, Rob Weir wrote:
> On Thu, Feb 7, 2013 at 1:40 PM, David A Yablonsky Sr
> wrote:
>> I am, if not a spreadsheet po
On Thu, Feb 7, 2013 at 1:40 PM, David A Yablonsky Sr
wrote:
> I am, if not a spreadsheet power user, at least a spreadsheet developer,
> since 1982. Having experienced Visicalc, Multiplan, Lotus and Lotus clones,
> Quattro and Excel and others, I have come to the sad conclusion that
>
I am, if not a spreadsheet power user, at least a spreadsheet developer,
since 1982. Having experienced Visicalc, Multiplan, Lotus and Lotus clones,
Quattro and Excel and others, I have come to the sad conclusion that
spreadsheet applications have become overdeveloped due to the influence of
Hi, Lucas
Yes, you can mark it as failed, and attach the defect number to the test
case.
Thanks.
Regards,
Shan Zhu
On Tue, Dec 11, 2012 at 7:39 AM, Lucas Burson wrote:
> Submitted as enhancement to BZ ([1]). I'll ignore the test case on
> TestLink.
>
> Lucas
>
> [1] https://issues.apache.or
Submitted as enhancement to BZ ([1]). I'll ignore the test case on
TestLink.
Lucas
[1] https://issues.apache.org/ooo/show_bug.cgi?id=121459
On Mon, Dec 10, 2012 at 11:20 AM, Lucas Burson wrote:
> Can we remove the test from TestLink or should I just mark it as failed?
> Since it isn't impleme
Can we remove the test from TestLink or should I just mark it as failed?
Since it isn't implemented it doesn't make much sense to have it as a
regression test.
On Dec 9, 2012 11:50 PM, "Zhang Lu" wrote:
> Hi Zhu shen,
>Sure, it can be implemented as a feature due to workload, thanks!
>
> On M
Hi Zhu shen,
Sure, it can be implemented as a feature due to workload, thanks!
On Mon, Dec 10, 2012 at 1:33 PM, Shan Zhu wrote:
> Hi, Lu
> It's okay. IMHO, it can be implemented as a feature enhancement. Then
> prepare a formal testing to verify this implementation. It will be better
> than c
Hi, Lu
It's okay. IMHO, it can be implemented as a feature enhancement. Then
prepare a formal testing to verify this implementation. It will be better
than checking it as defect verification.
Regards,
Shan Zhu
On Mon, Dec 10, 2012 at 1:23 PM, Zhang Lu wrote:
> Hi, Lucas and Shan
>
>There
Hi, Lucas and Shan
There is no code for checking the validation of input value as Zhu Shan
said, I have got through this part code, not only whole numbers, but also
all other categories existed this issue. So I think it can be handled as a
defect. If user input an illegal value, there is meani
Hi, Lucas
I think your scenario and expected result are reasonable.
In Validity dialog, Spreadsheet does not check whether the input in Value
field and the selection in Allow field are matched.
In MS Excel, it has been checked.
Regards,
Shan Zhu
On Sat, Dec 8, 2012 at 2:43 PM, Lucas Burson
Hi,
I'm doing a regression test on a Calc spreadsheet using data validity
for cells. It appears that if you open the validity window (toolbar
Data -> Validity) the 'Value' box isn't checked against the allowed
type. I don't see it in BZ... but I haven't used searc
86 matches
Mail list logo