On 12/30/2009 01:06 PM, cdmarrero2040@gmail.com wrote: > Hi, > > Ifound this > in(http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=18929)and > it works for me using 3.1.1-11 ~ bpo50 +1: > > The problem is that the syntax check in areasdlg.cxx fails if there is no > formula grammar specified in the user configuration. In that case > lcl_CheckRepeatOne() just returns "false" instead of trying with the > default > grammar. As a workaround try the following: > > 1. Select Tools/Options... from the menu > 2. In the left tree navigate to OpenOffice.org Calc/Formula > 3. Click on the Arrow right to "Calc A1" to see the list of possible > grammars > and select "Calc A1" explicitely from the dropdown list (even if it was > already > selected) > 4. Press "OK" to save these steps resolved the problem for me. I can now specify row ranges to repeat for printing. In fact, i didn't even need to explicitly select "Calc A1" from the drop-down list (as it as already selected). I just pressed "OK". I tried this out from a test account, with no initial ~/.openoffice.org* at all, and got the error message before doing this step. after visiting Options/OO.o Calc/Formulas and clicking "OK", i was able to successfully set "Print Ranges" "Rows to Repeat". To make sure that the setting was actually applied, I tested this all with PDF export (i don't have a printer configured on this machine), and the rows are indeed repeated. > If that doesn't work at once you may try to select some other grammar, > save, > and then revert back to "Calc A1" and save again. Please report if it > worked > for you or not. i didn't need to do this extra "OK"/Options cycle. thanks for finding this workaround! maybe this'll be a good hint for what needs to be fixed to repair it for normal users who wouldn't normally take these steps. regards, --dkg
Attachment:
signature.asc
Description: OpenPGP digital signature